If I run a select it works. However the insert fails with
ERROR = An unknown or internal error has occurred.
connDb = "Provider=SLXOLEDB.1 assword=\"altja\"ersist Security Info=True;User ID=altja;Initial Catalog=SALESLOGIX_SANDBOX_JOE;Data Source=us3grrp576a;Extended Properties=\"Port=1706;Log=On;\"";
INSERT INTO [SalesLogix_SandBox_Joe].[sysdba].[HISTORY]([HISTORYID],[TYPE],[ACCOUNTID],[OPPORTUNITYID],[ACCOUNTNAME],[STARTDATE],[DURATION],[DESCRIPTION],[TIMELESS],[USERID],[USERNAME],[ORIGINALDATE],[CREATEDATE],[CREATEUSER],[MODIFYDATE],[MODIFYUSER],[COMPLETEDDATE],[COMPLETEDUSER],[NOTES],[LONGNOTES])VALUES('HAAAAA000010','262148','AAAAAA000000','OAAAAA000002','**Alt Landscaping',dateadd(hh, 5, getdate()),'0','Update From IPS','T','ADMIN','Administrator',dateadd(hh, 5, getdate()),dateadd(hh, 5, getdate()),'ADMIN',dateadd(hh, 5, getdate()),'ADMIN',dateadd(hh, 5, getdate()),'ADMIN','Update From IPS','Update From IPS') |