We are using VFP6 SP4.
We have a VFP6 web based application running with West-Wind web connect. The application has been running great for years now.
We just added a module to our application to access data in an Oracle database. This also works great.
The problem we have is that after a period of inactivity, we seem to lose our Oracle connection.
The way we normally get our connection to the Oracle tables is by issuing the following in our startup.prg:
***
Public gnconn
gnconn = SQLCONNECT('mydatasource', 'userid', 'password')
***
This works fine, except that we seem to lose the connection to the Oracle tables after some period of inactivity.
I have a routine to re-establish the SQLCONNECT(), but is it normal to lose your connection to Oracle after a period of inactivity?
How can we ensure that we have a valid connection to Oracle at all times? We normally issue SQLCONNECT once at startup. I would like to avoid issuing an SQLCONNECT() with every request(unless that is standard practice).
Or is this an issue to discuss with our Oracle DBAs? Could there be a timeout on our userid and password into Oracle?
Thanks,
Jerryt
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only