MySQL + MATLAB -> Invalid connection

5 次查看(过去 30 天)
Greetings,
I'm trying to set up MySQL with MATLAB with no success. I downloaded EasyPHP 5.3.8.1 and I created a simple database named 'mydata'. I also enabled the php_pdo_odbc in PHP extensions. For the rest, I let the default settings. Finally, I put my file into the \www folder with the following content:
clear all;
conn = database('mydata','root','');
ping(conn)
and this error resulted :
??? Error using ==> database.ping at 153
Invalid connection.
Error in ==> myfile at 4
ping(conn)
I use MatlabR2010a on Windows 7, 64 bit and database toolbox version 3.7. I've tried different username such as 'root', 'localhost', '127.0.0.1' but no way to fix it. Your help is welcome.
Regards, Steven
  1 个评论
Kaustubha Govind
Kaustubha Govind 2011-10-12
Check conn.Message and see if you are getting any useful error message.

请先登录,再进行评论。

采纳的回答

Steven
Steven 2011-10-12
Hi folks,
I finally fixed the prob !
First, I downloaded MySQL ODBC driver 5.1. Then, I add it in Start > Settings > Control Panel > Administrative Tools > Data Sources(ODBC)
and everything works well !
Steven

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Database Toolbox 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by