OPENQUERY

[Packermann]

Why is that I can only get the OPENQUERY to work on the master database?<br><br>SELECT *<br>FROM OPENQUERY(CHINIKU01, 'SELECT resource_id, last_name * FROM LARRY.nitc_cons_workerbee') <br><br><br>On a database other than the master, I get the error message:<br><br>&quot;'CHINIKU01' is not a recognized OPTIMIZER LOCK HINTS option.&quot;

 

[foxdev]

Have you already setup CHINIKU01 as a linked server using sp_addlinkedserver ? <p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br>

 

[Packermann]

Yes, I already used sp_addlinkedserver and sp_addsrvrlogin.<br><br>But, I think I solved the problem. I colleague of mine told me that OpenQuery only works on a true 7.0 database. Our database is 7.0 with 6.5 emulation. Since it has 6.5 emulation it does not recognize the OpenQuery statement. Since the master database does not have 6.5 emulation, it is a true 7.0 and does recognize this function.<br><br>Thanks, anyway.