DTS and AS400 password

[sharonc]

I have a DTS that runs fine on my workstation. When I try to excute the DTS on the server, it ask for AS400 password. Is there away to keep the dts from asking for a password? Is there a way to hard code the password. I'm using client access odbc driver(32 bit) to connect to the AS400.

 

[tlbroadbent]

Open the DTS package and edit the AS400 connection. You should be able to put the login and password in the connection properties.

Note: I've not used AS400 or connected to an AS400 from DTS so it may differ from other connections but I wouldn't think so. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[sharonc]

I have the username and the password in the connection, but when the job runs it still ask for the password. Any other suggestions?

 

[tlbroadbent]

Sorry I can't be of more help. Perhaps someone who connects to an AS400 will jump in with a solution. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[deva1]

is this sql server 7.0 or sql server 2k.what is the task you are trying to run? please give me details? Hopefully I can help with this.You have to use other connection.There you can give the odbc(dsn) name and user name and password. it should make hte connection

 

[Dilyias]

I would look at your client access configuration about the connection settings.

And look at the ODBC you are using to connect to the AS400.

There may be something that differs from your client pc and the server. I've run DTS's on servers no problem with AS400 connections, but I've seen this type of thing come up with other applications and it was due to some client access configurations I believe.