Firebird 3/ IBDAC 7
Hello,
i have a small client server network (2 pc's) .
On the Client PC my connection ini file is :
Data Source=192.168.1.10
Port=3050
DataBase=192.168.1.10:eOlive <-----Alias on Database.conf
Client Library=C:\Windows\System32\FBCLIENT.DLL
My code for the connection :
IBCConnection.DefaultTransaction := trReadOnly; <---- iblReadOnlyReadCommitted (For all my readonly view queries in the application)
If Not IBCConnection.Connected Then begin
IBCConnection.Connected := True;
If IBCConnection.Connected And (Not IBCConnection.InTransaction) Then
trReadOnly.Active := True;
end;
// after connection
tbUsers.Open; <------- Here i wait and get error if i want to reconnect (traped on IBCConnectionConnectionLost with LocalFailOver = True)
on dbMonitor Connection is connected and the transaction trReadOnly is started...!!!
when i choose retry (rmReconnectExecute) the application is working normaly.
Using Firebird Maestro on the same client PC with Database host the same as my ini file (192.168.1.10:eOlive) the Database is loading fast with out any problems and not connection problems.
When stoping the service of Firebird on the server , for test purpose, the client pc
shows IBCConnectionConnectionLost procedure and i choose retry (rmReconnectExecute) and tries to reconnect. After that i restart the service of Firebird and try to reconnect, i choose retry (rmReconnectExecute) the app hangs when trying to connect.
On dbMonitor shows that the database is connected the transaction trReadOnly is started and stuck in a query.open with error messages from dbmonitor :
Unable to complete network request to host "192.168.1.10".
Failed to establish a secondary connection for event processing.
Any ideas?
Thanks
John
P.S. AI could not help me (i have try everything on suggestions)