MSSQL and ODBC problem.

[Oxbow]

Hi guru types.

I have a job on SQL that connects via ODBC to a machine. When the user runs the job manually everything works fine, but when I get a SQL schedule to run it, it hangs.

I think the job is waiting for a password to be input. I have edited the ODBC but I cannot see how to put the password in to avoid the system from asking each time (which is what I think it is doing, although there is no password actually assigned to the job).

Any ideas?

TIA

 

[Oxbow]

you can encode a password in a connection string. Are you using windows authentication or seperate SQLServer usernames/passwords.

Its actually AS400, not SQL, although the job runs on SQL it seems to hang when it trys to access AS400.

Does this make sense?

 

[Oxbow]

Thanks for this so far.

Right, there is a ODBC connection with the AS400 user and password. In DTS it is used to connect to the database and extract the data to be loaded on SQL

Does that clarify it?