ADO Error 0x80040E09

[Superwoman123]

I get the following error when trying to INSERT into a table TABLE.

ADO Error: 0x80040E09

Exception occured in Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC SQL Server Driver][SQL Server]INSERT permission denied on object 'TABLE', database 'DATABASE', owner 'dbo'. in NI_Database_API.lvlib:Rec Create - Command.vi->NI_Database_API.lvlib:Cmd Execute.vi->NI_Database_API.lvlib:DB Tools Insert Data.vi->tblCPTResults.vi

I have all the necessary permissions. In fact, on another computer windows XP previously created standalone application INSERTS into this table without a problem.

I am using Labview 2015 and SQL Database Connectivity toolkit on WIndows 7. When I dig thorugh the VI's I discover that I am getting this error at ADODB._recordset open method.

Any suggestions for a way around this error? Thank you.

[Davidvilla87]

Hi Superwoman123

I went through the web and I found this forum in another page. Let see if this helps.

https://lavag.org/topic/17723-ado-error-0x80040e09-or-2147217911-in-database-toolkits/