Error accessing IBM DB2 database using SQL Server 2000

Error accessing IBM DB2 database using SQL Server 2000

Post by Ted Simo » Wed, 01 Oct 2003 17:00:48



Recently updated SQL Server from 7.0 to 2000.
Trying to run and application produces the following error.
SERVER Msg 7344, Level 16, State 1, Line 15
OLE DB provider "MSDASQL' could not INSERT INTO
table '[MVS2PRD]..[RESODB].[EMGT_CAMP]' because of
column 'EMGT_NODE_ID'. The user did not have permission to
write to the column.
The user in this case has DBA authority. And to further
verify it was not an authority error we granted the user
SYSADM.  
Any ideas as to what is the real problem?