The provider supports several provider-specific connection parameters in addition to those defined by ADO. If you are connecting to a data source provider that supports Windows authentication, you should specify Trusted_Connection=yes or Integrated Security = SSPI instead of user ID and password information in the connection string. Specifies the user password (for SQL Server Authentication). Specifies the user name (for SQL Server Authentication). Specifies the name of a database on the server. Specifies the OLE DB Provider for SQL Server. The string consists of these keywords: Keyword Typical Connection StringĪ typical connection string for this provider is: "Provider=SQLOLEDB Data Source=serverName " This value can also be set or read using the Provider property. To connect to this provider, set the Provider argument to the ConnectionString property to: SQLOLEDB Instead, use the new Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL) which will be updated with the most recent server features. The Microsoft OLE DB Provider for SQL Server (SQLOLEDB) remains deprecated and it is not recommended to use it for new development work.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |