Matlab database toolbox writting error

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

댓글 수: 6

Guillaume
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
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
Greg 2018년 5월 16일
Is your database or file system set to read-only?
Guillaume
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
Alex Fernandez 2018년 5월 27일
편집: Alex Fernandez 2018년 5월 27일
%%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 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.

댓글을 달려면 로그인하십시오.

답변 (0개)

카테고리

도움말 센터File Exchange에서 Reporting and Database Access에 대해 자세히 알아보기

질문:

2018년 5월 15일

편집:

2018년 5월 27일

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by