• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

connecting to MS SQLServer database from within netbeans

 
Arvind Mahendra
Ranch Hand
Posts: 1162
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic