connection to MySQL and Matlab 2010
1 view (last 30 days)
Show older comments
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
0 Comments
Accepted Answer
More Answers (2)
Oleg Komarov
on 20 Apr 2011
You have to set up you DSN first manually:
system('%SystemRoot%\system32\odbcad32.exe');
2 Comments
Walter Roberson
on 21 Apr 2011
Probably
conn = database ('jdbc:mysql://localhost:3306/pueba','root','root');
See Also
Categories
Find more on Database Toolbox in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!