The Connection Is Dead - ODBC

[Guest]

Hello,

I am having a problem getting data from a MySQL database using an ODBC
connection. The below code
works 100% in a Windows Form but not in my ASP.Net Web Form. It returns the
error "The Connection
Is Dead" at the oDBA.Fill line.

I have MySQL's MyODBC drive version 3.51.09 on the server which is the latest.

Any suggestions or help? Am I missing a command (like you have to use
DataBind on a WebForm but not
on a Windows Form)?


string sSQL;

sSQL = "SELECT FilePath, FileName, FileExt, " +
"Document_Name, Revision, Sheet_Name " +
"FROM Document_Locations " +
"WHERE File_ID = " + sTIFID + ";";

string MyConString = "DRIVER={MySQL ODBC 3.51 Driver};" +
"SERVER=cochise;" +
"DATABASE=ISTAR;" +
"UID=root;" +
"PASSWORD=;" +
"OPTION=3";

OdbcConnection myConnection;
OdbcCommand myCommand;
OdbcDataAdapter oDBA;
DataSet dsRecords = new DataSet();

myConnection = new OdbcConnection(MyConString);
myCommand = new OdbcCommand(sSQL, myConnection);
oDBA = new OdbcDataAdapter(myCommand);
oDBA.Fill(dsRecords);
myConnection.Close();

Thanks,
Kevin

 

[Lucas Tam]

Any suggestions or help?

Do you have to use the ODBC connection?

I found MySQL's Managed ADO.NET driver to be much easier to use.

 

[Guest]

I suppose it is not a requirement. I usually like to keep inside the box and
not get 3rd party tools. I am willing though. But that really doesn't
answer the question. Why would it work in Windows Forms but not Web Forms?

 

[Chris Botha]

If you get this problem while testing on the same machine (Windows Form and
the Web Form) then it is a security issue. From the Windows form you connect
as the logged on user, from the Web form as the anonymous user.

 

[Lucas Tam]

I suppose it is not a requirement. I usually like to keep inside the
box and not get 3rd party tools.

The ByteFX .NET driver is now officially part of MySQL:

http://www.bytefx.com/DotData.aspx

Works well too... probably better than ODBC.