using sqlwrite to attempt insertion of matlab table into sql server table. odbc error involving uniqueidentifier columns.

5 次查看（过去 30 天）

STEVEN SATTERFIELD 2022-9-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1809345-using-sqlwrite-to-attempt-insertion-of-matlab-table-into-sql-server-table-odbc-error-involving-uniq

评论： Dave Chandler 2022-12-7

I have tables in a sql server database with uniqueidentier datatypes for the primary and foreign keys. I am populating matlab tables with data that includes a string representation of the uniqueidentifier values for the primary and foreign keys already populated.

When I call sqlwrite(conn,tablename,data,'ColumnType',coltypes) I get an odbc error on row 1 column 1 which is the string representation of the uniqueidentifier for the primary key.

In my coltypes array, I've tried uniqueidentifier, char, and varchar(37) as data types for this column, but same results every time.

Please advise.

Steve Satterfield

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Dave Chandler 2022-12-7

The problem may be in how you are initializing the uniqueidentifier. Please look at this uniqueidentifier documentation (mainly the two bullets under "Remarks") to see if this points to an initialization issue.

请先登录，再进行评论。

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