Provider Connection String for ADO

ADO connection strings for providers are documented in the ADO Programmer's Reference in the MDAC SDK. The following table shows examples of connection strings that can be used in running the ADO conformance tests.

Provider Connection string example

ODBC

data source=ADOT7;
user id=adolab;
password=sometext;
FILE=C:\testdrop\ wayl7.ini;
DefaultQuery=select * from wayl7;
CURSORLOC=client;CONNECTIONTIMEOUT=500;

Oracle

data source=goliath.world;
user id=ADOLAB1;
password=sometext;
FILE=C:\testdrop\ wayl7can.ini;
DefaultQuery=select * from wayl7;
CURSORLOC=server;