ODBC auto login
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.