6 Replies Latest reply: Jun 22, 2012 7:35 AM by 582007 RSS

    Simultaneous inserts in a foxpro database using Gateway for ODBC

    582007
      Hi.

      I'm configuring Oracle database Gateway for ODBC to access a foxpro database from my Oracle database (10.2.0.1) 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
      mensaje:
      [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.