I'm writing an application in which I'm connection to the access database.My intention is in future i will move to someother database like sqlserver or oracle. once if I make a setup and deployed in a system if i want to change to other database. how can i chnage the connection string.I'm using ado.net oledbdataprovider.
is there anyway i can write the connection string independent of the application
hope I delivered the question correctly.any little help is appreciated.
i think you have to recode the whole program because OleDB is really Different from SQL like for instance OleDB uses System.Data.OleDB.OleDBConnection() while SQl uses System.Data.SqlClient.SqlConnection()
Wednesday, November 22, 2006 8:57 AM
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.