Re: Access Database

It is a two step process. First register your database with windows ( ie create a DSN ):

Start|run|odbcad32
System DSN tab
Add
In create new datasource select Microsoft Access Driver
Click Finish
Now select your database and give it a name like 'mymdb'
OK away
[download]

This registers you Access MDB with the correct driver and the name 'mymdb'. You now connect like this and proceed as usual

  $dbh = DBI->connect("DBI:ODBC:mymdb" ....blah
[download]

cheers

tachyon

s&&rsenoyhcatreve&&&s&n.+t&"$'$`$\"$\&"&ee&&y&srve&&d&&print

Comment on Re: Access Database Select or Download Code

Replies are listed 'Best First'.
Re: Re: Access Database by mrortner (Initiate) on Feb 27, 2003 at 16:57 UTC
OK, I do a query in ppm and dbd-odbc shows up. Is this the right module?	[reply]
Re: Re: Re: Access Database by tachyon (Chancellor) on Feb 27, 2003 at 17:02 UTC
`# yes C:\>ppm install dbd-odbc` [download] cheers tachyon s&&rsenoyhcatreve&&&s&n.+t&"$'$`$\"$\&"&ee&&y&srve&&d&&print	[reply] [d/l]