Error running datainsert to insert row in sqlserver database

Question

Basem Nabil 2019-5-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/461664-error-running-datainsert-to-insert-row-in-sqlserver-database

回答： Piyush Kumar 2024-7-26

在 MATLAB Online 中打开

Hello,

I'm trying to insert a row into my sql server database using datainsert but I keep getting errors everytime I run.

I know my connection is correct as it works in fetching data.

conn = database('SqlServer','','');
data = {1 'Deposit' 500};
columns = {'CardID' 'Type' 'Amount'};
table = 'HakunaMatata.dbo.Transcations';
datainsert(conn,table,columns ,data);
close(conn);

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Piyush Kumar 2024-7-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/461664-error-running-datainsert-to-insert-row-in-sqlserver-database#answer_1490936

Hi @Basem Nabil,

The error you’re encountering with the datainsert function in MATLAB when inserting a row into a SQL Server database might be related to transaction handling.

Here are some steps to troubleshoot and resolve the issue:

Check Transaction Statements: Ensure that your code includes proper BEGIN TRANSACTION and COMMIT TRANSACTION statements. The error indicates a ROLLBACK without a corresponding BEGIN.
Try sqlwrite function instead of datainsert
Verify Data Types: Ensure that the data types of the columns in your MATLAB table match those in the SQL Server table.
Check this link - ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION error in sql server - Stack Overflow. The error statement is similar here.