ADO is for Perl you wouldn't be able to use in VB environment, I got that
idea from the way you asked you question. If you want to use Visual Basic
ADO you need to enable in VB environment. But anyways this is not the right
forum to talk about this.
If you are using Perl, then you need to first install MyODBC, not sure where
you get it, but search on the web and you will find. This driver is the
ODBC driver for MySQL. The you can set up DSN and then...
If you are using ActiveState Perl, then ADO is already installed. I would
recommend using DBD::ODBC instead, since it gives you generic calls/methods
unlike ADO where Microsoft tries to encapsulate the calls in their own way.
But that is my personal preference.
Use ppm to install modules.
In command prompt say...
>ppm install DBI
then
>ppm install DBD-ODBC
See ppm docs for more info. The above assumes you have internet connection
with no firewall.
You can configure you proxy environment in autoexec.bat, see ppm docs.
Ilya Sterin
-----Original Message-----
From: Harrison, JP [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 15, 2001 12:20 PM
To: '[EMAIL PROTECTED]'
Subject: Installing the ADO::DBD Perl module
I'm a beginning user of MySQL, and I have it running on
both a RedHat Linux box, and a Windows NT box. I'd like to
use the ADO spec (using Visual Basic) to access the MySQL
database. This is of course on the NT box. I can access the
database just fine, and the admin tools work perfectly.
I have Perl 5.6 on NT, and I have downloaded the DBI
Perl module, but I can't seem to see how to use that
code to make a driver that can be seen from my Visual
Basic environment.
Sorry to be so dumb about all of this - but there doesn't
seem to be any instructions on how to install the MySQL
driver. Could someone direct me to a "how-to" document
on a step-by-step installation, both for the ADO and the
ODBC.
Thanx for your help......JP Harrison
