OLE DB Connection Strings for the Data Warehouse

  • Article

Two types of connection strings are recognized by the OLE DB Provider for Commerce Server for use with the Data Warehouse. These strings are:

  • "URL=mscop://InProcConnect/Server=myserver:Database=dbname: Catalog=DWSchema:Trusted_Connection=Yes:FastLoad=True:Connection_Retry=10:Connection_Retry_Delay=30"
  • "Provider=commerce.dso.1;Data Source=mscop://InProcConnect/Server=myserver: Catalog=DWSchema:Database=dbname:Trusted_Connection=Yes:FastLoad=True:Connection_Retry=10:Connection_Retry_Delay=30"

For Windows NT Authentication use one of the following connection strings:

  • "URL=mscop://InProcConnect/Server=myserver:Database=dbname:Catalog=DWSchema:Trusted_Connection=true:FastLoad=True:Connection_Retry=10:Connection_Retry_Delay=30"
  • "URL=mscop://InProcConnect/Server=myserver:Database=dbname:Catalog=DWSchema:Trusted_Connection=Yes:FastLoad=True:Connection_Retry=10:Connection_Retry_Delay=30"

The name of the catalog must be "DWSchema".

The Fastload property must be set to True, which precludes the use of binary data. When the Fastload property is set to True you will not be able to read instance data in the classes, for example, select and update statements are not allowed.

The Connection_Retry option specifies the number of times the connection to the SQL provider will be retried when it encounters a problem. The Connection_Retry_Delay option specifies the seconds between each retry.

Copyright © 2005 Microsoft Corporation.
All rights reserved.