Right
I’m just starting a HUGE project which has a SQL sever 2000 database at the back. So I configured up the SQL database and couldn’t see any tables…
The problem?
I needed to select the dbo schema not the name of the database. So your settings should be like this:-
Connection String: jdbc:sqlserver://192.168.100.11:1433;databaseName=(database name)
Schema (this is the important bit) : dbo
For some reason I mistook the Schema for the DATABASE NAME which in NB is a completely different thing.
I also tried the jtds driver and decided to use that - it’s open source and provides even faster connection.
Note that ODBC is old hat now and you should not use it as it’s really slow and probably ends up using the same sort of code you would use directly but with extra layers.
July 9, 2008 at 8:17 pm
Thank you so much. Ran into the same issue.. using jtds hitting a remote server… i would never have guessed to use dbo instead of my database name
July 12, 2008 at 7:37 am
No problems - took me a bit of time to find it.
By the way I would recommend that JTDS driver it’s so much better than the normal SQL one.