Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ODBC auto login

Hello,

We're moving Crystal Reports to new server, simultaneously switching to a new version of CR XI from 8.5. Database server is working on Pervasive SQL Server v.10, and database is connected via ODBC, so on the new server I've created the same System DSNs as at old server. Reports are opening ok, however, getting a problem with a popup DB user prompt

every time when need to refresh data.

Login works - but how to avoid using it? Users are not supposed to enter this account credentials, and old server running CR 8.5 is not asking for that. Please advice if there is a way:

a) to avoid db logon popup;

b) to keep CR db account credentials within CR settings;

c) to keep DB connection persistent, so users don't have to login every time

they open CR.

Any help please? Not an expert in CR, but have to make a move for our customers.

Not what you were looking for? View more on this topic or Ask a question