I have a JDBC adapter service which I want to use for Batch Insertion. However, the Table name list wont really populate correctly… it only shows general schema:s and other irrelevant data. Strangely, when I connect to the SQL server through the SQL management studio GUI, I can view and access the tables correctly.
Has anyone had this problem? A theory I had was that it could be the way the user, privileges and roles are set up… but this should be a problem when accessing through the management studio as well.
Any thoughts would be highly appreciated at this point.
Ps. We’re using SQL server 2008.
Thanks in advance,