How to Use OLE DB Provider for SQL Server with Commerce Server (214436)

The information in this article applies to:

Microsoft Site Server 3.0 Commerce Edition

This article was previously published under Q214436

SUMMARY

With the release of Visual Studio 6.0 and MDAC 2.0, it is possible to use the OLE DB Provider for SQL Server (Sqloledb.dll) with Commerce Server 3.0. A DSN is no longer necessary if you choose to use this provider with ADO. Instead, you can specify the provider in the connection string.

For example:

Provider=SQLOLEDB;UID=<username>;PWD=<strong password>;Database=pubs;

MORE INFORMATION

For stores created with Microsoft Site Server, Commerce Edition 3.0, the connection string is stored in the Site.csc file located in the store's \config directory. This file can be modified through the Editdictionary.asp, available for download at:

http://www.microsoft.com/siteserver/commerce/DeployAdmin/EditDictionary.htm

Modification Type:	Major	Last Reviewed:	6/24/2004
Keywords:	kbhowto KB214436