- I Created a test table "TestODBC" it has one user column "Name"
Code: Select all
SELECT * FROM [SFCxp]...[TestODBC__c]
Code: Select all
UPDATE [SFCxp]...[TestODBC__c] SET Name = 'Update Test'
Problem is, when i try to insert a row
Code: Select all
INSERT INTO [SFCxp]...[TestODBC__c] (Name) VALUES ('TEST')
OLE DB provider "MSDASQL" for linked server "SFCxp" returned message "[Devart][ODBC][Salesforce]Access violation at address 000000000063AE07 in module 'DevartODBCSalesforce.dll'. Write of address 00000000000000BA".
Msg 7343, Level 16, State 2, Line 4
The OLE DB provider "MSDASQL" for linked server "SFCxp" could not INSERT INTO table "[SFCxp]...[TestODBC__c]".
Inserting thru MSAccess works, with the same DSN
Anyone knows the secret of inserting a row in a salesforce table ?