ADO error Syntax error or access violation 
Author Message
 ADO error Syntax error or access violation

Hi all

I have problem with update data in query.
When I try to issue the update command then getting error:
    X42000:-201:Syntax error or access violation

Details:
INFORMIX-Dynamic Server 9.20
OLE DB Version 2.50
ADO Version 2.70
Sysyem Windows 2000,  SP1
Compiler Visual C++, SP5

Opening a Database connection is fine, retrieving a recordset is fine,
running execute is fine too. Problem with .Update and .UpdateBatch
method. I tried many combination of cursor type and lock type
and always getting above error. In addition update on this same
data by .Execute method work good.

Thanks in advance
Stanley Haracz



Tue, 22 Jun 2004 17:49:18 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Access Error or Syntax Violation on ADO Recordsource

2. ADO + VB6 : Syntax error or access violation

3. Syntax error or access violation - ADO command object

4. Please Help ODBC Error Code = 37000 (Syntax error or access violation)

5. 37000 Syntax Error or Access Violation Error

6. error 37000 syntax error or access violation

7. data shaping error: syntax error or access violation

8. [ODBC SQL Server Driver]Syntax error or access violation

9. sp_setapprole [Microsoft][ODBC SQL Server Driver]Syntax error or access violation

10. stored procedure probs - Syntax error or access violation

11. 37000 Syntax error or access violation

12. SQL State 37000: Syntax Error or Access Violation


 
Powered by phpBB® Forum Software