Connect to MySQL with ASP.

I'm trying to connect to a newly installed MySQL database on our server for our local intranet site.

Nothing seems to be working. I keep getting this error.

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Here's the code for the connection string I had.

DBconn.connectionstring = "Provider=MSDASQL; DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost; DATABASE=intranet; UID = mrobison;PASSWORD=password; OPTION=3"

DBconn.Open

Thanks for your help!

 

try using the MyOLEDB driver instead
http://dev.mysql.com/downloads/download.php?file=Downloads/Win32/MyOLEDB3.exe&pick=mirror

 

That link keeps timing out on me. What I don't understand is why this connection string will now work, and how do I do it an alternate way.

Thanks.

 

Okay, I got past the initial connectionstring error, but now I am getting this:

I'm getting this error, which has nothing to do with the code I wrote.

Any ideas?

BC30289: Statement cannot appear within a method body. End of method assumed.


Line 59: #End ExternalSource
Line 60:
Line 61: Public Sub New()
Line 62: MyBase.New
Line 63: Dim dependencies As System.Collections.ArrayList
Source File: C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Tempo rary ASP.NET Files\root\f1ffecea\9f83385e\aal2b1o-.0.vb Line: 61
Edit/Delete Message