ODBC Error Message

[rbyrne1]

I am using VB.2005 to access a Pervasive SQL 9.5 database and I'm getting the following error:


ERROR [42S02] [Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface][Data Record Manager]No such table or object.
ERROR [HY000] [Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]Unable to open table: ITEM.


My SQL statement is as follows:

SELECT ITMDESCR.Description1, ITMDESCR.Description2, item.vendorsitemnum,ITEM.Description, VENDOR.Name
FROM {oj (ITEM INNER JOIN VENDOR ON ITEM.VendorNum=VENDOR.VendorNum) LEFT OUTER JOIN ITMDESCR ON ITEM.ItemNum=ITMDESCR.ItemNum}


This SQL statement runs fine when I run it on the Pervasive Control Center. Any ideas???

 

[rbyrne1]

UH - NEVERMIND!!!

Silly me. I was connecting to the wrong database

Sure wish you could retract posts.