VB, Crystal Reports 9.0 RDC - Login Trouble

[jkb17]

Hello.
I am using Crystal 9.0 and trying to automate a VB 6.0 process that will allow crystal to generate several PDF documents. I am using MS SQL Server as my database and connecting via ODBC. From within my code I have the following line:

objApplication.LogOnServerEx "p2sodbc.dll", "odbcName", "db", "user", "pwd"

however, the report fails with a invalid login error. The information is correct and when run from the report itself will LOGIN successfully. Any help, tips or advice.

thanks
Jim

 

[IdoMillet]

What database authentication method?

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com