I use the 2.x ODBC driver, after the first problems I install over the 3.51
odbc, the problem was the same, now i have the 2.x again. I'm trying to
minimize the amount of software between the database and the application.
-----Mensaje original-----
De: Mike Hillyer [mailto:mhillyer@stripped]
Enviado el: Jueves, 12 de Junio de 2003 11:57 a.m.
Para: Ed Kraft; SSlack@stripped; myodbc@stripped
Asunto: RE: ambiguous results on connect
Does your Win2k box have the 3.51 ODBC driver installed?
Regards,
Mike Hillyer
www.vbmysql.com
-----Original Message-----
From: Ed Kraft [mailto:ekraft84@stripped]
Sent: Thursday, June 12, 2003 8:53 AM
To: SSlack@stripped; myodbc@stripped
Subject: RE: ambiguous results on connect
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
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:
http://lists.mysql.com/myodbc?unsub=1
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=1
