Problem With ASP-MYSQL: msg#00128 db.mysql.windows

Hello,
i tried the following examples, but I encountered the following error message:s
Unknown database 'mydsn' in the file mysqlconn.asp,
and Data source name not found and no default driver specified in the file mysqlodbc.asp.
This is the code of mysqlconn.asp.
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<html>
<head>
<title>Connessione a mysql</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<%
Dim cnTemp, rsTemp

Set oConn = Server.CreateObject("ADODB.Connection")
Set rsTemp = Server.CreateObject("ADODB.Recordset")

oConn.Open "DSN=MYDSN;User ID=root; Password='';DESC=MySQL DSN;DATABASE=MYDSN;SERVER=localhost;UID=userid;PORT=3306;OPTION=3;STMT=;"

Response.Write("Connessione riuscita")
%>
</body>
</html>

This is the code of the file mysqlodbc.asp
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<html>
<head>
<title>Connessione a MySql mediante ODBC</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<%
Dim oConn, rsConn

Set oConn = Server.CreateObject("ADODB.Connection")
Set rsConn = Server.CreateObject("ADODB.Recordset")

oConn.Open "Driver={mySQL};" & _
"Server=localhost;" & _
"Option=16384;" & _
"Database=try;"
%>
</body>
</html>

I configured the connections in ODBC datasources, connecting try and MYSDN to the database test, that exits. I supplied the description MYSQL for each datasources, but I don't understand the problem. I ask how to connect ODBC with Mysql.

---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before
posting. To request this thread, e-mail win32-thread10597@xxxxxxxxxxxxxxx

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail win32-unsubscribe@xxxxxxxxxxxxxxx instead.

Previous by Date:	RE: RE: where should I look?: 00128, Kevin Rutledge
Next by Date:	RE: Problem With ASP-MYSQL: 00128, Public Folder: MySQL
Previous by Thread:	RE: problem with ASP-Mysqli: 00128, Public Folder: MySQL
Next by Thread:	RE: Problem With ASP-MYSQL: 00128, Public Folder: MySQL
Indexes:	[Date] [Thread] [Top] [All Lists]