connecting to a MS Dynamics NAV database via jdbc

(0) Share

Report

Posted on by Community Member

hi,

i am trying to connect to a database that MS Dynamics NAV uses via jdbc. i followed the advice Jonathan gave me yesterday but i am getting an error when i run my code. i will paste the error at the bottom of this question. if i ping the host computers, it replies exectly the way it is supposed to.

also i was thinking first to bring the database to MySQL Workbench 5.2 CE so that i can see its structure. please assist me with steps and configurations that are necessary to complete this.

this is the error that i got when i run my code in netbeans.

com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.ConnectException
MESSAGE: Connection refused: connect

STACKTRACE:

java.net.ConnectException: Connection refused: connect
   at java.net.DualStackPlainSocketImpl.connect0(Native Method)
   at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
   at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
   at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
   at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
   at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
   at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
   at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
   at java.net.Socket.connect(Socket.java:579)
   at java.net.Socket.connect(Socket.java:528)
   at java.net.Socket.<init>(Socket.java:425)
   at java.net.Socket.<init>(Socket.java:241)
   at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)
   at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:271)
   at com.mysql.jdbc.Connection.createNewIO(Connection.java:2771)
   at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
   at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
   at java.sql.DriverManager.getConnection(DriverManager.java:571)
   at java.sql.DriverManager.getConnection(DriverManager.java:215)
   at testConnection.main(testConnection.java:44)

** END NESTED EXCEPTION **

Last packet sent to the server was 3 ms ago.
BUILD SUCCESSFUL (total time: 5 seconds)

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (3)

Verified answer

keoma 32,729 on at

Like (1)

Report

hi,

what credentials do you use? that user (in the connectionstring) needs at least the sql right datareader for the target database.

for building the jdbc connectionstring follow:

http://msdn.microsoft.com/en-us/library/ms378428(v=sql.105).aspx

http://msdn.microsoft.com/en-us/library/ms378956(v=sql.105).aspx

if you are looking for a free sql management tool for sql server follow:

http://www.heidisql.com/

http://www.sqlmanager.net/en/products/mssql/manager

also have a look at:

http://www.microsoft.com/en-US/download/details.aspx?id=7593

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

hi Jonathan,

this is how i created my connection.

Class.forName("com.mysql.jdbc.Driver");

con=DriverManager.getConnection("jdbc:mysql://10.0.0.19:7048/ databasename", "username", "password");

System.out.println("connection successfull.");

con.close();

when connection is successful, the program should print "connection successful".

Was this reply helpful? Yes No
Suggested answer

keoma 32,729 on at

Like (1)

Report

did you check the sql rights for username in the sql server database?

you are using the jdbc driver for mysql. that will not work with the sql server.

you should write following:

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

con=DriverManager.getConnection("jdbc:sqlserver://10.0.0.19:1433;databaseName=Cronus;username=xxx;password=yyy");

Was this reply helpful? Yes No
Suggested answer

Tharanga Chandrasekara 23,118 on at

Like (1)

Report

Did you try to login to DB with the provided credentials? Try that and see, if you have the proper access to the DB and then try to view data.

If you do not have the access then you need to give proper access rights.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

i have access to the database through NAV classic. do i use the credentials that i use to post to the database through Navision to login to the database?

Was this reply helpful? Yes No
Verified answer

keoma 32,729 on at

Like (1)

Report

yes, you can use them.

Was this reply helpful? Yes No
Verified answer

Tharanga Chandrasekara 23,118 on at

Like (1)

Report

Yes. Those are the same credentials that you should use to log to NAV database.

In classic version you can have two type of credentials.

1. Database logins

2. Windows logins.

And it is a must to have these logins created in the SQL and mapped with NAV database.

Since you have access to the NAV db that means those logins are been created and mapped to NAV and you can use them as your credentials to access the DB.

Was this reply helpful? Yes No