Connection strings for Sql Server, Access, Oracle, Sybase : Access « Database ADO.net « VB.Net Tutorial






Imports System.Data.Odbc    

Module Module1
  Sub Main()
      ' Create a SQL Server connection string.
      '"Driver={SQL Server};Server=(local);Database=AdventureWorks;Uid=ab;Pwd=pass@word1")

      ' Create an Access connection string.
      '("Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\info.mdb;Exclusive=1;Uid=admin;Pwd=pass@word1")

      ' Create an Oracle connection string.
      '("Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=Admin;Pwd=pass@word1;")

      ' Create a Sybase connection string.
      '("Driver={SYBASE ASE ODBC Driver};Srvr=SomeServer;Uid=admin;Pwd=pass@word1")


  End Sub
End Module








26.1.Access
26.1.1.Create OleDbConnection to Access database
26.1.2.Connection strings for Sql Server, Access, Oracle, Sybase