Error using database.odbc.connection/sqlwrite (line 218) ODBC JDBC/ODBC Error: ODBC Driver Error: .

Matlab database toolbox writting error

Guillaume 2018-5-15

You have not provided any context or code with your error. All we can tell you is that your ODBC driver is not happy for some reason. We're not clairvoyant so can't tell you why it's not happy without more information.

Alex Fernandez 2018-5-15

Sorry. I use Matlab2018 and MySQL ODBC driver v.8.0. I make succesfully the connection with conn function. Besides, I can read my data using sqlread function; no problem. But when I try to write my data, it prompts the error message

Greg 2018-5-16

Is your database or file system set to read-only?

Guillaume 2018-5-16

But when I try to write my data, it prompts the error message

Possibly, there's something wrong with the syntax of your write instruction. Possibly, as greg says, your database is read only. Possibly, you're trying to write in a non-existant table or column, ...

Again, without seeing what you're actually doing, there's no way we can tell.

Alex Fernandez 2018-5-27

编辑：Alex Fernandez 2018-5-27

在 MATLAB Online 中打开

 %%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 2018-5-27

编辑：Alex Fernandez 2018-5-27

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.

Matlab database toolbox writting error

6 个评论
显示 4更早的评论隐藏 4更早的评论

回答（0 个）

类别

标签

Community Treasure Hunt

Matlab database toolbox writting error

6 个评论 显示 4更早的评论 隐藏 4更早的评论

回答（0 个）

类别

标签

另请参阅

Community Treasure Hunt

6 个评论
显示 4更早的评论隐藏 4更早的评论