Hi I am trying to insert the results of gurobi into Micrsoft Server Management Studio, but I am getting the following error:
Error using database/insert (line 177) Unable to write column to database. I have created a table named results with the following data types:
resultId int
x float
objVal float
cost float
Below is my code:
conn = database.ODBCConnection('MySQL','NCAT\aabhaler','');conn = database('STEERDB','NCAT\aabhaler','','Vendor','Microsoft SQL Server','Server','A0030110GB6S942','AuthType','Windows','portnumber',1433);colnames={'resultId', 'x', 'objVal', 'cost'};data = {1 ,result.x, result.objval ,2.2};data_table = cell2table(data,'VariableNames',colnames)tablename = '[dbo].[results]';datainsert(conn,tablename,colnames,data) insert(conn,tablename, colnames,data_table);curs=exec(conn,'select * from [dbo].[results]');curs=fetch(curs);disp(curs.Data);close(curs);close(conn);
result.x is [1766×1 double] and result.objval is 1.0162e+07.
Can you please help me out?
Best Answer