Connection() shows password !

We have used the function Connection(“Data Provider Name”) in one of our reports that is saved to our intranet.
What is wonderful is that everything is shown, the user-id and password used for that connection also !!!

How to hide this ? We just want the connection name. Pierrot
__________________________________________________________ Pierrot HERITIER
Swiss Federal Railways, Mittelstrasse 43, CH-3030 Bern (Switzerland) Tel (++41) (512) 20 4484
Fax (++41) (512) 20 4485
e-mail : pher@royal.net


Listserv Archives (BOB member since 2002-06-25)

How 'bout using the substring function to just extract the connection name?


Listserv Archives (BOB member since 2002-06-25)

Pierrot wrote:
We have used the function Connection(“Data Provider Name”) in one of our reports that is saved to our intranet.
What is wonderful is that everything is shown, the user-id and password used for that connection also !!!

How to hide this ? We just want the connection name. ---------------------------------------------------- I tried this at our site with version 4.1.2 and this is the text that I get:

BO_DRV_CONNECT_MODE=0;BO_DSN=PDWHOUSE;ODBC_USER=BSOB;ODBC_PASSWORD=***;

Note, that the password has * replacing the value. We have connections that we have typed in the password
directly such as the example above and ones that us @variable(‘bopass’). In both cases the password is not shown.

Glenn Fredericks
Data Warehouse Specialist
glenn_fredericks@aal.org
(920) 730-4700 x4236 or 1-800 CALL AAL

Aid Association for Lutherans
4321 N. Ballard Road
Appleton, WI 54919-0001
Visit our Web site at www.aal.org or e-mail us at aalmail@aal.org

AAL… Financial services. Lutheran heritage. A powerful combination.


Listserv Archives (BOB member since 2002-06-25)