Connection Strings for the Data Warehouse

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

  • "URL=mscop://InProcConnect/Server=myserver:Database=dbname:
    Catalog=DWSchema:User=userid:Password=********:FastLoad=True"

  • "Provider=commerce.dso.1;Data Source=mscop://InProcConnect/Server=myserver:
    Catalog=DWSchema:Database=dbname:User=userid:
    Password=********:FastLoad=True"

The name of the catalog must be "DWSchema".

The Fastload option must be set to True which precludes the use of binary data.


All rights reserved.