Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re: Accessing Access DB with DBI

by Rhose (Priest)
on Jun 03, 2004 at 20:52 UTC ( #360490=note: print w/ replies, xml ) Need Help??


in reply to Accessing Access DB with DBI

Here is some code I have for connecting to Access:

$DSN = 'dbi:ODBC:driver=Microsoft Access Driver (*.mdb);dbq='.$Databas +e; $DBH = DBI->connect($DSN, undef, undef) || ExitProg(ERR->{odbc},'['.$DBI::errstr.' - '.$DBI::err.']'); $DBH->{LongReadLen}=2048;

And here is some code I have for connecting to MS SQL Server:

$DSN = 'dbi:ODBC:driver={SQL Server};server={'.$Server.'};database={'. +$Database.'}'; $DBH = DBI->connect($DSN, undef, undef) || ExitProg(ERR->{odbc},'['.$DBI::errstr.' - '.$DBI::err.']');

Please note... ExitProg is a sub I use, and is probably not in your program. *Smiles* Also, you will need to fill in the blanks for $Database and $Server as well as set your own value for $DBH->{LongReadLen} (if you use "memo" fields).

One more also... I have "undef, undef" for username and password... if you need those, they are important to fill in. *Grins* (The example snippet was from a program which used Windows authentication to the database.)


Comment on Re: Accessing Access DB with DBI
Select or Download Code

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (17)
As of 2015-07-02 17:03 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (44 votes), past polls