In NetBeans.
So I have the driver setup in the runtime tab. But unfortunately I cannot connect using it.
In the "New Database connections" dialog box where you fill in the details you want to connect with I have the following:
name: SQlServer 2005
Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
database url :
jdbc:sqlserver://localhost:1433/pubs
username: sa
password: .
The error I get shown when I click on OK is:
"unable to add connection,cannot establish a connection to the jdbc:sqlserver://localhost:1433/pubs using com.microsoft.sqlserver.jdbc.SQLServerDriver (the port number 1433/pubs is not valid.)"
Note:I can connect from code using the above specs.
[ December 07, 2007: Message edited by: Chunnard Singh II ]