| || |
Connecting to DB2 Databse
Can anyone pls. give me the code to connect to DB2 database and query the database?
Re: Connecting to DB2 Databse
Code no, help yes...
You'll want to use ActiveX Data Objects (ADODB) via an ODBC connection.
Get the MDAC 2.8 SDK here, help file "ADO210.chm" has plenty of code samples. Context sensitive help from the VBA IDE generally doesn't work.
DB2 ODBC driver will come from IBM, use it to create a Data Source Name on your PC.