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

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
>
>
>