I've had spotty success (in Vantage 6.1) with linking via a connection set up as a File DSN instead of a System DSN. In the file version you can add the username and password. In our case I also use a seperate user (not the sysprogress username) that was set up with restricted table grants. I have not used this with CR (yet) but when linking to external data with Excel or Access it does not prompt for a password. Funny thing too is it shows ALL the tables but will only allow selecting the granted ones. The times it has not worked are when an external Access based system we have tries to link tables via VB code. I'm still working with the vendor on resolving that since I don't have access to that code.
The File DSN I use looks like:
[ODBC]
DRIVER=MERANT 3.60 32-BIT Progress SQL92 v9.1D
UID=LOSODBC
PWD=LOSodbc
DefaultIsolationLevel=READ UNCOMITTED
DB=mfgsys61
PORT=6150
HOST=Vantage
It is saved on each PC that needs it in the C:\Program Files\Common Files\ODBC\DataSources folder as xxxxx.dsn If not worried about table access then the UID/PWD could both be sysprogress (or whatever works when you get prompted).
-Todd C.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Charlie Wilson
Sent: Tuesday, February 03, 2009 8:08 AM
To: vantage@yahoogroups.com
Subject: [Vantage] FW: Crystal report asking for PW
All,
I have gone in and done some customization to the job trav. Report. I had to
link a couple tables from the DB into the XML data in order to get the data
I was after. However now each time we run the Job Trav. It ask us for the DB
password. Is there a way that I can make it not ask for this password and
auto populate this info?
~Charlie
The File DSN I use looks like:
[ODBC]
DRIVER=MERANT 3.60 32-BIT Progress SQL92 v9.1D
UID=LOSODBC
PWD=LOSodbc
DefaultIsolationLevel=READ UNCOMITTED
DB=mfgsys61
PORT=6150
HOST=Vantage
It is saved on each PC that needs it in the C:\Program Files\Common Files\ODBC\DataSources folder as xxxxx.dsn If not worried about table access then the UID/PWD could both be sysprogress (or whatever works when you get prompted).
-Todd C.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Charlie Wilson
Sent: Tuesday, February 03, 2009 8:08 AM
To: vantage@yahoogroups.com
Subject: [Vantage] FW: Crystal report asking for PW
All,
I have gone in and done some customization to the job trav. Report. I had to
link a couple tables from the DB into the XML data in order to get the data
I was after. However now each time we run the Job Trav. It ask us for the DB
password. Is there a way that I can make it not ask for this password and
auto populate this info?
~Charlie