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 86335 - Problems connecting to database using Microsoft jdbc driver
Summary: Problems connecting to database using Microsoft jdbc driver
Status: RESOLVED INVALID
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 5.x
Hardware: PC Windows XP
: P3 blocker (vote)
Assignee: Andrei Badea
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-10-02 20:51 UTC by kwon
Modified: 2007-01-04 17:03 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description kwon 2006-10-02 20:51:30 UTC
Hi,
i have some problem using SQL server 2005 JDBC Driver 1.1.
The problem is, when i try to use it in NetBeans 5.0 runtime manager connecting
to database.
I installed mentioned driver and its listend in "Drivers" file as for example
jTDS driver, but when i try to enter Databse URL i constantly get errors.

If for example i enter "jdbc:sqlserver://localhost:1433/myDatabase" as Databse
URL i get an error that the port is not valid.

If i insert Database URL: "jdbc:sqlserver://mypcname\\sqlexpress/myDatabase" i
get an java.net.SocketTimeoutException (mypcname\sqlexpress is an instance of my
sqlexpress server).

The interesting thing is that if i try to connect to my database using code...or
testing the connection with a simple program i can connect easily and execute
queries with no special dificulties...

Basically i dont know where the problem is...maybe i m entering wrong Database
URL but i dont know...cos database URL is almost the same as it is in jTDS
driver wich works great...

Well thats about it.

thnx everyone for the help.
Comment 1 Andrei Badea 2007-01-04 17:03:26 UTC
The database URL syntax for the MS driver is different from the one of the jTDS
driver. I could connect to a server using the following:

jdbc:sqlserver://server:1433;databaseName=tempdb