Prompting for login

[StephHansen]

I built a report using CR XI using ODBC Connections. Works fine on its own, but it prompts for username and pw the 1st time report is run. The users want to call the report through a 3rd party app. Works fine to call it, prompts for my parameters just fine. After you enter the parameters, when it goes to run the report, errors out saying:

CRW Error: logon failed
Details: Cannot find DSN in connection string:-2147189176: True

I have set the System DSN in ODBC connections with the password there.

I created the report using the SA account. The users run the report via their accounts.

How do I bypass login or make it trust what is in the dsn entry?

Stephanie

 

[MzKitty]

The problem is not the password, it is the DSN. The error is telling you that it can't find the DSN (ODBC connection) on their PC. Make sure that the database server has the system DSN on it.