List:MySQL ODBC« Previous MessageNext Message »
From:Juan Gonzalez Date:June 12 2003 2:56pm
Subject:RE: ambiguous results on connect
View as plain text  
As i mention in the previus mail I have the inverse problem: it works in W
2000 but not in W XP.
I suspect about security problems too, buy I review all, even install from
"secure mode".
Finally if it runs from many applications: where is the difference? not
seems in the security policies.

-----Mensaje original-----
De: Ed Kraft [mailto:ekraft84@stripped]
Enviado el: Jueves, 12 de Junio de 2003 11:53 a.m.
Para: SSlack@stripped; myodbc@stripped
Asunto: 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
Thread
ambiguous results on connectJuan Gonzalez12 Jun
RE: ambiguous results on connectStephen Slack12 Jun
RE: ambiguous results on connectEd Kraft12 Jun
RE: ambiguous results on connectEd Kraft12 Jun
RE: ambiguous results on connectMike Hillyer12 Jun
RE: ambiguous results on connectJuan Gonzalez12 Jun
RE: ambiguous results on connectEd Kraft12 Jun
RE: ambiguous results on connectJuan Gonzalez12 Jun
RE: ambiguous results on connectMike Hillyer12 Jun
RE: ambiguous results on connectEd Kraft12 Jun
RE: ambiguous results on connectJuan Gonzalez13 Jun
  • RE: ambiguous results on connectEd Kraft13 Jun
  • RE: ambiguous results on connectPeter Carter13 Jun
RE: ambiguous results on connectJuan Gonzalez13 Jun
RE: ambiguous results on connectJuan Gonzalez13 Jun
  • RE: ambiguous results on connectPeter Carter13 Jun
    • RE: ambiguous results on connectEd Kraft13 Jun
RE: ambiguous results on connectJuan Gonzalez13 Jun
RE: ambiguous results on connectJuan Gonzalez18 Jun