OLE DB Connection Strings for the Profiles System

  • Article

Commerce Server Core Systems requires that you include an OLE DB Provider in your connection strings, along with a data source, server name, database name, catalog, and a security context:

  • "Provider=Commerce.DSO;Data Source=mscop://InProcConnect/Server=myserver: Database=dbname: Catalog=Profile Definitions: Trusted_Connection=Yes"

  • "Provider=Commerce.DSO;Data Source=mscop://InProcConnect/Server=myserver: Database=dbname: Catalog=Profile Definitions: User=username: Password=password"

Remarks

If you intend to generate your connection string from the Resources property, you will need to modify it. It will contain a URL in the connection string, which will not work with the OLE DB connection string. You must replace "URL" with "Data Source" before it can be used in an OLE DB connection string:

ConnectionString = ConnectionString.Replace("url=", "Data Source=");

Example

The following example connects to a server named SRVPROD, with a database named StarterSite_Profiles, using Windows authentication.

oledbconn = new OleDbConnection("Provider=Commerce.DSO;Data Source=mscop://InProcConnect/Server=SRVPROD:Database=StarterSite_profiles:Catalog=Profile Definitions:Trusted_Connection=Yes");

Note

Pay close attention to both semicolons and colons in the connection string.

Note

The OLE DB connection string Fastload option is not supported by the Profiles System.

See Also

Other Resources

SQL Queries Supported by the OLE DB Provider for Commerce Server

Profiles System and OLE DB Provider