Using SQL Server 2000 with Netbeans 6.1 (can’t see any tables)
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…
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.