multiple Data Sources

[DougGerlach]

I am working on converting an app that can have a connection to a database on either access, oracle or sql server. the format of the database is the same in all three platforms. is it possible to add a dataset to the project to include the tables, and then depending on which platform i want to connect to i just change the connection string. i create the dataset as an ole type so i should be able to switch, but when i go from sql to oracle i get a table or view does not exist error. should i be able to switch like this or? is there a better way to handle changing database platforms?

thanks
doug

 

[cjard]

Normally we settle on one platform and stick to it.. kinda like the country settles on a drive-on-the-left or a drive-on-the-right policy and sticks to it..

Too many differences exist on DBs for effectively be able to maintain a well performing app for multiple systems