Problem reading SQL Server from java

[wduty]

I am trying to query a simple test database in SQL Server from java/JDBC. However, when I attempt to read tables I created I get an "Invalid Object Name" exception. When I get the a DatabaseMetaData.getTables resultset I get only the system tables but not user tables. Thus it seems that JDBC is connecting but not giving me full access somehow.

Does anyone know why this would happen? This is the case not only with my test database but also with the Northwind (demo database) that comes with SQL Server.

The weird thing is that I can read user tables fine through asp/ADO but not java/JDBC.

Any help, comments, or suggestions greatly appreciated.

--Will Duty
wduty@radicalfringe.com

 

[foxdev]

I'm not a JDBC user, but it sounds like the default database for the username you are using to sign in with is not your test database.

Either set your test database as the default for that username, or (if you can in JDBC) explicitly change databases when establishing a connection.

Robert Bradley

http://www.foxdev.com/

 

[wduty]

Robert,

Precisely...

I wish I had posted earlier because your observation would have saved me a lot of wasted time going around in circles only to find I just had to change a drop-down option in the ODBC setup. Works now.

Thanks!

--Will Duty
wduty@radicalfringe.com

 

[foxdev]

Very happy to help.

Robert Bradley

http://www.foxdev.com/