Problem in Crystal Report 11 Logon failed Vendor Code 4060- Please help

[Former Member]

We are using VB 6.0 as front end, SQL 2005 Express edition as a data base server back end and crystal report 11 as reporting tool on Windows XP with SP2. The problem is, In the local system where DB exits the report generates fine. But if DB in network system the report will not work and it will ask for connection information (Provide necessary information to Logon to the chosen data source). We are using ODBC to connect the report. And if we give the correct password the report will generate

I have checked all your help file and sample code but solution not found. please help as soon as possible

Regards

Karthik

[Former Member]

Hi Karthik,

Ensure the report is using the correct connection information. For example, the data source name, server name, database name, and user name are correct.

In a database-client test tool, ensure that the fields, tables, and procedures used by the report exist and that SQL queries can be executed against them.

In the Crystal Reports designer, verify that the SQL query, as shown under the Database menu Show SQL Query option, does not contain syntax errors.

If the SQL query shown in Crystal Reports is valid, execute the same SQL query through a database-client test tool.

Is report working fine in designer?

Which database connection are you using?

Regards,

Shweta