none
I want connection sqlserver + vb.net code "provider and data source"

    Question

  • Hi, I am new in vb.net 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

Answers

All replies