database connectivity in vb.net


  • Hi all,

        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.



    Saturday, November 04, 2006 10:00 AM

All replies

  • 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