I am trying to troubleshoot an issue with a client, and I need to figure out which computer on the network is creating certain records. The table has a GUID as its key. I am using GUID_CREATE() from UUIDLIB.DLL with Firebird 1.

I know that the last set of 12 digits is the node identifier, and it's supposed to be based on the MAC address. However, in doing a test myself, it doesn't seem to match the MAC address exactly.

Is the MAC address somehow encoded or manipulated in some way before use in the GUID that is created?

One other question... When used in a client-server situation, is the GUID based on the MAC address of the client, or the Firebird server?

-Joe