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?