Weird ODBC Connection Issues

[Mighty]

We have just upgraded from Btrieve 6.15 to Pervasive 2000. I have been accessing the data from the web using ASP and the Pervasive ODBC connection. Everything has been working fine the last two evening when I have left work. However, yesterday morning and this morning when I have come in, I am getting the following error:


Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Pervasive][ODBC Engine Interface][Data Record Manager]The session is no longer valid(Btrieve Error 95)

/aProfile.asp, line 582


Can anyone shed some light on this for me. Yesterday, it just started working again for no apparent reason. No such luck yet today. All help and advice would be appreciated. Mise Le Meas,

Mighty

 

[TomKane]

One solution might be to open and close your connections more regularly - perhaps there was a network problem and it broke the connection between your app and the server.

(I'm assuming that you open your connection and leave it open for the duration of the program's run)

 

[Guest_imported]

Mighty: I posted a reply to this yesterday, and don't see it, so I'll try again. I work for the Pervasive engineering department and we have a new feature in Pervasive.SQL 2000i (SP3) that will help you. Its called Pervasive Auto-Reconnect or PARC. When sessions are dropped we will attempt to reconnect them for a configurable amount of time. If you are running SP3 then you can configure this feature on your client and on your server using the configurator in the Pervasive Control Center (you must configure both sides). It is not configured by default because there is a small performance hit to use PARC. This is expected as we have to do some extra acknowledgements when we send packets across the wire to make sure they were received. But for many people the realibility is more important than the small performance hit.
A status 95 happens when the network drops your connection. It can be a blip on the server, client, or anywhere on your network. Without PARC there is really not anything you can do to avoid the 95s as they are not controlled by Pervasive, but come from the network.
Debie