Differences between version dated 2003-08-28 11:08:19 and 2003-08-28 11:10:51
Deletions are marked like this.
Additions are marked like this.
==== ODBC Driver for Access ====
For Standard Security:
oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
ODBC Driver for AS/400 (from IBM)
==== ODBC Driver for AS/400 (from IBM) ====
oConn.Open "Driver={Client Access ODBC Driver (32-bit)};" & _
"System=myAS400;" & _
"Uid=myUsername;" & _
==== ODBC Driver for dBASE ====
oConn.Open "Driver={Microsoft dBASE Driver (*.dbf)};" & _
"DriverID=277;" & _
"Dbq=c:\somepath"
==== ODBC Driver for Excel ====
oConn.Open "Driver={Microsoft Excel Driver (*.xls)};" & _
"DriverId=790;" & _
"Dbq=c:\somepath\mySpreadsheet.xls;" & _
==== ODBC Driver for Informix ====
If using INFORMIX 3.30 ODBC Driver
"Driver={INFORMIX 3.30 32 BIT};" & _
"Host=myHostname;" & _
"Server=myServerName;" & _
ODBC Driver for Interbase (from Easysoft)
==== ODBC Driver for Interbase (from Easysoft) ====
For the local machine
oConn.Open "Driver={Easysoft IB6 ODBC};" & _
ODBC Driver for Interbase (from InterSolv)
==== ODBC Driver for Interbase (from InterSolv) ====
For the local machine
oConn.Open "Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};" & _
ODBC Driver for Lotus Notes
==== ODBC Driver for Lotus Notes ====
oConn.Open "Driver={Lotus NotesSQL 3.01 (32-bit) ODBC DRIVER (*.nsf)};" & _
"Server=myServerName;" & _
"Database=mydir\myDbName.nsf;" & _
ODBC Driver for MySQL (via MyODBC)
==== ODBC Driver for MySQL (via MyODBC) ====
To connect to a local database
oConn.Open "Driver={mySQL};" & _
ODBC Driver for Oracle (from Microsoft)
==== ODBC Driver for Oracle (from Microsoft) ====
For the current Oracle ODBC Driver from Microsoft
oConn.Open "Driver={Microsoft ODBC for Oracle};" & _
ODBC Driver for Oracle (from Oracle)
==== ODBC Driver for Oracle (from Oracle) ====
oConn.Open "Driver={Oracle ODBC Driver};" & _
"Dbq=myDBName;" & _
"Uid=myUsername;" & _
==== ODBC Driver for Paradox ====
oConn.Open "Driver={Microsoft Paradox Driver (*.db )};" & _
"DriverID=538;" & _
"Fil=Paradox 5.X;" & _
ODBC Driver for SQL Server
==== ODBC Driver for SQL Server ====
For Standard Security
oConn.Open "Driver={SQL Server};" & _
==== ODBC Driver for Sybase ====
If using the Sybase System 12 (or 12.5) Enterprise Open Client ODBC Driver
oConn.Open "Driver={SYBASE ASE ODBC Driver};" & _
ODBC Driver for Sybase SQL Anywhere
==== ODBC Driver for Sybase SQL Anywhere ====
oConn.Open "ODBC; Driver=Sybase SQL Anywhere 5.0;" & _
"DefaultDir=c:\dbpath\;" & _
"Dbf=c:\sqlany50\mydb.db;" & _
==== ODBC Driver for Teradata ====
oConn.Open "Provider=Teradata;" & _
"DBCName=MyDbcName;" & _
"Database=MyDatabaseName;" & _
==== ODBC Driver for Text ====
oConn.Open _
"Driver={Microsoft Text Driver (*.txt; *.csv)};" & _
"Dbq=c:\somepath\;" & _
ODBC Driver for Visual FoxPro
==== ODBC Driver for Visual FoxPro ====
With a database container
oConn.Open "Driver={Microsoft Visual FoxPro Driver};" & _
ShowText
of this page
EditText
of this page
FindPage
by browsing, searching, or an index
Or try one of these actions:
DeletePage,
DeleteUploadedFile,
LikePages,
SpellCheck,
UploadFile
