Restarting FoxWeb would also re-load any DLLs you were using, including the Oracle ODBC driver. This may have solved your problem.
The only difference between running FoxWeb as a service or as a desktop application is that services are typically not visible on your display. Also, the default user that the FoxWeb service runs under is System. This will not work for accessing resources on remote computers (e.g. your Oracle server), so you need to specify a different user for the service. If the problem is intermittent, then it's not caused by running FoxWeb as a service.
Sent by jipi on 11/25/2005 09:16:56 AM:
I reconsider my first point, on blank record.
We have finally solved our problem by restarting Foxweb.
So The problem seems to come from Foxweb.
Does the problem is coming from the fact, that Foxweb is executed as a service ?
We had previously add in fw_exit, the following lines, making sure, that all connexion are closed at the end of all programs :
set proc to
Do we do something bad ? Any Idea ?
Sent by jipi on 11/24/2005 01:26:00 AM:
Ok, Thank. I Will ook in this direction and hope find a solution.
But how do you explain that, all requests send to Oracle through ODBC are executed very slowly (12 or 13 seconds to select 100 lines from a table of 90000 lines) ? Is the problem coming from Oracle driver ? Is there a problem in the communication between VFP6 and Oracle ?
The same selection on Microsoft Access (via ODBC) is executed more rapidly (very more).
Sent by FoxWeb Support on 11/23/2005 08:04:22 PM:
This looks like a problem with the Oracle driver, the server, or the network connection between the FoxWeb server and the Oracle server. The fact that the problem is intermittent may make it hard to diagnose. I recommend that you post your question in a discussion forum that specializes in Oracle connectivity issues.
Sent by jipi on 11/21/2005 10:18:12 AM:
I am using Foxweb 3, and we have an urgent problem, very strange :
We use to select data from an Oracle Server, passing trough Microsoft ODBC for Oracle Driver.
Usually, it works very fine. But Sometimes, I get an cursor filled with empty data.
For example, we select 4 lines from a table in the database. The same request will work very fine a long time, and sometimes, I really have 4 lines in my cursor, but the last line is filled with empty data, or sometimes the 2 last lines are empty.
Can anybody help me please ? It very urgent !
Thanks a lot for help.