Matlab Mysql remote connection fails

1 view (last 30 days)
Hi , I am using JDBC connector to connect to my remote mysql database. I have done the following : db_conn = database('db_name','db_user','password', ... 'com.mysql.jdbc.Driver', ... 'jdbc:mysql://MY_REMOTE_IP:3306/db_name') and then this returns the following : db_conn =
Instance: 'db_name'
UserName: 'db_user'
Driver: []
URL: []
Constructor: [1x1 com.mathworks.toolbox.database.databaseConnect]
Message: [1x97 char]
Handle: 0
TimeOut: []
AutoCommit: 'off'
Type: 'Database Object'
and if I check the connection using : isconnection(db_conn) it will return 0 ...
Any idea ?

Accepted Answer

Titus Edelhofer
Titus Edelhofer on 28 Nov 2011
Hi,
take a look at
db_conn.Message
what does it say?
Titus
  2 Comments
Mortada
Mortada on 28 Nov 2011
Thank you so much, I mistyped the /db_name and db_conn.Message made me aware of it :-)
This is solved.

Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!