Hello everybody !
I have the following situation:
I am using the DB Tools Open Connection.vi to get connected to a SQL Server 2008 R2 database and an ORACLE 10g database.
Specifically, I am using two DSN (one for each database) in which I declare a specific user name and a specific password.
(this user belongs necessarily to a specific schema in the database)
The connection runs OK (ie. no error reported).Next, I am using the DB Tools List Tables.vi to read the tables in each database. The bad news is that this vi returns all the tables in the database not only the tables of the schema where the user belongs.Next, I am trying to read the columns information of each table using the DB Tools List Columns.vi. Now, the bad news become even worse, because this vi returns the error "table or view does not exist" every time it tries to read a table that does not belong to the schema of the user !!! It seems that there is an inconsistency here.Either the DB Tools List Tables.vi should report only the tables that belong to the schema of the user, or the DB Tools List Columns.vi should be able to return info about all tables irrespectively of the schema of the user. Am I doing something wrong ? Every assistance is more that welcome !
