Using linked server - syntax error

		Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
Using linked server - syntax error

SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

November 5th, 2008, 05:37 PM

snufse

Friend of Wrox

Join Date: Mar 2007

Posts: 205

Thanks: 4

Thanked 0 Times in 0 Posts

Using linked server - syntax error

I have defined a linked server and a sp residing on db2 machine.

When I call the sp, I get error at line 3:

Code:

declare @bcmcu char(12)
Set @bcmcu ='     1100281'  
Exec ('Call QGPL.get_jobs(?)', @bcmcu) AT AS400SRV_MSDASQL

Incorrect syntax near ','.

Now, when I call the same on a SQL Server 2005 it works fine.

Any ideas? Is there a difference between 2000 and 2005?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Linked Server Question	realgone_	SQL Server 2000	4	December 14th, 2005 02:48 PM
Linked server transaction error	harido	SQL Server 2000	2	September 30th, 2005 01:54 PM
linked server	ginoitalo	SQL Server 2000	2	September 30th, 2004 08:16 AM
Update - Linked Server	venkatpala	SQL Server 2000	3	August 25th, 2003 11:45 AM