Database Exchange > ODBC Connection Strings for CityplaceADO

ODBC Connection Strings for CityplaceADO

dBase

Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq= c:\somepath

Access

Driver={Microsoft Access Driver (*.mdb)};Dbq=c:\ somepath \mydb.mdb;Uid=admin;Pwd=

Text

Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\somepath\;Extensions=asc,csv,tab,txt

Excel

Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=c:\somepath\myFile.xls;DefaultDir=c:\somepath

SQL Server

Driver={SQL Server};Server=MyServer;Database=myDatabase;Uid=myUserName;Pwd=myPassword