Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CR XI - Parameter - Static List of Values - can't connect to db

Status
Not open for further replies.

CrystalLion

Programmer
Jan 3, 2007
113
US
I am runiing Crystal Reports XI against an SQL view of a Progress database. My reports are installed at several client sites. For some reason, when I go to populate the parameter dropdown list via the
List of Values (select field)
Actions
Append all database values

instead of populating the list, I get a request to log on to the sql db server. the string in upper right corner of the window banner says:

Logon: Driver Name=crdb_odbc.dll;ServerName=foundsql92;database Name=;

The grayed-out server name is foundsql92
The User Name is sysprogress (as it is with all of our user names), and the password is being entered correctly.

The error window says

Logon failed.
Error in file UNKNOWN.RPT:
unable to connect:Incorrect logon parameters.(rptControllers.dll)

This does not happen all the time.

Any thoughts would be appreciated.
Thanks

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top