OLE DB Connection Strings for the Profiles System
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