Hi All,
Let me begin by explaining you what i am doing.
In my appication i created a dataset and populating it using access database as datasource, and evrthyng is working fine. when i change the datasource i change the connection string in settings.vb and evything works fine as long as the new datasource is a access database.
what i need is to be able to change the data source type to an odbc connection.
and whenevr i do that it throws an error in the dataset .designer.vb saying that i need to specify provider, which in my case i dont need to since i am changing the connection to mysql server. Can i do that? and if yes how .
Thank in advance for your help
Let me begin by explaining you what i am doing.
In my appication i created a dataset and populating it using access database as datasource, and evrthyng is working fine. when i change the datasource i change the connection string in settings.vb and evything works fine as long as the new datasource is a access database.
what i need is to be able to change the data source type to an odbc connection.
and whenevr i do that it throws an error in the dataset .designer.vb saying that i need to specify provider, which in my case i dont need to since i am changing the connection to mysql server. Can i do that? and if yes how .
Thank in advance for your help