ms sql server jdbc driver in netbeans returning empty schemas
Guys,
I'm currently running Netbeans 5 and I'm trying to connect to a ms sql server with the jdbc driver V. 1.0.809.102
2 things are not working right.
1. when I put the user name and the passworrd in the connection screen the ide is not able to connect to the sql server. However, when I put the user name and password in the database url, like so:"jdbc:sqlserver://MYMSSQLSERVER;databaseName=DESIRED_DATABASE;user=THE_USER; password=THE_PASSWORD", I am able to connect to the database and run queries agains it. Obviously the ide is building the incorrect connection string.
2. Once I am connected to the database the server does not return any schemas, views, tables and / or procedures.
Have you guys got any ideas or workarounds? I am trying to make cmp entity beans from the table in the database but I am not able because of the missing schemas.
Any help is truly appreciated.
Thanks
Billy
