| Author |
Message |
|
2007/03/28 07:42
|
|
|
Quinten
Joined: 2007/03/28
Messages: 6
Offline
|
|
|
|
Howdy
Sorry to post on this topic, seem that a few people already have. I have read through their posts, to no avail.
I have tried many combinations of authentication and databases, even changed the sa password to something so simple I couldn't misspell it.
I have attached a screen shot of my connection properties.
I can connect using other (MS) programs (Visio, Visual Studio)
The error I'm getting is:
Test adapter connection failed!
java.sql.SQLException: Network error IOException: Connection refused: connect
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:372)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)
at org.orm.ertodb.DriverWrapper.connect(DriverWrapper.java:27)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at v.igvh.i(:34)
at v.igvh.f(:43)
at v.ame.run(:21)
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:289)
at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:250)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:297)
... 8 more
Test .NET connection failed!
java.lang.Exception: SQL Server does not exist or access denied.
at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at NHibernate.Connection.DriverConnectionProvider.GetConnection()
|
Attached Image :
Description : DB Connection properties for Visual Paradigm
(9 kb)
Attached Image :
Description : DB Connection properties for Visual Studio
(10 kb)
|
|
|
|
 |
| |
|
|
2007/03/28 08:57
|
|
|
Jick
Joined: 2005/04/29
Messages: 2880
Offline
|
|
|
|
Hello Quinten,
Thank you for your post. I think that you haven't enable to SQL Serer to accept connection from external application (maybe some TCP/IP or firewall settings). Please try to enable those settings in your server and see if it help. Thanks in advance!
Best regards,
Jick
|
Visual Paradigm International Ltd.
http://www.visual-paradigm.com
Build Quality Applications Faster, Better and Cheaper |
|
|
|
|
| |
|
|
2007/03/29 11:48
|
|
|
Quinten
Joined: 2007/03/28
Messages: 6
Offline
|
|
|
|
Firstly, thanks for the speedy reply.
Secondly, thanks for such a great product (just need to save up for the suite)
For the life of me I couldn't get SQL Server 2000 to work (normally I would use MySQL)
In the end I installed SQL 2005 Express, changed the settings to allow external connections and all was good.
Thanks for your help
|
|
|
|
|
| |
|
|
2007/03/29 11:51
|
|
|
Jick
Joined: 2005/04/29
Messages: 2880
Offline
|
|
|
|
Hello Quinten,
You are welcome. Feel free to post again if there are any questions.
Best regards,
Jick
|
Visual Paradigm International Ltd.
http://www.visual-paradigm.com
Build Quality Applications Faster, Better and Cheaper |
|
|
|
|
| |
