sqlbaseguptateamdeveloper

Connecting SQLBase Server running on Virual Machine


I have a physical Window Server 2008 R2 machine running SQLBase 8.5 and I have no problem connecting to it. Recently I migrated this server to a virtual machine and the problem come up. Sometimes I am able to connect to the Server and sometimes not.

I can pin my Virtual Server but not able to connect to it through SQLTalk or any client application. Is anyone having the same issue running SQLBase 8.5 on a Virtual Machine?

Thanks!


Solution

    1. Check how many users connect at a time. SQLBase 8.5 have some limitation when maximum number of users/cilents exceedes.
    2. Try to find whether the issue occurs when a large query is executed. If so then try to simplify it.
    3. Check for blocking issues. Try to test its working when disabling Internet security applications\antivirus\Firewall for some time.
    4. Check for port issues. Check the 'listenport' value of sql.ini file.
    5. Check for SQLBaseConnection properties and cross check the parmeters like 'connection lifetime'.