ODBC Please

[Mark Sreeves]

How do I open a database in vb using a database specified as a datasource in ODBC? rather than specifying the path to the database.



------------------
Mark Sreeves
Analyst Programmer

Mark.Sreeves@Softlab.co.uk
A BMW Group Company

[Jamppa]

try following

Set adoConn = New ADODB.Connection
adoConn.Open "ODBC Name of DB", "sa", ""