Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In with Facebook Sign In with Google Sign In with OpenID

Categories

We have migrated to a new platform! Please note that you will need to reset your password to log in (your credentials are still in-tact though). Please contact lee@programmersheaven.com if you have questions.
Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

MYSQL

gvector1gvector1 Posts: 13Member
Hello fellow programmers,

I have a problem that I have been working on for over a week. I am trying to connect to a MYSQL database using ADO.NET. In Visual Studio 6.0, using ADO, I could connect to a MYSQL database by using the "OLEDB for ODBC drivers" data link setting and the connection would work fine. With .NET it does not. When trying to connect using the "OLEDB for ODBC drivers" data link setting, I get the following error: "You cannot use OLEDB provider for ODBC drivers". I have even tried using MyOLEDB. Whenever I install it and set up the database, the connection seems to be made, but when I try to drag a control from the server explorer, I get the following (Data Adapter Configuration Error) :

"The wizard detected the following problems when configuring the data adapter for "patientfile""
Details:
!Generated Select Statement
Error in Select clause:expression near '['
Error in From clause: near '['
Unable to parse query text

If I go in through the DataAdapter wizard using MyOLEDB, I have to remove the [Information_Schema] before the table name in the select statement for it to even generate the select statement without errors. Why does it keep adding [Information_Schema] in front of the table name?

Going that route, my next step would be to generate a dataset. Whenever I try to do that I get this error:

"Retrieveing the schema from OLEDBDataAdapter1 Failed."
"No Error Information Available:E_FAIL(0x80004005)"

I have tried everything and cannot figure it out. I have even tried MyODBC and ODBC.NET.

Can anyone please offer some advice????????
Any advice will be greatly appreciated


Thanks a million,
Kendal

Sign In or Register to comment.