What is the purpose of the OPENQUERY syntax?   

Hello,

I am using linked servers over ODBC. Most queries fail, however, they work 
when I use the OPENQUERY syntax. This appears to be a problem of at least 
SQL server 2000 and 2005 express. Strange, but MS ACCESS databases work 
perfectly with the ODBC-linked tables with "normal" sql-syntax.

I would like to know if there are other solutions than OPENQUERY as this 
causes new problem eg. with quotation marks, just try to convert

select 'hi' test from MYLINK...TABLE

to

select * from openquery, MYLINK, 'select 'hi' test from TABLE')

regards

arno

date: Thu, 17 Jan 2008 14:04:04 +0100   author:   arno nospam@invalid

RE: What is the purpose of the OPENQUERY syntax?   

try like this
select * from openquery, MYLINK, 'select ''hi'' test from TABLE') 

Ramesh M

"arno" wrote:

> Hello,
> 
> I am using linked servers over ODBC. Most queries fail, however, they work 
> when I use the OPENQUERY syntax. This appears to be a problem of at least 
> SQL server 2000 and 2005 express. Strange, but MS ACCESS databases work 
> perfectly with the ODBC-linked tables with "normal" sql-syntax.
> 
> I would like to know if there are other solutions than OPENQUERY as this 
> causes new problem eg. with quotation marks, just try to convert
> 
> select 'hi' test from MYLINK...TABLE
> 
> to
> 
> select * from openquery, MYLINK, 'select 'hi' test from TABLE')
> 
> regards
> 
> arno 
> 
> 
>

date: Fri, 7 Mar 2008 11:20:02 -0800   author:   DonRamesh