08-15-2002, 09:53 AM
Hi, I am using SQL Server to extract data from AS/400. In my extract package I have defined UserID/Password for As/400. But the system still prompts for the password (UserID is there in UserID field). How can one avoid prompting of password. Becuase during the schedule job at night it hangs becuase he is looking for password. Any help will be appreciated.