Connection problem between MySQL and ASP.NET

[Polarsilver]

Hello,

I have problem with the connection between MySQL 5.0 and my ASP.NET (VB)
homepage. Framework 1.1 and Visual Studio .NET 2003. I have installed MyODBC
3.51 driver. I'm using Windows XP SP2 and ZoneAlarm Security Suite 5.1.

I have made a class to connect to the database and return the datareader.

---
Imports System.Data.Odbc

Public Class Database

Private strConn As String = "DRIVER={MySQL ODBC 3.51
Driver};SERVER=localhost;DATABASE=dbname;USER=myuser;PASSWORD=mypassword;OPTION=3"
Private objConn As New OdbcConnection(strConn)

Function GetData(ByVal strSQL As String)
Dim objCommand As New OdbcCommand(strSQL, objConn)
objConn.Open()
Dim objReader As OdbcDataReader = objCommand.ExecuteReader()
Return objReader

objReader.Close()
objConn.Close()
End Function

End Class
---

Sometimes the system is hanging when I try to load the webpage in IE and I
need to restart the computer. It occur often after I have build the
soloution in VS.NET and try it in IE. After the restart it often works again
but it's very irritating and I want to solve the problem and I i'm greatful
for any help.


Thanks in advance,

Polarsilver

 

[Mark Rae]

I have installed MyODBC 3.51 driver.

As a matter of interest, why aren't you using one of the MySQL .NET native
data providers...?

http://crlab.com/mysqlnet/
http://www.salleurl.edu/~manuellv/Public/english.8.1.html
http://sourceforge.net/projects/mysqlnet/

http://dev.mysql.com/tech-resources/articles/dotnet/