cant connect to sql server 2000 in java with netbeans IDE

Question

0.00/5 (No votes)

See more:

SQL-server-2000

hi I want to connect to sqlserver 2000
I Use Netbean IDE .
I add msbase.jar,mssqlserver.jar,msutil.jar to driver
when I want to add Connection

JDBC URL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Northwind;"

but it doesn't connect .The error is : "Error establishing socket"
I check in server network utility , TCP/IP is in Enable protocols list ,and the port number is 1433
I turn off the windows firewall
but still now I have this error

I also use jdbc.jar and it connects to sql server 2008 . but it can't connect to sql server 2000 with jdbc either.
what could I do?

error is :
"com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect"

Posted 8-Jan-12 22:01pm

Mahnoosh_M

Updated 9-Jan-12 20:42pm

v10

Add a Solution

Comments

Richard MacCutchan 9-Jan-12 6:02am

Are you saying that you have SQL Server 2000 and SQL Server 2008 both running on your local system, and using the same port number?

Mahnoosh_M 9-Jan-12 6:03am

in the same system ,, but not same port number
sql server 2000 port number is 1433
and sql 2008 port number is 1037

2 solutions

Solution 1

The connection string for SQL Server 2000 should be something like:

jdbc:microsoft:sqlserver://localhost:1433;user=mahnoosh;password=wibbleHatStand

You can't use the DatabaseName attribute as far as I know.

Posted 9-Jan-12 1:11am

Nagy Vilmos

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mahnoosh_M · Accepted Answer · 2012-01-11T18:49:00

Solution 2

Thanks all
I use "sun.jdbc.odbc.JdbcOdbcDriver"
and it works

Posted 11-Jan-12 18:49pm

Mahnoosh_M