RE: ODBC sign-on

["Christopher J. Devous" <cdevous@xxxxxxxxxxx>]

In the AS/400 connections properties dialog box on the as/400 connections 
tab, set the default user id to whatever value is appropriate for your 
environment.

If you use the NSRouter, go to the nsrouter properties systems tab, click 
on the properties button, and make sure the USERID/PASSWORD and PASSWORD 
VERIFICATION fields are BLANK.

You will get the password dialog on the first reboot, but should not get it 
thereafter.

--Chris

On Friday, November 05, 1999 10:13, Draper, Dale 
[SMTP:dale.draper@seu.sega.com] wrote:
> IBM stumper:
>
> Am trying to automate the sign-on process for an Access program that 
calls a
> user DSN to report off of AS400 data.
> Client Access is set to "cache password"
> Have tried both the CA connection and the DSN with a default userid.
>
> After signing on the 1st time and having cached the password, the user 
does
> not see a signon box.
> After rebooting the PC, the user will get the signon box, but if they 
escape
> off it (not OK or cancel), they receive a connection.
>
> Is there anything I can do to get rid of the sign on box?
>
> Both IBM and an AS400 ODBC pro are a bit stumped so far.
>
>
> Dale Draper
> Sega Enterprises, Inc. (USA)
> Dale.Draper@seu.sega.com
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to 
MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: 
david@midrange.com
> +---


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---