sqlwrite object already exists

6 次查看（过去 30 天）

Jakob B. Nielsen 2021-5-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/840210-sqlwrite-object-already-exists

评论： Jakob B. Nielsen 2021-5-26

Greetings excellent people!

(I am aware that a question already exists with roughly the same name, but it is several years old and does not seem to pertain to my problem).

I have run into the following error:

Error using database.odbc.connection/sqlwrite (line 144)

ODBC Error: ODBC Driver Error: ODBC Driver Error: [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'Declared_values' in the

database..

Now, the sqlwrite function documentation says that if a table already exists in the sql database, the function appends the data in the MATLAB table as rows in the existing database table. I am at a loss here! I would welcome any suggestions. I have checked spelling, capital/noncapital letters, conn.message returns [], and I can both find and edit the database in Microsoft SQL Server Manager, which means I have edit rights. If I run

test = sqlread(conn,tablename);

It gives me the proper data from the table. But

sqlwrite(conn,tablename,data);

returns the error above.

I would very much appreciate any insight you can give me in this regard!

2 个评论
显示无隐藏无

Geoff Hayes 2021-5-26

Jakob - without knowing exactly what this error message means, are you inserting/writing new data into the table or trying to update existing data. The error message suggest (to me) that you are attempting to write data that already exists within the table.

Jakob B. Nielsen 2021-5-26

Hi Geoff,

There is a table named 'Declared_values' in the database (it is the one referenced in the error message), into which I post monthly KPI figures. The data I want to put in should append to the existing table, and there is a date-time stamp included in the data so no two entries will ever be identical. So it should be an insert case, not a replace case.

It might be a helpful addition that the same identical code worked fine last a couple of months ago, but I recently got a new work PC. It is the same version of matlab, however, but in case this detail might help ring a bell for someone...

请先登录，再进行评论。

请先登录，再回答此问题。