Help plzzz

[chinnu]

Hi...I am using windows 7 home premium 64-bit....installed oracle10g express edition in it. Whenever i am trying to run a java program with the driver sun.jdbc.odbc.JdbcOdbcDriver... the error which is being displayed is.....java.sql.SQLException: connection not open....

Can anyone help me out with this......Its a bit ugent..need to complete my project....

 

[Orbital Shark]

Hi chinnu, welcome to the forums

I found this on another site

Why do I get java.sql.SQLException: "Network error IOException: Connection refused: connect" when trying to get a connection?

The "Connection refused" exception is thrown by jTDS when it is unable to connect to the server. There may be a number of reasons why this could happen:

The server name is misspelled or the port number is incorrect.
SQL Server is not configured to use TCP/IP. Either enable TCP/IP from SQL Server's Network Utility app or have jTDS connect via named pipes (see the URL format for information on how to do this).
There is a firewall blocking port 1433 on the server.
To check whether TCP/IP is enabled and the port is not blocked you can use "telnet <server_host> 1433". Until telnet doesn't connect, jTDS won't either. If you can't figure out why, ask your network administrator for help.

Source = jTDS JDBC Driver

I'll be honest i'm no Java expert but something here may help you.


OS