I recently downloaded DBD::ODBC for ActiveState Perl 5.8.0. I would like to connect ot an MS Access 2000 database. Is there a quick-reference or a tutorial for this somewhere on-line? I'm comfortable with Perl, and I've used DBD::Oracle at work, I just don't know if the same stuff applies to ODBC. Thanks! Unix Sys Admin
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Instructions for using DBD::ODBC to connect to an Access DB?
- Thread starter erulia
- Start date
erulia,
If you've used DBD::Oracle then DBD::ODBC should hold few surprises and no difficulties for you.
You will need to use the correct connect() statement - that will be defined in the DBD::ODBC documentation. Mike
Want to get great answers to your Tek-Tips questions? Have a look at faq219-2884
It's like this; even samurai have teddy bears, and even teddy bears get drunk.
If you've used DBD::Oracle then DBD::ODBC should hold few surprises and no difficulties for you.
You will need to use the correct connect() statement - that will be defined in the DBD::ODBC documentation. Mike
Want to get great answers to your Tek-Tips questions? Have a look at faq219-2884
It's like this; even samurai have teddy bears, and even teddy bears get drunk.
- Thread starter
- #3
Okay, here's a more specific question. I've attached to the database and gotten table information. Unfortunately, I don't have read/write access to some of the tables. This database is an Access 2000 database and I only have Access 97 installed, so I can't go in through MSAccess to make changes to it. Is there any way to change the permissions on a database that is stored on my own computer?? Thanks! Unix Sys Admin
- Status
Similar threads
