Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

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

by Kanji (Parson)
on Dec 12, 2001 at 05:04 UTC ( #131131=note: print w/replies, xml ) Need Help??


in reply to 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" +;

    --k.


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)
    (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.)

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://131131]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (4)
As of 2020-04-05 02:48 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    The most amusing oxymoron is:
















    Results (33 votes). Check out past polls.

    Notices?