Connecting to MySQL database

2 次查看（过去 30 天）
vish
vish 2011-2-2
I am trying to connect to a MySQL database using the Database Toolbox in matlab but I am getting some errors connecting. Please let me know if I have to connect any MySQL connectors.
Database name: ec09249
conn = database ('jdbc:mysql://localhost/ec09249','root','');
curs = exec(conn,'select *from dtm');
curs=fetch(curs);
OUTPUT:
conn =
Instance: 'jdbc:mysql://localhost/ec09249'
UserName: 'root'
Driver: []
URL: []
Constructor: [1x1 com.mathworks.toolbox.database.databaseConnect]
Message: '[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Please verify that login information and database url are valid.'
Handle: 0
TimeOut: []
AutoCommit: 'off'
Type: 'Database Object'
EDIT: I also tried by loading the MySQL drivers but it vain. conn = database ('ec09249','root','','com.mysql.jdbc.Driver','jdbc:mysql://localhost:3306/ec09249')
  1 个评论
Martijn
Martijn 2011-2-2
The first syntax you used was definitely not correct. The second attempt looks better but which exact error messages do you receive with the second syntax which you tried?

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

the cyclist
the cyclist 2011-2-2
It has been forever since I set up my database toolbox, so I honestly don't remember all the details. But I have a couple differences from you.
Your second attempt, where you specify the driver, is closer to my syntax. I am pretty sure you do not want to specify the database name again in the driver string, though, because MATLAB is going to append that. You should end that string with the slash just after the port number.
The only other thing I have in my setup that looks different from what you are doing is a specification of the path to my JAR, before the database command:
javaaddpath('{path to Java archive file}/postgresql-8.3-604.jdbc3.jar')
  1 个评论
vish
vish 2011-2-3
Thank you for the answer. I was missing the javaaddpath. Btw. I have to specify the database name in database URL in order to connect to the database. Thank you.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by