Subject | FB 2.1.3 & Virtual Servers |
---|---|
Author | tomc7777777 |
Post date | 2011-06-03T15:42Z |
Hi,
This is a strange situation and I wonder if anyone knows what might be happening here.
A 10-user site are today in the process of migrating from a 'normal' LAN to a hosted solution with the FB database deployed on a Win2008 R2 64-bit Virtual server.
Before, issuing the following command gave identical results on both the client and the server:
SELECT MON$USER, MON$REMOTE_ADDRESS, MON$REMOTE_PID, MON$TIMESTAMP
FROM MON$ATTACHMENTS
Now, at the moment 4 connections are accessing the DB but the client only reports just one connection, whereas the server reports 4.
At first, I thought the client I was using was somehow accessing another database ~ but~ when I disconnected and re-connected the server always dropped and picked up the connection as expected!?
TIA,
Tom
This is a strange situation and I wonder if anyone knows what might be happening here.
A 10-user site are today in the process of migrating from a 'normal' LAN to a hosted solution with the FB database deployed on a Win2008 R2 64-bit Virtual server.
Before, issuing the following command gave identical results on both the client and the server:
SELECT MON$USER, MON$REMOTE_ADDRESS, MON$REMOTE_PID, MON$TIMESTAMP
FROM MON$ATTACHMENTS
Now, at the moment 4 connections are accessing the DB but the client only reports just one connection, whereas the server reports 4.
At first, I thought the client I was using was somehow accessing another database ~ but~ when I disconnected and re-connected the server always dropped and picked up the connection as expected!?
TIA,
Tom