Subject FB 2.1.3 & Virtual Servers
Author tomc7777777
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