turbot_yu
asked on
How to use ADODB connect to DB2
Hi Experts,
I am in a VBA(iFix) program.
I need to use ADODB to connect to DB2 database.
The sample code is below.
But I need to change from 'sql server' to 'DB2', since now I am using DB2 database.
May I know how to do it?
Thanks and Regards,
Turbot
conODBC.Open "driver= _
& " SQL server};server=thunder;uid =sa;pwd=;d atabase=ma ster"
I am in a VBA(iFix) program.
I need to use ADODB to connect to DB2 database.
The sample code is below.
But I need to change from 'sql server' to 'DB2', since now I am using DB2 database.
May I know how to do it?
Thanks and Regards,
Turbot
conODBC.Open "driver= _
& " SQL server};server=thunder;uid
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Do you have the correct odbc-drivers ? What version of mdac do you have ?
ASKER
where to find the mdac,
I can link to db2 by other method in same pc
I can link to db2 by other method in same pc
ASKER