connection to MySQL and Matlab 2010

hi i am trying to connect my MySQL database with matlab 2010th but I get the following error

[Microsoft] [ODBC Driver Manager] "Please verify login information and database That Are valid url."

the code I'm using is

conn=database('prueba','root','root'); 
if (~isconnection(conn))
str=conn.Message
h=errordlg(str,'Error','modal' );
while ishandle(h)
pause(.25)
end
error(str)
end
set(handles.Res_Des_Cas,'String',query);

prueba is my database root is my user y password

I already I have installed the MySQL ODBC 5.1 and when I use the QueryBuilder can import and export data from the database, but when I use a file .m can not

Answer 1

[Luis Osorio]

thank you very much but this did not work, somebody knows the code that I put in the file .m for connection

Answer 2

[Oleg Komarov]

You have to set up you DSN first manually:

system('%SystemRoot%\system32\odbcad32.exe');

[Luis Osorio]

thank you very much for your help, but I already set the user DNS so

Data Source Name: myqslLocal

TCP/IP Server: localhost port: 3306

user: root

password: root

Database: prueba

When I press test says connection successful. I try QueryBuilder connecting and it worked.

But I'm not sure how is the connection code that I put in matlab, or should I configure something first in matlab.

try these 2 forms and not work.

conn=database('prueba','root','root');

conn = database ('jdbc:mysql://localhost/pueba','root','root');

[Walter Roberson]

Probably

conn = database ('jdbc:mysql://localhost:3306/pueba','root','root');

Answer 3

[Luis Osorio]

thank you very much but this did not work, somebody knows the code that I put in the file .m for connection

[Luis Osorio]

thanks the code works, the code was as follows

conn = database('mysqlLocal','root','root');

if (~isconnection(conn))

str=conn.Message

h=errordlg(str,'Error','modal' );

while ishandle(h)

pause(.25)

end

error(str)

end

mysqlLocal is the name that I put to configure MySQL ODBC

I thought that was the name of the database:)