Using VB6 as front end querying Lotus Notes DB

[mmt4331]

I designed a Front End using VB6 and am trying to pull data out of a Lotus Notes Database. I have the statement in my code as:

Const ConnestStr = "Provider=Lotus Notes 4.63; etc, etc;"

I keep on getting an error msg "ADO could not find provider". I asked some Lotus Notes guys about if this is the proper provider and they said yes.

Could there be something wrong with how I got my ODBC set up - or is this simply the case that nobody really knows the correct provider?

Thx.

 

[gieboy]

You need to download the Lotus Notes SQL driver from the lotus notes web site. I already have a copy of the driver.
here is my e-mail address: gieluna@yahoo.com if you need help