I am using the Database Connectivity Toolset to access a large Oracle database via complex SQL commands provided to me by a DB developer. It appears that I must use the DB Tools Execute Query VI followed by Fetch Record Set to return these potentially large tables. A very simple test command does work: [select sysdate from dual;] so I know that my connection is ok. I can also successfully use the List Tables VI to return all available table names. However, when I execute an SQL command to read from a table [select count(*) from WO;] I get error -2147217865, saying that the table or view does not exist--but that table (WO) does appear in the array returned by List Tables. Other posts on this error point to connection problems or table name formatting problems, neither of which seem to apply to my situation. Ideas?
Does the user that you are using to connect with have the appropriate permissions on the tables?
I have found this error message quite useless, as it is usually an issue with the SQL statement rather than the labview code. Are you able to attempt to run your queries on the command line using the same user name to see that the query will in fact work?