MS Access Database

[Big-Charge]

Hello, I was just wondering if I needed to download and special drivers for a Microsoft Access Database to communicate with it in a CGI script writtin with Perl. I am used to MySQL, and I recall that this was required. I was just wondering if you could help me, just give me all the info you know about this, because I don't know shit! (About MSA)

[Big-Charge]

Just fixing mistakes READ THIS VERSION, just a bit tired =P

Hello, I was just wondering if I needed to download any special drivers to communicate with a Microsoft Access Database in a CGI script written with Perl. I am used to MySQL, and I recall that this was required. I was just wondering if you could help me, just give me all the info you know about this, because I don't know shit! (About MSA)

[Pecos]

At 7/5/01 12:57 AM, Big_Charge wrote: Just fixing mistakes READ THIS VERSION, just a bit tired =P

Hello, I was just wondering if I needed to download any special drivers to communicate with a Microsoft Access Database in a CGI script written with Perl. I am used to MySQL, and I recall that this was required. I was just wondering if you could help me, just give me all the info you know about this, because I don't know shit! (About MSA)

Use ODBC drivers to communitcate with all Microsoft databases. Now find out how Perl would connect to ODBC.

But a much better solution would be to not use Access in the first place. :o)

Why not stay with mySQL?

[Big-Charge]

At 7/5/01 01:44 PM, MassiveBit wrote:

At 7/5/01 12:57 AM, Big_Charge wrote: Just fixing mistakes READ THIS VERSION, just a bit tired =P

Hello, I was just wondering if I needed to download any special drivers to communicate with a Microsoft Access Database in a CGI script written with Perl. I am used to MySQL, and I recall that this was required. I was just wondering if you could help me, just give me all the info you know about this, because I don't know shit! (About MSA)

Use ODBC drivers to communitcate with all Microsoft databases. Now find out how Perl would connect to ODBC.

But a much better solution would be to not use Access in the first place. :o)

Why not stay with mySQL?

I'd love to, but it's too late now. What is ODBC and where can I get it?

[digaleet]

At 7/6/01 10:43 PM, Big_Charge wrote:

At 7/5/01 01:44 PM, MassiveBit wrote:

At 7/5/01 12:57 AM, Big_Charge wrote: Just fixing mistakes READ THIS VERSION, just a bit tired =P

Hello, I was just wondering if I needed to download any special drivers to communicate with a Microsoft Access Database in a CGI script written with Perl. I am used to MySQL, and I recall that this was required. I was just wondering if you could help me, just give me all the info you know about this, because I don't know shit! (About MSA)

Use ODBC drivers to communitcate with all Microsoft databases. Now find out how Perl would connect to ODBC.

But a much better solution would be to not use Access in the first place. :o)

Why not stay with mySQL?

I'd love to, but it's too late now. What is ODBC and where can I get it?

ODBC is one of the more commonly used forms of database connectivity. Servers such as Microsoft SQL use ODBC.... Using a Microsoft Access *.MDB file as an ODBC data source is a little different that directly accessing an SQL server. You need to setup a File DSN entery in your system ODBC settings for the MDB file.... You do this in the control panel.... Win95/98, just click on the ODBC Icon, for Win2k, go to Administrative Tools>Data Sources (ODBC)... Check out the File DSN tab...

As far as ODBC and Perl connectivity, check out the CPAN archives.... Move your way over to ActiveState.Com (WinPerl32) and check out their ASPN section for more information.... Any perl modules you may need can be found in the CPAN archive....

Good Luck.
-Digaleet
[e-mail]

[Pecos]

At 7/6/01 10:43 PM, Big_Charge wrote: I'd love to, but it's too late now. What is ODBC and where can I get it?

ODBC (Open Database Connectivity) drivers can be installed from your MS Office CD with Access.