SUMMARY
You can use any ODBC version 2.5 compliant relational database management
system (RDBMS) with Microsoft Commerce Server version 2.0. However,
Commerce Server uses ActiveX Data Objects (ADO) for data retrieval and
storage from the RDBMS. You must make sure that the ODBC driver you intend
to use works with ADO. Microsoft has tested Commerce Server with the
Microsoft SQL Server ODBC driver and with the Oracle ODBC drivers from
Microsoft and Visigenic. For more information on ADO, visit the following
Web site:
Also, in the order processing pipeline (OPP), you can write your own
component(s) to get data from a legacy system.