ASP.NET(vb) + MySQL using ODBC .NET Provider & MyODBC 3.51

[kisk]

I have a weird situation here. I'm programming a web application and it needs to be able to access a MySQL db.

Let me go head and say that for all tests I've done, I am using my webhost's mysql database.

The app connects to my host's mysql db just fine when the app runs on my computer, but when I upload it to my host's computers and try to run it on their servers, it won't connect (or stay connected) to the database.

Here's an example of the code I'm using:



#### Code Start ####

Imports Microsoft.Data.Odbc 'ODBC .NET Provider

Public Class clsMySQLAccess

Public Function dbConnect() As String

Const MyConString As String = "DRIVER={MySQL ODBC 3.51 Driver};" & _
"SERVER=mysql.4ph.com;" & _
"DATABASE={EDITED_OUT};" & _
"UID={EDITED_OUT};" & _
"PASSWORD={EDITED_OUT};" & _
"OPTION=3;"

Dim MyConnection As New OdbcConnection(MyConString)


Try
MyConnection.Open()
Return MyConnection.State.ToString
Catch ex As OdbcException
Return "OdbcException --> " & ex.ToString
Catch ex2 As Exception
Return "Exception --> " & ex2.ToString
End Try

End Function

End Class

#### End Code ####



Now like I said, when I run this code from my computer, it executes beautifully and the function returns "Open" from the connection state. I can then carry out any other queries I like just fine.

If I take the exact same code, upload it and run it off my host's computers, I don't get any exceptions, but the function always returns "Closed" as the connection state. Obviously, because of this state I can't do anything else really. I find it very strange that the code can connect when its on my computer, but the exact same code won't connect(or at least stay connected) on the host's computer.

Anyone have any ideas why I'm experiencing this? I'm thinking that maybe my app isn't finding the ODBC .NET Provider or the MyODBC driver... but I'd get an exception error initially if it couldn't find those right?

I've tried everything I can to get this to work and I'm pretty much at a dead end now. I've talked with my host and they can't seem to figure out what's up either. They even set up a DSN for me and we tried it that way but came up with the same results.

Any ideas??

Thanks,
kisk

 

[dbernal99]

Try to use this connector

http://www.bytefx.com.

I used and works OK.

 

[DaZZleD]

mysql authentcation also takes into consideration the hostname from where you are connected. check to see that the user and password used are configured for access from the server where you want to deploy your app

--------------------------
"two wrongs don't make a right, but three lefts do" - the unknown sage

 

[kisk]

I tried multiple connectors and nothing worked. This thread is actually over a year old -- I decided to drop ASP and just use PHP instead.

Thanks anyway