View Single Post
  #1 (permalink)  
Old 02-15-10, 05:49
Keereweer Keereweer is offline
Registered User
 
Join Date: Mar 2008
Posts: 14
Problem reconnect Pervasive after crashing Programme

I have a programme in VB.NET.
Connection string:
"Provider=PervasiveOLEDB.;Data Source=TEST;Location=hrp-dc1;Cache Authentication=False;Encrypt Password=False;Mask Password=False;Persist Encrypted=False;Persist Security Info=False;Impersonation Level=Anonymous;Mode=ReadWrite;Protection Level=None;Port=1583;Pessimistic Read Lock=False;CommandOnly=False;DirectOnly=False;Loca lTCP=False" />

TEST is ODBC. Installed on the server. PGM connects from Client through oledb with server where ODBC installed.

UpdRel = String
OLECmd = New OleDb.OleDbCommand(UpdRel, cn)
OLECmd.ExecuteNonQuery()

I have an exception event handler for duplicate key, oledbexception and general exception. PGM terminates OLECmd and connection.

Problem when I updating (The programme has updated records allready): Somehow general exception encounters an error: "Is data name and Server available" (something like that)
When I click Oke programme terminates, but reconnecting to Perv.database is impossible. Even restarting Pervasive PSQL Client Engine doesn't help.
It looks like something is still running in the background.

Pervasive V10 installed on server. Time out on Server is 15 min.
In General waiting for 2 hours suddenly can connect again.
How can i terminate a waiting thread?

In PCC is get the error message: java.net.SocketTimeoutException: Read timed out.

Any one an idea?

Last edited by Keereweer; 02-15-10 at 07:42.
Reply With Quote