This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets 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
 
Similar Threads
eclipse with sql server 2005
Exception during connecting to sql server2005
SQL Server - netbeans Connection problem
Wanted: Help using DBUnit with MS SQL Server: java.sql.SQLException: Invalid Fetch Size
JSP MSSQL - Connection Problem