N
Neil
I created a stored procedure to update a table on a linked server from a
table in my local server. Both servers are SQL 7, and the linked server is
accessed through the Internet. When I tried to create the stored procedure
using an Access 2000 ADP file, the save command would continually time out.
However, when I went into Enterprise Manager and created the stored
procedure there, it saved instantly. Once the SP was saved, it could be run
from the ADP file without any problem. But neither creating nor modifying
the SP would work through the ADP file.
Any ideas on why the ADP file would not be able to create or modify the SP,
but would be able to run it, or any ideas about what might be able to be set
in the ADP file to enable it?
Thanks!
table in my local server. Both servers are SQL 7, and the linked server is
accessed through the Internet. When I tried to create the stored procedure
using an Access 2000 ADP file, the save command would continually time out.
However, when I went into Enterprise Manager and created the stored
procedure there, it saved instantly. Once the SP was saved, it could be run
from the ADP file without any problem. But neither creating nor modifying
the SP would work through the ADP file.
Any ideas on why the ADP file would not be able to create or modify the SP,
but would be able to run it, or any ideas about what might be able to be set
in the ADP file to enable it?
Thanks!