How to Use OLE DB Provider for SQL Server with Commerce Server

• Microsoft Site Server version 3.0, Commerce Edition

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=sa;PWD=;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

Additional query words:

Keywords          : 
Version           : winnt:3.0
Platform          : winnt 
Issue type        : kbhowto 

Last Reviewed: August 8, 1999