I am having problems using MyOLDDB with MS .NET when in Microsoft Visual C# .NET, while I'm trying to add an OleDbDataAddapter.
Under the Provider tab I select "MySQL.OLEDB Provider".
On the Connection -> MySQL Data Source Name Setup popup I enter the appropriate information.
I test the connection with no problems.
From there I select a Query Type of Use SQL Statements.
Then I select the Query Builder button.
I proceed to add the Employee table and select All Columns.
The SQL DML shows:
SELECT INFORMATION_SCHEMA.Employee.*
FROM INFORMATION_SCHEMA.Employee
After clicking on OK and Next, I receive the following Data Adapter Configuration Wizard error:
The wizard detected the following problems when configuring the data adapter "oleDbDataAdapter1".
Details:
Generated SELECT statement.
No error information available: E_FAIL(0x80004005)
NEED HELP!
Does anyone have any solutions to this problem?
Thanks, Matt