| title | Specifying Connection Properties | Microsoft Docs | ||
|---|---|---|---|
| ms.prod | sql | ||
| ms.prod_service | connectivity | ||
| ms.technology | connectivity | ||
| ms.custom | |||
| ms.date | 01/19/2017 | ||
| ms.reviewer | |||
| ms.topic | conceptual | ||
| helpviewer_keywords |
|
||
| ms.assetid | 49456201-b085-4851-9686-e814136b07be | ||
| author | MightyPen | ||
| ms.author | genemi |
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.