Hey Stephen,
I've tried a number of different connection strings, all with the same
result. I also tried connecting via a DSN, which did not work (doesn't seem
to make sense when I could connect to it via a DSN in IIS). As I mentioned,
I'm inclined to think it's a permission issue or something to do with IIS,
although I have no idea what. Here is the connection string I current have:
dim adoConn
dim adoRS
set adoConn = Server.CreateObject("ADODB.Connection")
set adoRS = Server.CreateObject("ADODB.Recordset")
adoConn.Open "driver={MySQL ODBC 3.51 Driver};
database=cpl;server=161.148.0.0;uid=xx;pwd=xx;option=16386;"
adoRS.ActiveConnection = adoConn
It works with 2 test machines running XP. It does not work on my Win2K
machine however.
Thanks,
Ed
-----Original Message-----
From: Slack, Stephen [mailto:SSlack@stripped]
Sent: Thursday, June 12, 2003 7:47 AM
To: Gonzalez, Juan; myodbc@stripped
Subject: RE: ambiguous results on connect
Hi Juan,
If it's something like this:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
Check out your connection string DSN name.
Stephen Slack
Senior Systems Developer
Allvac Ltd
_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus
