I'm developing a Visual FoxPro application with version 5.0) using Crystal Reports 5.0.6.97. I've tried to logon the ODBC server by CRW ActiveX's properties Connect or the LogonServer method but each time I've a 20536 Error (error Logon server)
Driver are correctly installed, in fact by CRW I can see the reports' preview,
I've used this code to connect:
oApp.xoCrystalReport.Connect = "DSN = Visual FoxPro Database; UID =; PWD =;" oApp.xoCrystalReport.DataFiles(0) = lcPathMyDatabase
OR
oApp.xoCrystalReport.Connect = "DSN = Visual FoxPro Database; UID =; PWD =; DSQ = " + lcPathMyDatabase OR
IF !oApp.xoCrystalReport.LogonServer("VFPODBC.DLL", "Visual FoxPro Database", lcPathMyDatabase, "", "")
Messagebox("error in logon")
ENDIF
OR
IF !oApp.xoCrystalReport.LogonServer("PDSODBC.DLL", "Visual FoxPro Database", lcPathMyDatabase, "", "")
Messagebox("error in logon")
ENDIF
How can I logon the server by code ?