ODBC DB Connection - No Database Selected

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

Hi,

I'm going mad here trying to fix this one!! It seems that no-one knows the answer to this!

My dev system is able to talk to the remote DB server (MySQL 5.0). It works fine, no issues.

When I put my ASP.NET pages onto the server (IIS 5.0, Win2K Server, .NET 2.0), it suddenly decides to tell  me "No Database Selected"!

Here is the code concerned:

Imports System
Imports System.Data
Imports System.Data.Odbc
'...

        Dim dbCS As String = "DRIVER={MySQL ODBC 5.1 Driver}; SERVER=<SERVERIP>; DATABASE=<DATABASE>; UID=<USERNAME>; PASSWORD=<PASSWORD>; PORT=3306" 
        ' I tried DSNs too, but they throw the same error.
        'Dim dbCS As String = "DSN=<DATABASE>;PORT=3306" 'OPTION=3"
        Dim dbConn As New OdbcConnection(dbCS)
        dbConn.Open()

        Dim DBPass, DBAdmin As String

        Dim dbQuery As String = "SELECT password, admin FROM users WHERE username='" & LCase(txtUser.Text) & "'"
        Dim dbExec As New OdbcCommand(dbQuery, dbConn)
        dbExec.Connection = dbConn ' This line apparently doesn't do anything
****        Dim dbReader As OdbcDataReader = dbExec.ExecuteReader ' This line errors
        dbReader.Read()
        Try
            DBPass = dbReader.GetString(0)
            DBAdmin = dbReader.GetString(1)
        Catch
            'MsgBox("User doesn't exist!", MsgBoxStyle.Exclamation, "")
            lblErr.Text = "Invalid User"
            lblErr.Visible = True
            Exit Sub
        Finally
            dbReader.Close()
            dbConn.Close()
        End Try

Anyone here know how to fix this??? As I say, it works fine on my dev computer, but screws up when the ASP pages are put on the server. I doubt it is a bug in the ODBC drivers for MySQL as I'm using the same versions on my dev computer as the server.

Best regards,
Vulcan.