VB6 app with RDC, Perasive Data unable to connect to the data

[tconway]

I have searched everywhere for a connection string (or method) to connect to a Pervsive database using a VB6 application and the RDC.

Does anyone have sample code of this. From what I have been reading so far, I wonder if it is possible?

I've tried
LogOnServer
LogOnserverEx
SetLogOnInfo

...and every variation I can think of, including ADO connection strings that DO work. The LogOnServerEx seems to provide the most flexibility but still NG.

Has anyone opened a simple report using the RDC based on Pervasive data and gotten past the "Server has not been opened" error or "Data source name not found and no default driver specified successfully?

Here are some things that don't work

CrxReport.Database.Tables(1).SetLogOnInfo "CLINTON-SERVER", "SAMPLE", "MANAGER", ""

CrxReport.Database.LogOnServer "pdsodbc.dll", "CLINTON-SERVER", "MANAGER", ""

CrxReport.Database.LogOnServerEx "pdsodbc.dll", "CLINTON-SERVER", , , , , "Provider=PervasiveOLEDB;Data Source=SAMPLE;Location=CLINTON-SERVER;User ID=MANAGER;Password='' "

Thanks

Tim Conway