Hi,



I need help connecting to mysql. I'm now using .NET (in the past I had no 

problems with plain ole ASP). But here is my problem-



Scenario:

I'm using mysql as my database (I was given no choice).

I want to connect using a DSN but I have encountered various difficulties.



Assume that a system DSN has been defined called myAPP using myODBC driver 

v2.5 (or 3.51...it really doesn't matter as I have discovered)

Assume that the UID is xxxx and the password is yyyy

Assume I'm writing in VB for .aspx pages

Then this was my connection string:



Dim strConn as String 

strConn = "Provider=MySQLProv;DSN=myAPP;UID=xxxx;PASSWORD=yyyy" 

 Dim Conn as New OleDbConnection(strConn)

 Conn.Open



...the result is my page seems to load forever (no error message)

If I change the provider to something else (e.g. MSDASQL) I get

"The .Net Data OLE DB Provider(System.Data.OleDb) does not support the 

MSDASQL Provider, Microsoft OLE DB Provider for ODBC Drivers. "



I do not want to use MYSQLX (it didn't work anyway when I tried it). Any 

suggestions? I'm quite desparate at his point. In fact, any suggetsions 

for connecting to a mySQL (DSN or DSNless) would be greatly, greatly 

appreciated. Thanks.



- David