Home  »  Articles  »  ADO.Net  »

All Connection String Sample

 Posted By : Manoranjan SahooPosted Date : 24/07/2011 07:51:02 AM Category : ADO.Net Points : 5

Case 1: You have the .NET Framework on your local computer and you want to connect to a Microsoft Access database called database1.mdb located in the following folder on your hard disk: c:\database1.mdb. Here are the parameters to create this connection string:

Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\database1.mdb;

OLE DB Provider for DB2 (from Microsoft)

For TCP/IP connections

oConn.Open = "Provider=DB2OLEDB;" & _ 

                               "Network Transport Library=TCPIP;" &  _  

                               "Network Address=xxx.xxx.xxx.xxx;" & _    

                              "Initial Catalog=MyCatalog;" & _      

                              "Package Collection=MyPackageCollection;" & _  

                              "Default Schema=MySchema;" & _      

                              "User ID=MyUsername;" & _       

                             "Password=MyPassword"

For APPC connections

oConn.Open = "Provider=DB2OLEDB;" &  _   

         "APPC Local LU Alias=MyLocalLUAlias;" &  _ 

           "APPC Remote LU Alias=MyRemoteLUAlias;" &  _ 

           "Initial Catalog=MyCatalog;" & _ 

           "Package Collection=MyPackageCollection;" & _ 

           "Default Schema=MySchema;" & _   

         "User ID=MyUsername;" & _   

         "Password=MyPassword"

ODBC Driver for Excel

oConn.Open "Driver={Microsoft Excel Driver (*.xls)};" & _ 

         "DriverId=790;" & _   

       "Dbq=c:\somepath\mySpreadsheet.xls;" & _

           "DefaultDir=c:\somepath" 

ODBC Driver for MySQL (via MyODBC)

To connect to a local database (using MyODBC Driver)

oConn.Open "Driver={mySQL};" & _ 

         "Server=MyServerName;" & _ 

         "Option=16834;" & _ 

         "Database=mydb"

To connect to a remote database

oConn.Open "Driver={mySQL};" & _ 

         "Server=db1.database.com;" & _   

       "Port=3306;" & _   

       "Option=131072;" & _ 

         "Stmt=;" & _   

       "Database=mydb;" & _ 

         "Uid=myUsername;" & _ 

         "Pwd=myPassword"

To connect to a local database (using MySQL ODBC 3.51 Driver)

oConn.Open "DRIVER={MySQL ODBC 3.51 Driver};" & _   

             "Server=myServerName;" & _ 

               "Port=3306;" & _ 

               "Option=16384;" & _ 

               "Stmt=;" & _ 

               "Database=mydatabaseName;" & _ 

               "Uid=myUsername;" & _   

             "Pwd=myPassword"

Or

oConn.Open "DRIVER={MySQL ODBC 3.51 Driver};" & _ 

               "SERVER=myServerName;" & _ 

               "DATABASE=myDatabaseName;" & _     

              "USER=myUsername;" & _ 

               "PASSWORD=myPassword;"

Responses
No responses found for this thread. Be the first to respond this thread.
Post Reply
Login to post Response.