Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
VB Code examples in Accessing the Universe Database.
- Thread starter jcastill
- Start date
Remember that ODBC and SQLOLEDB (I'm not sure about UniObjects) are not links to a database. Think of them as bridges to your data. ADO is a link that you can code with and manipulate. ADO will use the ODBC bridge to find and access your data.
To open a connection to your data through ADO via ODBC use the following code;
Dim CONN As New ADODB.Connection
CONN.ConnectionString = "Provider=MSDASQL;DSN=MyODBC"
CONN.Open
Thanks and Good Luck!
zemp
To open a connection to your data through ADO via ODBC use the following code;
Dim CONN As New ADODB.Connection
CONN.ConnectionString = "Provider=MSDASQL;DSN=MyODBC"
CONN.Open
Thanks and Good Luck!
zemp
- Status
Similar threads
- Question
- Locked
- Question
