![]() Provider=MSDASQL.1 Data Source= DBF_DATA Extended Properties="DSN= DBF_DATA DriverId=533 FIL=dBase 5. Provider=MSDASQL.1 Extended Properties="DSN= ORACLE_DB UID=ADM PWD=freedom "Ĥ. This will bring up a window like the following window: Step 3: Click on Addand this will bring up the following window. Step 2: Select Administrator Toolsand then select Data Sources (ODBC). The Microsoft OLE DB Simple Provider (OSP) allows ADO to access any data for which a provider has been written using the OLE DB Simple Provider (OSP) Toolkit. ![]() Provider=MSDASQL.1 Extended Properties="DSN= IBLOCAL_ADO_EMP UID=sysdba PWD=masterkey"ģ. Step 1: From the Start Menu, select Settingsand then the Control Panel. Provider=SQLBaseOLEDB Data source=myServerAddress Location=myDataBase User Id=myUsername Password=myPassword (SQLBase OLE DB Data Provider must be installed) ODBC DSNġ. ![]() Provider=MSDASQL.1 Extended Properties="DBQ= C:\MyExcelFile.xls DefaultDir=C:\ Driver= Server=IP address Port=5432 Database=myDataBase Uid=myUsername Pwd=myPassword (PostgreSQL ODBC Driver must be installed) SQLite databases ODBCĭriver=SQLite3 ODBC Driver Database= C:\MyData\My_db.db (SQLite3 ODBC Driver must be installed) SQLBase databases OLE DB ![]() Provider=.12.0 Data Source= c:\MyExcelFile.xls Extended Properties="Excel 8.0 HDR=YES" (Microsoft ACE must be installed) ODBC Provider=.4.0 excel 8.0 DATABASE= C:\MyExcelData.xls ACE There are also other ways of opening databases. Please note that using ADO and ADO connection strings is optional in Database Tour.
0 Comments
Leave a Reply. |