6 Replies Latest reply on Jun 22, 2012 12:35 PM by 582007

    Simultaneous inserts in a foxpro database using Gateway for ODBC


      I'm configuring Oracle database Gateway for ODBC to access a foxpro database from my Oracle database ( in a Windows Xp.
      Both databases are in the same machine and I can execute select's correctly.

      But I cannot perform concurrent inserts, when I execute an insert in one session it blocks the entire table and no other insert
      can be executed from other session. Could it be possible?

      I have the parameter HS_TRANSACTION_MODEL= COMMIT_CONFIRM to activate the distributed updates but still obtain the error:

      insert into centros@fox1 values('11','2','3','4','5','6','7','8','9','10','11',12,13,'14','15','16','17','18')
      ERROR en lÝnea 1:
      ORA-28500: la conexi¾n de ORACLE a un sistema no Oracle ha devuelto este
      [Microsoft][ODBC Visual FoxPro Driver]File is in use by another user.
      {S1000,NativeErr = 702}
      ORA-02063: 2 lines precediendo a FOX1

      Thanks in advance.