Discussion Locked
0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
We can currently use a DTS to copy data from a SCO Unix .ddf file (as text) to a SQL Server 2000 table. This works if we run the DTS manually, but when we schedule it, we get an error "invalid password". How do we set up connection (with userid andpassword) so we can automate this job?
3 replies
by glen_mcleod
If it works when you're logged on, and you haven't given the connection object a user and password, then it's using the credentials of the currently logged on user (you) to connect to the SCO system when you're running it interactively. You probably have the appropriate permissions.
You have to specify a user and password with applicable rights on the SCO system in the DTS connection object.
Glen
by davet
Poster rated this answer
by davet
This question was closed by the author
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending
1 helpful
3 replies
Discussion Locked
What Makes a Business Website Effective in 2026
2 helpful
10 replies
0 helpful
1 reply
Question
Windows and macOS computers becoming slow or unstable after updates - what should I check first
0 helpful
1 reply
Discussion
Optimizing WordPress widgets and DOM size
0 helpful
3 replies