MySQL + MATLAB -> Invalid connection

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

[Kaustubha Govind]

Check conn.Message and see if you are getting any useful error message.

Answer 1

[Steven]

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