Ole DB Providers

[noorsoft]

OLE DB Provider for Active Directory Service

oConn.Open "Provider=ADSDSOObject;" & _
"User Id=myUsername;" & _
"Password=myPassword" For more information, see: Microsoft OLE DB Provider for Microsoft Active Directory Service (http://msdn.microsoft.com/library/en-us/ado270/htm/mdrefadsprovspec.asp)
To view Microsoft KB articles related to Data Link File, click here (http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=mdac&Query=ADSDSOObject&Queryc=ADSDSOObject&REF=false&srchstep=0&KeywordType=PHRASE&Titles=false&numDays=&maxResults=100)

[noorsoft]

OLE DB Provider for Advantage

oConn.Open "Provider=Advantage OLE DB Provider;" & _
"Data source=c:\myDbfTableDir;" & _
"ServerType=ADS_LOCAL_SERVER;" & _
"TableType=ADS_CDX" For more information, see: Advantage OLE DB Provider (for ADO) (http://www.advantagedatabase.com/ADS/Product+Detail/Advantage+OLE+DB+Provider/default.htm)

[noorsoft]

OLE DB Provider for AS/400 (from IBM)


oConn.Open "Provider=IBMDA400;" & _

"Data source=myAS400;" & _

"User Id=myUsername;" & _

"Password=myPassword"

For more information, see: A Fast Path to AS/400 Client/Server (http://publib-b.boulder.ibm.com/Redbooks.nsf/RedbookAbstracts/sg245183.html)

[noorsoft]

OLE DB Provider for AS/400 and VSAM (from Microsoft)


oConn.Open "Provider=SNAOLEDB;" & _

"Data source=myAS400;" & _

"User Id=myUsername;" & _

"Password=myPassword"

For more information, see: ConnectionString Property (http://msdn.microsoft.com/library/en-us/his/htm/_sna_activeconnection_property_support_using_the_o le_db_provider_for_as_400_and_vsam_oledb.asp)


To view Microsoft KB articles related to OLE DB Provider for AS/400 and VSAM, click here (http://support.microsoft.com/search/default.aspx?Catalog=LCID=1033&CDID=EN-US-KB&PRODLISTSRC=ON&Product=&KeywordType=&Titles=false&numDays=&maxResults=25&withinResults=&Queryl=SNAOLEDB&Query=SNAOLEDB&QuerySource=gsfxSearch_Query)

[noorsoft]

OLE DB Provider for Commerce Server



For Data Warehouse
oConn.Open "Provider=Commerce.DSO.1;" & _
"Data Source=mscop://InProcConn/Server=mySrvName:" & _
"Catalog=DWSchema:Database=myDBname:" & _
"User=myUsername:Password=myPassword:" & _
"FastLoad=True"

' Or

oConn.Open "URL=mscop://InProcConn/Server=myServerName:" & _
"Database=myDBname:Catalog=DWSchema:" & _
"User=myUsername:Password=myPassword:" & _
"FastLoad=True"
For Profiling System
oConn.Open "Provider=Commerce.DSO.1;" & _
"Data Source=mscop://InProcConn/Server=mySrvName:" & _
"Catalog=Profile Definitions:Database=myDBname:" & _
"User=myUsername:Password=myPassword"

' Or

oConn.Open _
"URL=mscop://InProcConnect/Server=myServerName:" & _
"Database=myDBname:Catalog=Profile Definitions:" & _
"User=myUsername:Password=myPassword" For more information, see: OLE DB Provider for Commerce Server (http://msdn.microsoft.com/library/en-us/comsrv2k/htm/cs_rp_oledb_vgwa.asp), DataWarehouse (http://msdn.microsoft.com/library/en-us/comsrv2k/htm/cs_rp_oledb_ehaa.asp), and Profiling System (http://msdn.microsoft.com/library/en-us/comsrv2k/htm/cs_rp_oledb_ehff.asp)
To view Microsoft KB articles related to OLE DB Provider for Commerce Server, click here (http://support.microsoft.com/search/default.aspx?Catalog=LCID=1033&CDID=EN-US-KB&PRODLISTSRC=ON&Product=&KeywordType=&Titles=false&numDays=&maxResults=25&withinResults=&Queryl=Commerce.DSO&Query=Commerce.DSO&QuerySource=gsfxSearch_Query)

[noorsoft]

OLE DB Provider for DB2 (from Microsoft)


For TCP/IP connections
oConn.Open = "Provider=DB2OLEDB;" & _
"Network Transport Library=TCPIP;" & _
"Network Address=xxx.xxx.xxx.xxx;" & _
"Initial Catalog=MyCatalog;" & _
"Package Collection=MyPackageCollection;" & _
"Default Schema=MySchema;" & _
"User ID=MyUsername;" & _
"Password=MyPassword"

For APPC connections
oConn.Open = "Provider=DB2OLEDB;" & _
"APPC Local LU Alias=MyLocalLUAlias;" & _
"APPC Remote LU Alias=MyRemoteLUAlias;" & _
"Initial Catalog=MyCatalog;" & _
"Package Collection=MyPackageCollection;" & _
"Default Schema=MySchema;" & _
"User ID=MyUsername;" & _
"Password=MyPassword"
For more information, see: ConnectionString Property (http://msdn.microsoft.com/library/en-us/his/htm/_sna_activeconnection_property_support_using_the_o le_db_provider_for_db2_oledb.asp), and Q218590 (http://support.microsoft.com/default.aspx?scid=kb;EN-US;q218590)

To view Microsoft KB articles related to

[noorsoft]

OLE DB Provider for DTS Packages

The Microsoft OLE DB Provider for DTS Packages is a read-only provider that exposes Data Transformation Services Package Data Source Objects.
oConn.Open = "Provider=DTSPackageDSO;" & _
"Data Source=mydatasource"
For more information, see: OLE DB Providers Tested with SQL Server (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_12_6uyb.asp)
To view Microsoft KB articles related to OLE DB Provider for DTS Packages, click here (http://support.microsoft.com/search/default.aspx?Catalog=LCID=1033&CDID=EN-US-KB&PRODLISTSRC=ON&Product=&KeywordType=&Titles=false&numDays=&maxResults=25&withinResults=&Queryl=OLE+DB+Provider+DTS+Packages&Query=OLE+DB+Provider+DTS+Packages&Query)

[noorsoft]

OLE DB Provider for Exchange

oConn.Provider = "EXOLEDB.DataSource"
oConn.Open = "http://myServerName/myVirtualRootName" For more information, see: Exchange OLE DB Provider (http://msdn.microsoft.com/library/en-us/wss/wss/wss_references_oledb.asp), Messaging (http://msdn.microsoft.com/library/en-us/wss/wss/_cdo_sending_and_posting_messages.asp), Calendaring (http://msdn.microsoft.com/library/en-us/wss/wss/_clb_viewing_the_calendar_using_ado_vbs.asp), Contacts (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wss/wss/_cdo_idatasource_savetocontainer.asp), and Exchange using ADO objects (http://msdn.microsoft.com/library/en-us/wss/wss/_exch2k_using_ado_objects.asp)
To view Microsoft KB articles related to OLE DB Provider for Exchange, click here (http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=mdac&Query=Exchange&Queryc=Exchange&REF=false&srchstep=0&KeywordType=ALL&Titles=false&numDays=&maxResults=100)

[noorsoft]

ODBC Driver for Excel

oConn.Open "Driver={Microsoft Excel Driver (*.xls)};" & _
"DriverId=790;" & _
"Dbq=c:\somepath\mySpreadsheet.xls;" & _
"DefaultDir=c:\somepath" For more information, see: Microsoft Excel Driver Programming Considerations (http://msdn.microsoft.com/library/en-us/odbc/htm/odbcjetmicrosoft_excel_driver_programming_consider ations.asp)
To view Microsoft KB articles related to Microsoft Excel Driver, click here (http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=mdac&Query=Microsoft%2520Excel%2520Driver&Queryc=Microsoft+Excel+Driver&REF=false&srchstep=0&KeywordType=PHRASE&Titles=false&numDays=&maxResults=100)

[noorsoft]

ODBC Driver for Access


For Standard Security:
oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=c:\somepath\mydb.mdb;"
If you are using a Workgroup (System database):
oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=c:\somepath\mydb.mdb;" & _
"SystemDB=c:\somepath\mydb.mdw;", _
"myUsername", "myPassword"

If want to open up the MDB exclusively
oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=c:\somepath\mydb.mdb;" & _
"Exclusive=1;"
If MDB is located on a Network Share
oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=\\myServer\myShare\myPath\myDb.mdb;"
If MDB is located on a remote machine

- Call an XML Web Service that contains data access web methods for MDB
(http://msdn.microsoft.com/library/default.asp?url=/nhp/Default.asp?contentid=28000442)- Or upgrade to SQL Server and use an IP connection string (http://www.carlprothman.net/Technology/ConnectionStrings/ODBCDSNLess/tabid/90/ctl/Edit/mid/421/Default.aspx?tabid=87#OLEDBProviderForSQLServerIP)


If you don't know the path to the MDB (using ASP)
<% ' ASP server-side code
oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=" & Server.MapPath(".") & "\db\myDb.mdb;"
%>
Make sure the Web identity has read/write permissions to the directory
the MDB is located in. e.g. "db" would need the read/write permissions.


If you don't know the path to the MDB (using VB)
oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=" & App.Path & "\myDb.mdb;" This assumes the MDB is in the same directory where the application is running.
For more information, see: Microsoft Access Driver Programming Considerations (http://msdn.microsoft.com/library/en-us/odbc/htm/odbcjetmicrosoft_access_driver_programming_conside rations.asp)

To view Microsoft KB articles related to Microsoft Access Driver, click here (http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=mdac&Query=Microsoft%2520Access%2520Driver&Queryc=Microsoft+Access+Driver&REF=false&srchstep=0&KeywordType=PHRASE&Titles=false&numDays=&maxResults=100)

[noorsoft]

ODBC Driver for MySQL (via MyODBC)

To connect to a local database (using MyODBC Driver)
oConn.Open "Driver={mySQL};" & _
"Server=MyServerName;" & _
"Option=16834;" & _
"Database=mydb" To connect to a remote database
oConn.Open "Driver={mySQL};" & _
"Server=db1.database.com;" & _
"Port=3306;" & _
"Option=131072;" & _
"Stmt=;" & _
"Database=mydb;" & _
"Uid=myUsername;" & _
"Pwd=myPassword" To connect to a local database (using MySQL ODBC 3.51 Driver)
oConn.Open "DRIVER={MySQL ODBC 3.51 Driver};" & _
"Server=myServerName;" & _
"Port=3306;" & _
"Option=16384;" & _
"Stmt=;" & _
"Database=mydatabaseName;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"OroConn.Open "DRIVER={MySQL ODBC 3.51 Driver};" & _
"SERVER=myServerName;" & _
"DATABASE=myDatabaseName;" & _
"USER=myUsername;" & _
"PASSWORD=myPassword;"
Note: When you first install MySQL, it creates a "root" user account (in the sys datbase's user table) with a blank password.
For more information, see: Programs Known to Work with MyODBC (http://www.mysql.com/doc/M/y/MyODBC_clients.html)

[noorsoft]

ODBC Driver for Oracle - from Microsoft


For the current Oracle ODBC Driver from Microsoft
oConn.Open "Driver={Microsoft ODBC for Oracle};" & _
"Server=OracleServer.world;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"

For the older Oracle ODBC Driver from Microsoft
oConn.Open "Driver={Microsoft ODBC Driver for Oracle};" & _
"ConnectString=OracleServer.world;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"
For more information, see: Connection String Format and Attributes (http://msdn.microsoft.com/library/en-us/odbc/htm/odbcoraclethe_odbc_driver_for_oracle.asp)

To view Microsoft KB articles related to Microsoft ODBC for Oracle, click here (http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=mdac&Query=Microsoft%2520ODBC%2520for%2520Oracle&Queryc=Microsoft+ODBC+for+Oracle&REF=false&srchstep=0&KeywordType=PHRASE&Titles=false&numDays=&maxResults=100)

[noorsoft]

ODBC Driver for Oracle - from Oracle

oConn.Open "Driver={Oracle ODBC Driver};" & _
"Dbq=myDBName;" & _
"Uid=myUsername;" & _
"Pwd=myPassword" Where: The DBQ name must be defined in the tnsnames.ora file
For more information, see: Oracle8 ODBC Driver Help (http://otn.oracle.com/docs/tech/windows/odbc/htdocs/817help/start.htm), Oracle ODBC FAQs (http://www.orafaq.com/faqodbc.htm), [asporacle] listserv FAQs (http://www.learnasp.com/learn/FAQOracleconnect.asp), and ASPDB Oracle (http://www.aspdb.com/doc2002/Oracle.shtm)

[noorsoft]

ODBC Driver for Oracle Rdb

oConn.Open "Driver={Oracle ODBC Driver for Rdb};" & _
"UID=myUserID;" & _
"PWD=myPassword;" & _
"SVR=aServerName;" & _
"XPT=2;" & _
"DATABASE=Attach 'filename disk:[dir1.dir2]rootfile';" & _
"CLS=aClassName;" & _
"DBA=W;" & _
"CSO=1;" & _
"TLL=aLibName;" & _
"TLO=0;" & _
"DSO=0;" & _
"PWV=secPassword" For connecting to a database over TCP/IP,

not using a specific SQL/Services class:
oConn.Open "Driver={Oracle ODBC Driver for Rdb};" & _
"UID=myUserID;" & _
"PWD=myPassword;" & _
"SVR=aServerName;" & _
"XPT=2;" & _
"DATABASE=Attach 'filename disk:[dir1.dir2]rootfile'" For connecting to a database over DECNET using a specific class,

not using pre-attached connection:
oConn.Open "Driver={Oracle ODBC Driver for Rdb};" & _
"UID=myUserID;" & _
"PWD=myPassword;" & _
"SVR=aServerName;" & _
"XPT=1;" & _
"DATABASE=Attach 'filename disk:[dir1.dir2]rootfile';" & _
"CLS=aClassName" For connecting to a database over TCP/IP through a class

that uses pre-attached connections:
oConn.Open "Driver={Oracle ODBC Driver for Rdb};" & _
"UID=myUserID;" & _
"PWD=myPassword;" & _
"SVR=aServerName;" & _
"XPT=2;" & _
"CLS=aClassName" For more information, see: Oracle ODBC Driver for Rdb (http://otn.oracle.com/products/rdb/htdocs/rdb_odbc/index.html)

[noorsoft]

ODBC Driver for Paradox

oConn.Open "Driver={Microsoft Paradox Driver (*.db )};" & _
"DriverID=538;" & _
"Fil=Paradox 5.X;" & _
"DefaultDir=c:\dbpath\;" & _
"Dbq=c:\dbpath\;" & _
"CollatingSequence=ASCII"
Note:MDAC 2.1 (or greater) requires the Borland Database Engine (BDE) to update Paradox ISAM fDBF files. (Q230126 (http://support.microsoft.com/support/kb/articles/Q230/1/26.ASP)).

Note: There is an extra space after "db" in the Paradox Driver name

For more information, see: Paradox Driver Programming Considerations (http://msdn.microsoft.com/library/en-us/odbc/htm/odbcjetparadox_driver_programming_considerations.a sp)

To view Microsoft KB articles related to Microsoft Paradox Driver, click here (http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=mdac&Query=Paradox&Queryc=Paradox&REF=false&srchstep=0&KeywordType=PHRASE&Titles=false&numDays=&maxResults=100)

[noorsoft]

ODBC Driver for SQL Server

Using the newer SQL Native Client driver (for SQL Server 2005)

For Standard Security oConn.Open "ODBC;Driver={SQL Native Client};" &
"Server=MyServerName;" & _
"Database=myDatabaseName;" & _
"Uid=myUsername;" & _
"Pwd=myPassword" For Trusted Connection Security oConn.Open "ODBC;Driver={SQL Native Client};" & _
"Server=MyServerName;" & _
"Database=myDatabaseName;" & _
"Trusted_Connection=yes" Using the MDAC ODBC Driver

For Standard Security oConn.Open "Driver={SQL Server};" &
"Server=MyServerName;" & _
"Database=myDatabaseName;" & _
"Uid=myUsername;" & _
"Pwd=myPassword" For Trusted Connection Security oConn.Open "Driver={SQL Server};" &
"Server=MyServerName;" & _
"Database=myDatabaseName;" & _
"Trusted_Connection=yes" To connect to SQL Server running on a remote computer (via an IP address)
oConn.Open "Driver={SQL Server};" & _
"Server=xxx.xxx.xxx.xxx;" & _
"Address=xxx.xxx.xxx.xxx,1433;" & _
"Network=DBMSSOCN;" & _
"Database=myDatabaseName;" & _
"Uid=myUsername;" & _
"Pwd=myPassword" Where:
- xxx.xxx.xxx.xxx is an IP address
- 1433 is the default port number for SQL Server.
- "Network=DBMSSOCN" tells ODBC to use TCP/IP rather than Named
Pipes (Q238949 (http://support.microsoft.com/support/kb/articles/Q238/9/49.ASP))

For more information, see: SQLDriverConnect (ODBC) (http://msdn.microsoft.com/library/en-us/odbcsql/od_odbc_d_4x4k.asp)
To view Microsoft KB articles related to ODBC Driver for SQL Server, click here (http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=mdac&Query=SQL%2520Server%2520ODBC%2520Driver&Queryc=SQL+Server+ODBC+Driver&REF=false&srchstep=0&KeywordType=ALL&Titles=false&numDays=&maxResults=100)

[noorsoft]

ODBC Driver for Visual FoxPro


With a database container
oConn.Open "Driver={Microsoft Visual FoxPro Driver};" & _
"SourceType=DBC;" & _
"SourceDB=c:\somepath\mySourceDb.dbc;" & _
"Exclusive=No"

Without a database container (Free Table Directory)
oConn.Open "Driver={Microsoft Visual FoxPro Driver};" & _
"SourceType=DBF;" & _
"SourceDB=c:\somepath\mySourceDbFolder;" & _
"Exclusive=No"
For more information, see: Visual FoxPro ODBC Driver (http://msdn.microsoft.com/library/en-us/dv_foxhelp/html/dggrfoledbproviderforvisualfoxpro.asp) and Q165492 (http://support.microsoft.com/support/kb/articles/Q165/4/92.ASP)

To view Microsoft KB articles related to ODBC Driver for Visual FoxPro, click here (http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=mdac&Query=FoxPro%2520Driver&Queryc=FoxPro+Driver&REF=false&srchstep=0&KeywordType=PHRASE&Titles=false&numDays=&maxResults=100)

[noorsoft]

OLE DB Provider for Index Server

oConn.Open "Provider=MSIDXS;" & _
"Data source=MyCatalog"
For more information, see: Microsoft OLE DB Provider for Microsoft Indexing Service (http://msdn.microsoft.com/library/en-us/ado270/htm/mdrefindservprovspec.asp)
To view Microsoft KB articles related to OLE DB Provider for Index Server, click here (http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=mdac&Query=MSIDXS&Queryc=MSIDXS&REF=false&srchstep=0&KeywordType=ALL&Titles=false&numDays=&maxResults=100)

[noorsoft]

OLE DB Provider for Internet Publishing

oConn.Open "Provider=MSDAIPP.DSO;" & _
"Data Source=http://mywebsite/myDir;" & _
"User Id=myUsername;" & _
"Password=myPassword"
' Or
oConn.Open "URL=http://mywebsite/myDir;" & _
"User Id=myUsername;" & _
"Password=myPassword"
For more information, see: Microsoft OLE DB Provider for Internet Publishing (http://msdn.microsoft.com/library/en-us/ado270/htm/mdhowusingadowithrosebud.asp) and Q245359 (http://support.microsoft.com/support/kb/articles/Q245/3/59.ASP)

To view Microsoft KB articles related to OLE DB Provider for Internet Publishing, click here (http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=mdac&Query=Internet%2520Publishing&Queryc=Internet+Publishing&REF=false&srchstep=0&KeywordType=ALL&Titles=false&numDays=&maxResults=100)

[noorsoft]

OLE DB Provider for Microsoft Jet

For standard security
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\somepath\myDb.mdb;" If using a Workgroup (System Database)
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\somepath\mydb.mdb;" & _
"Jet OLEDB:System Database=MySystem.mdw", _
"myUsername", "myPassword" Note, remember to convert both the MDB and the MDW to the 4.0

database format when using the 4.0 OLE DB Provider.


If MDB has a database password
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\somepath\mydb.mdb;" & _
"Jet OLEDB:Database Password=MyDbPassword", _
"myUsername", "myPassword"
If want to open up the MDB exclusively
oConn.Mode = adModeShareExclusive
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\somepath\myDb.mdb;" If MDB is located on a network share
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=\\myServer\myShare\myPath\myDb.mdb"
If MDB is located on a remote machine
- Or use an XML Web Service via SOAP Toolkit (http://msdn.microsoft.com/library/default.asp?url=/nhp/Default.asp?contentid=28000523) or .NET (http://msdn.microsoft.com/library/default.asp?url=/nhp/Default.asp?contentid=28000442)

- Or upgrade to SQL Server and use an IP connection string (http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForSQLServerIP)




If you don't know the path to the MDB (using ASP)
<% ' ASP server-side code
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath(".") & "\db\myDb.mdb;" & _
%> This assumes the MDB is in a sub-directory called "db" directory, which has Read/Write permissions for the Web site identity account (e.g. IUSR_XXXXX).


If you don't know the path to the MDB (using VB)
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & App.Path & "\myDb.mdb;" & _
"User Id=admin;" & _
"Password=" This assumes the MDB is in the same directory where the application is running.
For more information, see: OLE DB Provider for Microsoft Jet (http://msdn.microsoft.com/library/en-us/ado270/htm/mdrefjetprovspec.asp), Q191754 (http://support.microsoft.com/support/kb/articles/Q191/7/54.ASP), and Q225048 (http://support.microsoft.com/support/kb/articles/Q225/0/48.ASP)
Note: Microsoft.Jet.OLEDB.3.51 only gets installed by MDAC 2.0. Q197902 (http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q197902)

Note: MDAC 2.6 and 2.7 do not contain any of the JET components. Q271908 (http://support.microsoft.com/support/kb/articles/Q271/9/08.ASP) and Q239114 (http://support.microsoft.com/support/kb/articles/Q239/1/14.ASP)
To view Microsoft KB articles related to OLE DB Provider for Microsoft JET, click here (http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=mdac&Query=Jet%2520OLEDB&Queryc=Jet+OLEDB&withinResults=false&srchstep=0&KeywordType=ALL&Titles=false&numDays=&maxResults=100)

You can also open an Excel Spreadsheet using the JET OLE DB Provider
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\somepath\mySpreadsheet.xls;" & _
"Extended Properties=""Excel 8.0;HDR=Yes""" Where "HDR=Yes" means that there is a header row in the cell range

(or named range), so the provider will not include the first row of the

selection into the recordset. If "HDR=No", then the provider will include

the first row of the cell range (or named ranged) into the recordset.
For more information, see: Q278973 (http://support.microsoft.com/default.aspx?scid=kb;en-us;278973)
You can also open a Text file using the JET OLE DB Provider
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\somepath\;" & _
"Extended Properties=""text;HDR=Yes;FMT=Delimited""" 'Then open a recordset based on a select on the actual file
oRs.Open "Select * From MyTextFile.txt", oConn, _
adOpenStatic, adLockReadOnly, adCmdText For more information, see: Q262537 (http://support.microsoft.com/support/kb/articles/Q262/5/37.ASP)

[noorsoft]

OLE DB Provider for Microsoft Project

oConn.Open "Provider=Microsoft.Project.OLEDB.9.0;" & _
"Project Name=c:\somepath\myProject.mpp" For more information, see: Microsoft Project 2000 OLE DB Provider Information (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnproject/html/projoledb.asp)
To view Microsoft KB articles related to OLE DB Provider for Microsoft Project, click here (http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=mdac&Query=Microsoft%2520Project&Queryc=Microsoft+Project&withinResults=false&srchstep=0&KeywordType=ALL&Titles=false&numDays=&maxResults=100)

[noorsoft]

OLE DB Provider for mySQL

oConn.Open "Provider=MySQLProv;" & _
"Data Source=mySQLDB;" & _
"User Id=myUsername;" & _
"Password=myPassword" For more information, see: API - OLE DB (http://www.mysql.com/doc/en/index.html) and Snippet (http://www.coveryourasp.com/Snippet.asp?snip=16)