<div>
still not work, I donot need tcp.
</div>


<div>
Do you have the correct odbc-drivers ? What version of mdac do you have ?
</div>


Do you have the correct odbc-drivers ? What version of mdac do you have ?

<div>
where to find the mdac,<br />
I can link to db2 by other method in same pc
</div>


where to find the mdac,
I can link to db2 by other method in same pc

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I am in a VBA(iFix) program.<br />
I need to use ADODB to connect to DB2 database.<br />
<br />
The sample code is below.<br />
But I need to change from 'sql server' to 'DB2', since now I am using DB2 database.<br />
May I know how to do it?<br />
<br />
Thanks and Regards,<br />
<br />
Turbot<br />
<br />
<br />
&nbsp;conODBC.Open &quot;driver= _<br />
&nbsp; &nbsp; &amp;&nbsp;&quot; SQL server};server=thunder;uid<wbr />=sa;pwd=;d<wbr />atabase=ma<wbr />ster&quot; 
</div>
</div>


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=;database=master" 

How to use ADODB connect to DB2

A programming language is a formal constructed language designed to communicate instructions to a machine, particularly a computer. Thousands of different programming languages have been created, mainly in the computer field, and many more still are being created every year. The description of a programming language is usually split into the two components of syntax (form) and semantics (meaning). Some languages are defined by a specification document (for example, the C programming language is specified by an ISO Standard), while other languages (such as Perl) have a dominant implementation that is treated as a reference. Some languages have both, with the basic language defined by a standard and extensions taken from the dominant implementation being common.