problems using jTDS driver

Hi everyone...

i m using netbeans 5.5 and i also have mssql 2005 installed.

To connect to my MSSQL database i m using jTDS driver, but when i try to connect i get the following exception:

Unable to add connection, cannot establish connection to

jdbc:jtds:sqlserver://myServerName:1177/myDatabaseName using net.sourceforge.jtds.jdbc.Driver(Network error IOException:Connection refused:connect)

My connection string:

jdbc:jtds:sqlserver://myServerName:1177/myDatabaseName

P.S.

I tried to use port 1433 and no port at all....so i dont know where is the catch...so if someone can please help me that would be great....thnx in advance!

[685 byte] By [Samuraya] at [2007-11-26 15:08:40]

«« The "paint" and "draw " method
»» Socket write error

# 1

Firewall? Can you telnet that port?

CeciNEstPasUnProgrammeura at 2007-7-8 8:59:06 >

top of Java-index,Java Essentials,New To Java...

# 2

Well actually the problem was with me...the URL i was passing to application was something like:

jdbc:jtds:sqlserver://myServerName:1433/myDatabaseName (this url didnt work)

But the following url:

jdbc:jtds:sqlserver://myServerName:1433/myDatabaseName;instance=myInstanceName

Works great...and well i also added the following exceptions in my firewall:

[...]\MSSQL\BINN\sqlservr.exe

And ports:

- 1433 as TCP port

- 1434 as UDP port

And it works....I oppologise again for posting...but i was really stuck!

Thnx again for all the help!

Samuraya at 2007-7-8 8:59:06 >

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

problems using jTDS driver

Java Essentials New Topic

Java Essentials Hot Topic

Java Essentials

All Classified