Querying on a linked server 1

[Packermann]

I have two queries:<br><br>1. SELECT *<br>FROM OPENQUERY(CHINIKU01, 'SELECT * FROM nitc_lookup_values') <br><br>2. SELECT *<br>FROM CHINIKU01...nitc_lookup_values<br><br>#1 works fine. But I need to use #2, and #2 used to<br>work on Friday, but now I get the error message:<br><br>&quot;OLE DB provider 'MSDAORA' does not contain table 'nitc_lookup_values'.&quot;<br><br>What can I do to make MSDAORA recognize this table as it does in #1?<br><br>

 

[foxdev]

Just a WAG: could it be that you are not in the appropriate database?&nbsp;&nbsp;The ODBC DSN may have been changed, or the user's default database may have been changed, so that the expected database is no longer the one actually being initially set. <p>Robert Bradley<br><a href=mailto: > </a><br><a href=

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

- Visual FoxPro Development</a><br>