Error using dsn-less connection string between ASP and MySQL
Posted on 2003-10-30
I am trying to connect to MySql with the following code:
<%@ LANGUAGE="VBSCRIPT" %>
Set conn = Server.CreateObject("ADODB.Connection")
I receive the following error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/asptest/intro.asp, line 14
I have created a sytem DSN and the script works when I use it i.e.
conn.OPen = "dsn=mysql_dsn"
but I would prefer the connection to be DSN-Less