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





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