Re: Connect to MS Access w/o ODBC, DSN, from Win32

DBD::ODBC (alt.) has supported DSN-less connections for awhile.

From the POD...

Connect without DSN
The ability to connect without a full DSN is introduced in version 0.21. Example (using MS Access):
my $DSN = 'driver=Microsoft Access Driver(*.mdb);dbq=\\\\cheese\\g$\\p
+erltest.mdb';
my $dbh = DBI->connect("dbi:ODBC:$DSN", '','') or die "$DBI::errstr\n"
+;
[download]

--k.

Comment on Re: Connect to MS Access w/o ODBC, DSN, from Win32 Download Code

Replies are listed 'Best First'.
Re: Re: Connect to MS Access w/o ODBC, DSN, from Win32 by chiller (Scribe) on Dec 13, 2001 at 02:43 UTC
Thanks, all. I tried the suggestions, but I get this error: `DBI->connect(driver=Microsoft Access Driver *.mdb);dbq=\\SERVER\My_Dat +abase.mdb) failed: [Microsoft][ODBC Driver Manager] Invalid string or + buffer length (SQL-S1090)(DBD: db_login/SQLConnect err=-1) at connec +t.pl line 7 [Microsoft][ODBC Driver Manager] Invalid string or buffer + length (SQL-S1090)(DBD: db_login/SQLConnect err=-1)` [download] (What I am attempting to do is: get table from Access DB on Novell server, determine if Access DB in local machine in the same version, then copy a new version to the local machine if there has been an update... sounds easy enough.)	[reply] [d/l]

Replies are listed 'Best First'.

Re: Re: Connect to MS Access w/o ODBC, DSN, from Win32
by chiller (Scribe) on Dec 13, 2001 at 02:43 UTC

DBI->connect(driver=Microsoft Access Driver *.mdb);dbq=\\SERVER\My_Dat
+abase.mdb) failed: [Microsoft][ODBC Driver Manager] Invalid string or
+ buffer length (SQL-S1090)(DBD: db_login/SQLConnect err=-1) at connec
+t.pl line 7 [Microsoft][ODBC Driver Manager] Invalid string or buffer
+ length (SQL-S1090)(DBD: db_login/SQLConnect err=-1)
[download]

[reply]
[d/l]