I am trying to to use a DSNless connection from an ASP script( on IIS5) to a
MySQL db on Linux.
I am trying this:
--------------------------------
strConnection=_
"driver={MySQL};server=192.168.33.124;uid=me;pwd=mypassword;database=MySQL;o
ption=NUM"
Set adoDataConn = Server.CreateObject("ADODB.Connection")
adoDataConn.Open strConnection
strQuery = "SELECT * FROM user;"
Set RS = adoDataConn.Execute(strQuery)
--------------------------------------------------
and am getting this back:
--------------------------------------------------
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
/mysql.asp, line 7
-----------------------------------------------------------
Can somebody tell me what I am missing, please! What do I need to install on
the server in order to make this work? The odbc connection works fine.
Thanks
Dietrich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
