aspose file tools*
The moose likes IDEs, Version Control and other tools and the fly likes connecting to MS SQLServer database from within netbeans Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Engineering » IDEs, Version Control and other tools
Bookmark "connecting to MS SQLServer database from within netbeans" Watch "connecting to MS SQLServer database from within netbeans" New topic
Author

connecting to MS SQLServer database from within netbeans

Arvind Mahendra
Ranch Hand

Joined: Jul 14, 2007
Posts: 1162
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 ]

I want to be like marc
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: connecting to MS SQLServer database from within netbeans