Follow

How to change a ODBC type data source to a Any Source ADO

Sometimes you want to change a data source from one type to another, while it is being used. Below is the most common ways to achieve this.

Change a MySQL ODBC connector to a Any Source ADO connection

If you use a MySQL through ODBC, a guide in how to set it up is here. Also before you do the change you need to install the MySQL .Net provider. You can see how here.

Before you do this you have to remember that since there is big changes in the setup between the two types, your selected fields will be removed when you resynchronize.

To change its data type to a Any Source ADO.Net, start by right clicking on the ODBC MySQL data source, finding change provider and clicking on Change to Any Source ADO.Net.

01.PNG

Set up the data source like it is explained in the guide. It should look like in the pictures below.

2.PNG

Its a `by the way.

3.PNG

When this is done resynchronize with the data source. This will remove all selected fields from the data source.

 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.