Linked Server error 16902

[cmetters]

Hi.

I've set up a linked server to a SQL 6.5 database from a SQL 2000 server and am trying to execute the following update query against a table on the 6.5 database:

insert into CALLCTIL_S01.TrainTeleconnect.dbo.agentslocal
(ID,Agent,Password,login,AgentFull)
Values
(7, 'TR7', 'test', 2607, 'Test Agent 7')

But I get the following error:

sp_cursor: The parameter 'table' is invalid

The following Select statement works fine:

select * from CALLCTIL_S01.TrainTeleconnect.dbo.agentslocal


Any ideas?

Thanks in advance,

Chris

 

[tlbroadbent]

It appears to be a bug in SQL Server 6.5.

http://support.microsoft.com/default.aspx?scid=kb;en-us;172615

You might be able to work around this bug by using OpenQuery. This works from SQL 2000 to another SQL 2000 Server. I don't have a SQL 6.5 server to test on.

Insert OpenQuery(CALLCTIL_S01, 'Select ID, Agent, Password, login, AgentFull From TrainTeleconnect.dbo.agentslocal')
Values (7, 'TR7', 'test', 2607, 'Test Agent 7') Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.

 

[cmetters]

Hey Terry, thanks a lot for the info. I will try your workaround on Monday when I'm back at work.

Cheers.