Ovation historian ole db provider4/29/2023 ![]() As with the ADO connection properties, these provider-specific properties can be set via the Properties collection of a Connection or can be set as part of the ConnectionString. 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: 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: 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. ![]() The Microsoft OLE DB Provider for SQL Server, SQLOLEDB, allows ADO to access Microsoft SQL Server. ![]() ![]() Taraz Taraz Not the answer you're looking for? Browse other questions tagged sql-serverwonderware or ask your own question. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |