Microsoft KB Archive/214436

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

Article ID: 214436

Article Last Modified on 6/24/2004

-

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

Keywords: kbhowto KB214436

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.