ODBC MySQL - Problems.

[Matthew Workman]

Hi...

I am trying to do a "basic" ODBC connection to my MYSQL Database being
hosted at discountasp. For the life of me, I can't get anything to return...
could someone lend a hand? Here is my code:

--------------------------------

string MyConString = "DRIVER={My SQL ODBC 3.51 Driver};" +
"SERVER=hostnam eatdiscountasp; " +
"DATABASE=myass igneddatabase;" +
"UID=;" +
"PASSWORD=; " +
"OPTION=3";

OdbcConnection MyConnection = new OdbcConnection( MyConString);
MyConnection.Op en();

OdbcCommand MyCommand = new OdbcCommand();
MyCommand.Comma ndText = "SELECT * FROM sometesttable";

OdbcDataReader MyDataReader;

MyDataReader = MyCommand.Execu teReader();

while (MyDataReader.R ead())
{
Label1.Text = MyDataReader.Ge tString(1);
}

MyDataReader.Cl ose();
MyConnection.Cl ose();

----------------------------

Any ideas on what might be the problem?

Thanks a bunch.

Matthew Workman
TLWI

[Nicholas Paldino [.NET/C# MVP]]

Matthew,

Are you getting no records returned, or are you getting an exception?
Can you be more specific about what the problem is?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Matthew Workman" <di*******@hotm ail.com_REMOVEM E> wrote in message
news:u$******** *****@tk2msftng p13.phx.gbl...

Hi...

I am trying to do a "basic" ODBC connection to my MYSQL Database being
hosted at discountasp. For the life of me, I can't get anything to return... could someone lend a hand? Here is my code:

--------------------------------

string MyConString = "DRIVER={My SQL ODBC 3.51 Driver};" +
"SERVER=hostnam eatdiscountasp; " +
"DATABASE=myass igneddatabase;" +
"UID=;" +
"PASSWORD=; " +
"OPTION=3";

OdbcConnection MyConnection = new OdbcConnection( MyConString);
MyConnection.Op en();

OdbcCommand MyCommand = new OdbcCommand();
MyCommand.Comma ndText = "SELECT * FROM sometesttable";

OdbcDataReader MyDataReader;

MyDataReader = MyCommand.Execu teReader();

while (MyDataReader.R ead())
{
Label1.Text = MyDataReader.Ge tString(1);
}

MyDataReader.Cl ose();
MyConnection.Cl ose();

----------------------------

Any ideas on what might be the problem?

Thanks a bunch.

Matthew Workman
TLWI