This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 149488 - No any info message about necessary fields for MS SQL Server
Summary: No any info message about necessary fields for MS SQL Server
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: Jiri Rechtacek
URL:
Keywords: UI
: 149486 (view as bug list)
Depends on:
Blocks: 152580
  Show dependency tree
 
Reported: 2008-10-08 12:03 UTC by Roman Mostyka
Modified: 2011-11-30 18:14 UTC (History)
0 users

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:


Attachments
Screenshot of error message for MS SQL Server. (16.30 KB, image/jpeg)
2008-10-13 15:10 UTC, Roman Mostyka
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Roman Mostyka 2008-10-08 12:03:13 UTC
1. Add MS SQL Server driver, rightclick "Databases" node and choose "New Connection...".
2. Choose MS SQL driver.

Result: There is no any info message about necessary fields.
Comment 1 David Vancouvering 2008-10-09 18:42:28 UTC
Maybe it's because there are no fields that are required, have you thought about that, huh? :)

Here's the URL template

jdbc:sqlserver://[<HOST>[\\<INSTANCE>][:<PORT>]][;databaseName=<DB>][;<ADDITIONAL>]"

Note that everything is optional, and has well-known defaults.  If you want to test this, that would be great, but
that's what the documentation said when I read it.
Comment 2 Roman Mostyka 2008-10-13 09:31:49 UTC
But without any values I've got error message that says that IDE unable to connect to jdbc:sqlserver:// and no default
values. At least in message. If in reality driver tries to connect to MS SQL Server with default values, it should be
reflected in error message. Correct me if I'm wrong.
Comment 3 Roman Mostyka 2008-10-13 15:10:00 UTC
Created attachment 71671 [details]
Screenshot of error message for MS SQL Server.
Comment 4 Jiri Rechtacek 2009-02-10 15:37:59 UTC
Reassigned to new owner.
Comment 5 Jiri Rechtacek 2009-10-23 12:16:53 UTC
*** Issue 149486 has been marked as a duplicate of this issue. ***
Comment 6 matthias42 2011-11-30 18:14:07 UTC
This is the current message: 

cannot establish a connection to jdbc:sqlserver:// using com.microsoft.sqlserver.jdbc.SQLServerDriver (Fehler beim Herstellen der TCP/IP-Verbindung mit dem Host 'localhost', Port 1433. Fehler: 'Connection refused. Überprüfen Sie die Verbindungseigenschaften, und stellen Sie sicher, dass eine SQL Server-Instanz auf dem Host ausgeführt wird, die TCP/IP-Verbindungen am Port annimmt. Überprüfen Sie außerdem, dass die TCP-Verbindungen mit dem Port nicht von einer Firewall blockiert werden.'.)

The assumed host, port and a error-solution is presented (using sqlserver driver version 3.0).

I consider this good enough. Current problem: The error message is only partitally visible, but that is a seperate bug.