DSNLess Connection

UserPreferences

Clear message

"Dbq=" & Server.MapPath?(".") & "\myDb.mdb;" & _
"Uid=admin;" & _
"Pwd="

If you don't know the path to the MDB (using VB)

oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _

"Dbq=" & App.Path & "\myDb.mdb;" & _
"Uid=admin;" & _
"Pwd="

For more information, see: Microsoft Access Driver Programming Considerations

To view Microsoft KB articles related to Microsoft Access Driver, click here

ODBC Driver for AS/400 (from IBM)

ODBC Driver for dBASE

oRs.Open "Select * From user.dbf", oConn, , ,adCmdText?
Note: MDAC 2.1 (or greater) requires the Borland Database Engine (BDE) to update dBase DBF files. (Q238431).

For more information, see: dBASE Driver Programming Considerations

To view Microsoft KB articles related to Microsoft dBASE Driver, click here

ODBC Driver for Excel

"DriverId?=790;" & _
"Dbq=c:\somepath\mySpreadsheet.xls;" & _
"DefaultDir?=c:\somepath"

To view Microsoft KB articles related to Microsoft Excel Driver, click here

ODBC Driver for Informix

"Driver={INFORMIX 3.30 32 BIT};" & _
"Host=myHostname;" & _
"Server=myServerName?;" & _
"Service=myServiceName?;" & _
"Protocol=olsoctcp;" & _
"Database=myDbName?;" & _
"UID=myUsername;" & _
"PWD=myPassword" & _

"Host=myHostname;" & _
"Server=myServerName?;" & _
"Service=myServiceName?;" & _
"Protocol=onsoctcp;" & _
"Database=myDbName?;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"

oConn.Open "Driver={Informix-CLI 2.5 (32 Bit)};" & _

"Server=myServerName?;" & _
"Database=myDbName?;" & _
"Uid=myUsername;" & _
"Pwd=myPassword" & _

ODBC Driver for Interbase (from Easysoft)

"Server=myMachineName?;" & _
"Database=myC:\Home\Data\Mydb.gdb;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"

ODBC Driver for Interbase (from InterSolv?)

oConn.Open "Driver={INTERSOLV InterBase? ODBC Driver (*.gdb)};" & _

"Server=localhost;" & _
"Database=localhost:C:\Home\Data\Mydb.gdb;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"

oConn.Open "Driver={INTERSOLV InterBase? ODBC Driver (*.gdb)};" & _

"Server=myMachineName?;" & _
"Database=myC:\Home\Data\Mydb.gdb;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"

ODBC Driver for Lotus Notes

"Server=myServerName?;" & _
"Database=mydir\myDbName?.nsf;" & _
"Uid=myUsername;" & _
"Pwd=myPassword" & _

ODBC Driver for MySQL (via MyODBC)

"Server=MyServerName?;" & _
"Option=16834;" & _
"Database=mydb"

oConn.Open "Driver={mySQL};" & _

"Server=db1.database.com;" & _
"Port=3306;" & _
"Option=131072;" & _
"Stmt=;" & _
"Database=mydb;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"

ODBC Driver for Oracle (from Microsoft)

"Server=OracleServer?.world;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"

oConn.Open "Driver={Microsoft ODBC Driver for Oracle};" & _

"ConnectString?=OracleServer?.world;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"

To view Microsoft KB articles related to Microsoft ODBC for Oracle, click here

ODBC Driver for Oracle (from Oracle)

For more information, see: Oracle8 ODBC Driver Help, Oracle ODBC FAQs, asporacle? listserv FAQs, and ASPDB Oracle

ODBC Driver for Paradox

"DriverID=538;" & _
"Fil=Paradox 5.X;" & _
"DefaultDir?=c:\dbpath\;" & _
"Dbq=c:\dbpath\;" & _
"CollatingSequence?=ASCII"

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

For more information, see: Paradox Driver Programming Considerations

To view Microsoft KB articles related to Microsoft Paradox Driver, click here

ODBC Driver for SQL Server

"Server=MyServerName?;" & _
"Database=myDatabaseName?;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"

oConn.Open "Driver={SQL Server};" & _

"Server=MyServerName?;" & _
"Database=myDatabaseName?;" & _
"Uid=;" & _
"Pwd="

"Server=MyServerName?;" & _
"Database=myDatabaseName?;" & _
"Trusted_Connection=yes"

oConn.Properties("Prompt") = adPromptAlways?
oConn.Open "Driver={SQL Server};" & _

"Server=MyServerName?;" & _
"DataBase?=myDatabaseName?"

oConn.Open "Driver={SQL Server};" & _

"Server=(local);" & _
"Database=myDatabaseName?;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"

oConn.Open "Driver={SQL Server};" & _

"Server=xxx.xxx.xxx.xxx;" & _
"Address=xxx.xxx.xxx.xxx,1433;" & _
"Network=DBMSSOCN;" & _
"Database=myDatabaseName?;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"

Pipes (Q238949)

To view Microsoft KB articles related to ODBC Driver for SQL Server, click here

ODBC Driver for Sybase

"Srvr=myServerName?;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"

oConn.Open "Driver={SYBASE SYSTEM 11};" & _

"Srvr=myServerName?;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"

oConn.Open "Driver={INTERSOLV 3.10 32-BIT Sybase};" & _

"Srvr=myServerName?;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"

To view Microsoft KB articles related to ODBC Driver for Sybase, click here

ODBC Driver for Sybase SQL Anywhere

"DefaultDir?=c:\dbpath\;" & _
"Dbf=c:\sqlany50\mydb.db;" & _
"Uid=myUsername;" & _
"Pwd=myPassword;" & _
"Dsn="""""

For more information, see: Sybase SQL Anywhere User Guide

ODBC Driver for Teradata

"DBCName=MyDbcName?;" & _
"Database=MyDatabaseName?;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"

ODBC Driver for Text

oConn, adOpenStatic?, adLockReadOnly?, adCmdText?

For more information, see: Text File Driver Programming Considerations

To view Microsoft KB articles related to Microsoft Text Driver, click here

ODBC Driver for Visual FoxPro?

oConn.Open "Driver={Microsoft Visual FoxPro? Driver};" & _

"SourceType?=DBC;" & _
"SourceDB=c:\somepath\mySourceDb?.dbc;" & _
"Exclusive=No"

oConn.Open "Driver={Microsoft Visual FoxPro? Driver};" & _

"SourceType?=DBF;" & _
"SourceDB=c:\somepath\mySourceDbFolder?;" & _
"Exclusive=No"