Crystal Reports Authentication

[Magosoft]

PLEASE!!!! I NEED HELP.
I have this application made in VB6 that connects a PostgreSQL DB via ODBC and I need to use Crystal Reports as the reporting tool.

Here's the deal:
Every time the application does a query or executes an INSERT, DELETE or UPDATE, it uses a connection string (including username and password) to connect and Authenticate. However when I try to display a report using the Crystal Reports Activex, it doesn't display nothing at all and returns me this error message: "Cannot open SQL server".

I think it's because the component needs to send the username and password to authenticate, however I can't find where i have to do that.

ANY ideas or suggestions will be greatly appreciated.

Thanks in advanced,

MAGO

 

[FVTrainer]

Read this document and then download the appropriate sample apps from the Crystal kb:

http://support.crystaldecisions.com/communityCS/TechnicalPapers/apps_rdc.pdf.asp