Matlab database toolbox writting error

1 view (last 30 days)
Alex Fernandez
Alex Fernandez on 15 May 2018
Edited: Alex Fernandez on 27 May 2018
Error using database.odbc.connection/sqlwrite (line 218) ODBC JDBC/ODBC Error: ODBC Driver Error: .
  6 Comments
Alex Fernandez
Alex Fernandez on 27 May 2018
Edited: Alex Fernandez on 27 May 2018
%%Connection to database
>> conn = database(tablename,username,password);
>> conn.Message % ans = [] if successful connection
%%Read data
>> setdbprefs('DataReturnFormat','table');
>> data_estacion = sqlread(conn,table1);
>> data_trh = sqlread(conn,table2);
%%Writing data
>> data_result = table(data_1,data_2,data_3,'VariableNames'{'Name_1','Name_2','Name_3'});
>> sqlwrite(conn,table_result,data_result)
Alex Fernandez
Alex Fernandez on 27 May 2018
Edited: Alex Fernandez on 27 May 2018
I work with PHPMyAdmin database and ODBC Driver 8.0. The program stops before sqlwrite function. I don't know what to do. I would appreciate any kind of help. Thanks.

Sign in to comment.

Answers (0)

Categories

Find more on Reporting and Database Access 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!