ODBC Connection details being saved

[SQLWilts]

Hi,

I have a number of reports that use an ODBC link to an AS400 database. The problem is that its remembering my connection details in the report. I want it to ask for a user name and password first time out, and then to use that user name to access the database. This has nothing to do with the AS400 side - the connection details are held within the report itself - found it when I opened the report in notepad. Refresh location doesn't work - it still asks for a name and password every time. Does ANYONE know how to persuade Crystal to ask just the once, and then hold that information?

 

[pgtek]

Hi can you be more specific.
Are you calling your report from an application
or from the web.
Please give more detail on what your trying to accomplish

cheers



pgtek

 

[SQLWilts]

Hiya PGTek,

Rght, we are using Crystal 8 developer with the compiled reports addin. What we want to do is to compile a report, send it out to the user, he/she double clicks it and, providing he/she has the ODBC datasource loaded, it prompts for a user name and password and produces the report.
What is happening now is that it asks repeatedly for each table for a password for the developers user name when the report is run. I can see the developers name in the crystal report if I open it in notepad - there must be some way to persuade Crystal to either use the windows log-on, or prompt just the once for a user name and password

 

[pgtek]

hi
is this report a static or dynamic?
Meanning does the data remains the same or does it have to refresh to get the new data?
If the data remains the same and does not need to refresh.
Save your report with data, then compile it and that should be fine

cheers



pgtek

 

[pgtek]

hi
One other thing if your getting prompt for every table that mean the password and userd id not sent.

cheers

pg

pgtek

 

[SQLWilts]

Hi,

The report is dynamic, unfortunatly. I know that its holding the user info within the report as you can see it if you open the report in notepad. The users can overtype the name & use their own, but it can get a little laboureous to have to do that for every table in a complicated report

 

[maryellc]

This may be a silly question but do the users have the appropriate DSN's defined for the database(s) that you are attempting to access in your report? Within the ODBC configuration you can select to have the log in to the database occur using a network login id or using a specified login id for the database (group id etc).

In the past when I attempted to run a distributed report where I neglected to configure the ODBC for the data source, I would get prompted to log in once for each table within the database.

 

[purefreshair]

Hello maryellc,

I am having the same issue as described by TonyWhite. I devloped and complied for distribution a dynamic report with an ODBC connection to our AS400. Each user has to log in several times; the default username on the login prompt is me (the developer). Each user has the correct User DSN set up for Client Access. What else do I need to do so that the user only has to log in once?