February 12, 2003 at 10:36 am
Hello there,
I have a stored procedure (SQL 7) in on Server1, and data saved on Server2, I use asp to update a record then, I got
the follow message. What's wrong with this?
If I saved the record on Server1, the sp worked OK.
I checked the Users on Server2 for that Table, as database user, it has Select, Add, Update, Delete and DRI permissions checked. However, I could not set the EXEC column.
When I select the data, use sp on Server1 to retrieve data from Server2, it works OK.
How do I handle this? Please help!
=================
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned
message: Multiple-step OLE DB operation generated errors. Check each OLE
DB status value, if available. No work was done.]
=================
WooGor
WooGor
February 17, 2003 at 12:00 pm
This was removed by the editor as SPAM
February 18, 2003 at 4:18 am
Ok, can you walk us thru the flow of your SP on server 1 and how it gets to Server 2. Also, how is the connection to Server 2 defined for Server 1, do you have Data Access enabled and did you turn on MSDTC?
If you can please post your SP for us to understand the code.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply