RE: ODBC Security

> 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


> -----Original Message-----
> From: Paul Holstein [mailto:holstein13@excite.com]
> Sent: May 05, 2000 8:25 PM
> To: BPCS-L@midrange.com
> Subject: RE: ODBC Security
> 
> 
> Mark,
> 
> Netsoft has a great feature in the read only version of its 
> ODBC driver,
> however, it has one characteristic that I can't understand.
> 
> 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.  Needless to say this gets 
> pretty annoying.
> 
> Also, my casual observations are that the Client Access ODBC 
> drivers are
> more stable and faster than the Netsoft.  Unfortunately, I 
> have no objective
> proof of that but maybe Mike Breitbach could offer some 
> insight into this.
> 
> --Paul Holstein
> iWork Software, L.L.C.
> 
> On Fri, 5 May 2000 12:20:31 -0700 , BPCS-L@midrange.com wrote:
> 
> >     Netsoft provides ODBC drivers that allow you to install 
> a read-only
> >  version, which makes it impossible to change data. The user can not
> toggle
> >  this setting. Similar drivers may be available from other 
> vendors as
> well.
> >  
> >   Mark Watkins
> >   Programmer / Analyst
> >   Shaklee Companies
> >   Norman Manufacturing Center
> >   (405) 573 4293
> >   mwatkins@shaklee.com
> >  
> >  
> >  > -----Original Message-----
> >  > From: Warren, Rick [mailto:RWarren@burco.com]
> >  > Sent: May 05, 2000 1:22 PM
> >  > Subject: RE: ODBC Security
> >  > 
> >  > When setting up the ODBC DSN you can go to the tab marked 
> >  > 'Other' and look
> >  > under connection type it gives you the option of setting the 
> >  > connection to
> >  > READ ONLY.  If a user wants to change it and has access 
> to the ODBC
> >  > administration program there is nothing to prevent them from 
> >  > making the
> >  > change though so it is not truly a security feature. 
> >  > 
> >  > -----Original Message-----
> >  > From: Joel Kahsay [mailto:jkahsay@hotmail.com]
> >  > Sent: Friday, May 05, 2000 1:06 PM
> >  > Subject: ODBC Security
> >  > 
> >  > how do you set read only security for a pc using ODBC to 
> access files
> >  > in the AS400? Help

+---
| 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
+---