I work with SQL-server 7.0
The problem:
I made a program in VB, that: accesses outlook 2000 -using a profile-, reads attachment from mail in the inbox, deletes the mail after processing it and via Stored Procedures puts the data into tables on SQL-server.
The program works, when I execute the program manually on the server, where SQL-server is installed.
When I put the program in a package and create a job, executing this package; it doesn't work any more.
I use the same username, password as when I execute the program manually on the server.
The mail is not deleted and not read, so I presume there is a problem with accessing the mailbox via SQL-server.
Any suggestions?
I am most greatfull for any tips You can give me.
Mireille
The problem:
I made a program in VB, that: accesses outlook 2000 -using a profile-, reads attachment from mail in the inbox, deletes the mail after processing it and via Stored Procedures puts the data into tables on SQL-server.
The program works, when I execute the program manually on the server, where SQL-server is installed.
When I put the program in a package and create a job, executing this package; it doesn't work any more.
I use the same username, password as when I execute the program manually on the server.
The mail is not deleted and not read, so I presume there is a problem with accessing the mailbox via SQL-server.
Any suggestions?
I am most greatfull for any tips You can give me.
Mireille