RE: ODBC Security

Mark,  I often do that but then my clients change the password on the AS400
and I have to walk them through how to change the program.

Also, if the info is sensitive, they'd rather enter in a password each time.

--Paul Holstein

On Tue, 9 May 2000 14:49:34 -0700 , BPCS-L@midrange.com wrote:

>  > The Netsoft drivers ask me for my username and password each 
>  > and every time I run any query.  If my query calls another query, I
have
>  to 
>  > log in two or more times every time I run it.
>  
>       Paul,
>  
>       Sorry for the delay. You didn't say what application you were using,
>  but I have seen this happen with Crystal Reports on some of our web
reports.
>  To avoid this you have to pass the user ID and password in the URL (we
use
>  hidden fields and a read-only ID for reports). When this is done there is
no
>  prompting at all. If you have subreports you'll need to pass it multiple
>  copies of the ID and P/W (userID0=, userID1=, etc.). 
>  
>       If you're using M$ Abcess (That's a keeper! Wish I'd thought of it.)
>  you can choose to save the password when you set up links to the tables. 
>  
>       Does any of this sound familiar at all?
>  
>   Mark Watkins
>   Programmer / Analyst
>   Shaklee Companies
>   Norman Manufacturing Center
>   (405) 573 4293
>   mwatkins@shaklee.com
>  





_______________________________________________________
Get 100% FREE Internet Access powered by Excite
Visit http://freelane.excite.com/freeisp

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---