Failed to open the connection. C:\WINDOWS\TEMP\{6DAD2499-C4BC-4C0B-B59B-7FB

[Former Member]

For some reason when I run a specific report I'm getting the above error.

[Former Member · Accepted solution]

Hi Robert,

This type of error occurs due to permissions issue.

Check the permissions of TEMP folder.

Regards,

Shweta

[Former Member · Accepted solution]

Nice try but it didn't work

[Former Member · Accepted solution]

Hi Robert,

Go for a quick test to test your connection.

-Right Click on desktop ->

Create new text document->

Save as test.UDL->

double click and test connection by selecting driver name,datasource name,user id and password.

Click on Test Connection.

It should be succeed.

What is the version of crystal report you are using ?

What database connection you are using (ODBC/OLEDB)?

Is the issue is with single report or all the report?

Are you running your application through custom application .Net or java?

Regards,

Shweta

[Former Member · Accepted solution]

Shweta;

The file.udl tested fine, the connection in that regard works well, and here are the answers to your questions, my answers in BOLD

What is the version of crystal report you are using ?

The Report Designer / Developer is version 11.5.9.1076

What database connection you are using (ODBC/OLEDB)?

ODBC

Is the issue is with single report or all the report?

Couple of reports, not all

Are you running your application through custom application .Net or java?

NO, we develop reports through designer / developer and publish them to CR XI / 11.5, from there people view them via InfoView only

[Former Member · Accepted solution]

Hi Robert,

The error message might occurs because a File DSN or User DSN exists with the same name as the System DSN used by the report.

To resolve error message:

-Click Start > Control Panel > Administrative Tools > Data Sources (ODBC) on the Crystal Reports Server computer. The ODBC Data Source Administrator dialog box appears.

-Click the File DSN tab and User DSN tab to locate the File DSN or User DSN with the same name as the System DSN used by the report.

-Delete that File DSN or User DSN.

Now try to run reports.

Regards,

Shweta

[Former Member · Accepted solution]

Please call me I'm running out of time.

[former_member11696]

Forums is a public area for all to use. If you need help from and Support Engineer please purchase a case from this link:

http://store.businessobjects.com/store/bobjamer/DisplayProductByTypePage&parentCategoryID=&categoryI...