SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
03-09-2008, 01:37 PM
| ||||
| ||||
 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 > > >      |
Linear Mode
