Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
dblock
Starting Member
2 Posts |
Posted - 2007-09-04 : 10:39:12
|
We use a lot of virtual machines. I have a base VM with SQL 2005 installed. I rename this VM (i have multiple copies running) and run an old application (VB code, iterates through recordsets, etc.).I get: Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server '2K3VM-DG' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.This makes sense, and I can fix it with sp_dropserver / sp_addserver [local]. Good.The next error is puzzling though:[Microsoft][ODBC SQL Server Driver][SQL Server]The cursor does not include the table being modified or the table is not updatable through the cursor. Any suggestions on how to fix this? |
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-04 : 23:09:19
|
Did you add server with 'sp_addserver new_name, local'? On which statement did you get cursor error? |
|
|
dblock
Starting Member
2 Posts |
Posted - 2007-09-15 : 10:27:15
|
Yep, that was it. sp_addserver wasn't run with local. Thx.quote: Originally posted by rmiao Did you add server with 'sp_addserver new_name, local'? On which statement did you get cursor error?
|
|
|
|
|
|