Рефераты | Рефераты по информатике, программированию | Введение в ADO |
DRIVER={SQL Server};SERVER=path to server |
|
|
Oracle |
DRIVER={Microsoft ODBC for Oracle};SERVER=path to server |
|
|
Microsoft Excel |
Driver={Microsoft Excel Driver (*.xls)};DBQ=physical path to .xls file; DriverID=278 |
|
|
Microsoft Excel 97 |
Driver={Microsoft Excel Driver (*.xls)};DBQ=physical path to .xls file;DriverID=790 |
|
|
Paradox |
Driver={Microsoft Paradox Driver (*.db)};DBQ=physical path to .db file;DriverID=26 |
|
|
Text |
Driver={Microsoft Text Driver (*.txt;*.csv)};DefaultDir=physical path to .txt file |
|
|
Microsoft Visual FoxPro® (with a database container) |
Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDb=physical path to .dbc file |
|
|
Microsoft Visual FoxPro (without a database container) |
Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDb=physical path to .dbf file |
Следующий пример показывает установку соединения с базой данных pubs, входящей в стандартный пакет поставки MS SQL Server 7.0 с помощью OLE DB поставщика:
_ConnectionPtr pConn = NULL;
_bstr_t strConn = "Provider=sqloledb;Data Source=(local);Initial Catalog=pubs";
try
{
pConn.CreateInstance(__uuidof(Connection));
pConn->Open(strConn,"sa","",adConnectUnspecified);
}
catch(_com_error e)
