connecting to db2 using ASP

[amorous]

Hi All,

I am new to DB2. I have installed the IBM DB2 Client on my computer and also the different databases which i am going to use.

But i when i write the following connection string i am getting the error.

My connection String:
*****************************
<%StringConnect = &quot;Provider=DB2OLEDB;&quot; & _
&quot;Data Source =DCCDB;&quot; & _
&quot;Network Transport Library=TCPIP;&quot; & _
&quot;Network Address=192.168.95.200;&quot; & _
&quot;User ID=xyza;&quot; & _
&quot;Password=scgmlk&quot;
%>

*****************************

Error:
*****************************
Error Type:
ADODB.Connection (0x800A0E7A)
Provider cannot be found. It may not be properly installed.

*****************************
On the ASP page my code looks like:

Set rsObj = Server.CreateObject(&quot;ADODB.Recordset&quot
Set MdConnection = Server.CreateObject(&quot;ADODB.Connection&quot

MdConnection.Open StringConnect


Any suggestions.

Thanks in advance

VJ