Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
You can supply much of the information specified by a connection string by setting properties of the Connection object before opening the connection. For example, you could achieve the same effect as the connection string discussed in Creating a Connection String by using the following code.
With objConn
.Provider = "SQLOLEDB"
.Properties("Data Source") = "MySqlServer"
.Properties("Integrated Security") = "SSPI"
.Open
.DefaultDatabase = "Northwind"
End With
DefaultDatabase is set only after you open the connection.
Note
In ADO you must not use a password containing semicolons (";") unless the password is enclosed in single quotation marks.