Hi everyone
I am trying to connect to a MySQL database from a ".aspx" page, but getting error "Data source name not found and no default driver specified ".
I am writing the code as follows...
Dim con As Odbc.OdbcConnection = New Odbc.OdbcConnection
con.ConnectionString = "STMT=;OPTION=;UID=test;PASSWORD=;DRIVER=MySQL ODBC 3.51 Driver;DESC=; DATABASE=Test_Database;SERVER=IP Address;PORT=3306"
con.Open()
But, If I am writing the same code in a VB.NET windows application, then the code is working fine.
Can anybody tell me, what is the problem in my ASP.NET application, that is giving the error above mentioned.
Thanks in advance
Kajol
I am trying to connect to a MySQL database from a ".aspx" page, but getting error "Data source name not found and no default driver specified ".
I am writing the code as follows...
Dim con As Odbc.OdbcConnection = New Odbc.OdbcConnection
con.ConnectionString = "STMT=;OPTION=;UID=test;PASSWORD=;DRIVER=MySQL ODBC 3.51 Driver;DESC=; DATABASE=Test_Database;SERVER=IP Address;PORT=3306"
con.Open()
But, If I am writing the same code in a VB.NET windows application, then the code is working fine.
Can anybody tell me, what is the problem in my ASP.NET application, that is giving the error above mentioned.
Thanks in advance
Kajol