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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting prompted for username and password with Access 97 database 1

Status
Not open for further replies.

Gauz

MIS
Jan 2, 2002
5
US
Not sure what the deal is. I can open the database I am running the report from fine. No prompting. I can run the report out of Crystal with no prompting. Once I place it online and login as administrator I get prompted for a username and password. Does anyone have any ideas?
 
Hi,

Check the ODBC connection once again. Make sure it is set up properly.

Vishal
 
Well I deleted the ODBC connection and added a new one and then it sort of worked. Now it launches, but if I do a refresh it just hangs. Checking event viewer I get the following error:

Source: Crystal_cacheserver
Category: PageServer
EventID: 35202
Cacheserver loses communication with pageserver

Any ideas?
 
Put the datasource in System DNS, not in User DNS.
 
I do have the datasource setup in the System DSN
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top