What driver is MSDASQL using when connecting to DB2?

[tbt102]

I have a visual basic 6.0, ADO and DB2 application. When I use the ODBC Driver for DB2 I need to specify "MSDASQL" in the Provider argument.

I was under the impression that MSDASQL was a MS generic OLE DB provider with MS ODBC under the covers.

As a test I:
1) deleted the ODBC Driver for DB2 and the application continued to work
2) I restored the deleted dll
3) deleted the call level interface (db2cli.dll) and the
application stopped working

This leads me to believe that MSDASQL is making the calls directly to db2cli.dll

Question: is "MSDASQL" making calls to the DB2 Call Level Interface (db2cli.dll)?

Thanks in advance for any help.

 

[dishonty]

James did you ever get this resolved?
We are looking at the same situation, only db2 udb v8.1
Thanks,
Yvonne