I use
ThisForm.oleCrystal.Connect="DSN=Visual FoxPro Tables"
HTH
Elyse
>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 ?
Elyse Pomerantz