I want connection sqlserver + code "provider and data source"


  • Hi, I am new in and i am working in a project where i want to change access data base to sqlserver data base .

    What i want is to change 

     Dim constring As String = "provider=microsoft.ace.oledb.12.0;data source=D:\tracking and archive system DB.accdb"
     Dim con As New OleDb.OleDbConnection(constring).

    My project is connected with  access database. How can i change  the provider and source from access to sqlserver.

    with the knowledge that Data baseName=uk ,UserName=khalid ,Password=123

    I will appreciate your help ! 

    Thank you very much !


    • Edited by k.alnamshan Wednesday, July 03, 2013 9:44 AM
    Wednesday, July 03, 2013 9:38 AM


All replies