Driver not capable when using NotesSql

I am trying to connect lotus database using notesSql v3.02. Iam using Microsoft ADO data object in my Visual Basic program to connect to the lotus databases.

I configured the DSN and here is the code.


Set adoConnection = New ADODB.Connection adoConnection.ConnectionString = “DSN=QuoteWerksDB”

adoConnection.Open


This is working fine on some of the machines (Xp, Windows 2000) and when I try this on Windows 2003 server I am getting the following error message

Run-time error -‘2147217843(80040e4d)’

[Lotus][ODBC Lotus Notes]Driver not capable


I uninstalled the Driver couple of time and re installed, but still getting the same error.

Any one has idea how to resolve this problem.

Thanks in advance for any help that you may offer.

Sree