SQL Excel

First, thank you for an EXCELLENT tool!

I have a database that I am connecting to that has seven schemas, each of which has over 2,000 tables and 99 views. When I connect to the database with SQLExcel, it takes quite a while to load all the objects from all the schemas, then I have to collapse all the schemas that I am not interested in to get to the one that I am.

Question: Is there any way to limit which schemas SqlExcel loads, either in the connection string or some parameter in SQLExcel? I desperately need this...

Thank you,
Jim

hi

Thanks for the kind words..

Sorry for the delay in replying.. Hope you managed to work around this issue..

On the addin side, there is no parameter or option to change (connection is built using the data links component and the addin just works with this connection object).

On the connection string side, there may be a way to limit the connection to a specific schema.. I know the same issue came up for someone here that had the same problem with DB2 and he managed to work around it I think by setting a default schema for the connection.

I am not sure if this same connection parameter exists with Oracle but will take a look at this over the weekend.
I found this article
http://forums.oracle.com/forums/thread.jspa?threadID=321982
which seems to suggest it is not possible but maybe there is a way to do this. need to look a bit more..

Please let me know which data provider you are using to connect.Sorry cant be more helpful there..

Also, I know this is a problem with the addin and will be working to get a fix in for this type of situation.. Just need to get some time to do the work.
have a nice evening
Al

Thank you for the quick response!

I understand the issues about getting time to get to the coding. If you need any help there, let me know.

Jim