Click here to Skip to main content
15,892,005 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hello,

I developed an application that uses an MS Access database. I use a strong typed dataset to access the database.
A user of the application does not have MS Office on his machine and the application did not work for him. I therefor decided to change the database to MySQL.

Well it seems to be a hell of a job. I have tried to change to generated connectionstring but the dataset still refers to OLEDB instead of MySQL. I have changed the dataset.designer file to use MySQL but the OLEDB is still required.
Can anyone explain to me how to make this change? Is it at all possible or must I start over from scratch?

Thanks for your answers.

Ilan
Posted
Comments
Sergey Alexandrovich Kryukov 22-Oct-12 1:24am    
Apparently, not enough information. You did not show any code samples.
--SA
Ilan (apeldoorn) Cohen 22-Oct-12 5:01am    
Thanks for your response.

Well there is not much coding to show but let me describe my actions step by step:
1. I create a database in MS Access (Customers) with one table (Cust) and three columns (CustID, CustName and CustAddress)
2. In a new VB.NET Windows application I insert a binding source control to the form and create a new connection as data source to the Access Customer database
3. The automatic created dataset shows the correct table from the Access database
4. I create a database in MySQL with the same specs as above
5. In my Windows application I change the connection string to a valid MySQL connection string: server=localhost;User Id=Admin;database=customers
6. I enter the dataset design view (dataset.xsd) and try to reconfigure the automatic created table adapter
7. The following message is shown: Failed to open a connection to the database; An OLE DB provider was not specified in the connectionstring. An example would be 'Provider=SQLOLEDB'; Check the connection and try again.

I am using the MySQL .NET connector and I have tried to add the Provider parameter to my connection string (Provider=MySQL Provider) with negative result.
I also attempted to change all system.data.oledb library reference to MySQLClient library reference with the same results.

I hope this give a clear description of the problem.

Thanks.

Ilan

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900