I have a very small application that I am rolling out to about 6 agents. When it starts, it hits the database and pulls up 18 rows to view standing orders. There are about 6K rows in the table that I am hitting.
The 3 installs went fine. The users on 4th, 5th and 6th installations could not get the application to run. Just an hour glass. A few minutes, eveyone (using another application that hits the same database) got runtime error 462 and we had to reboot the database.
The manager of the group told me that they started getting the error the day before, so I don't think it was my app (alone).
These are fairly simple queries. The SQL was automatically generated from the where clause that I used in the datawindow. Each installation uses a system DSN (which is also used by another reservation system).
Question: Could the PB application be conflicting with the DSN that is in use by the reservation system? Obviously the user can only use one application at a time. There is no timer event that would cause my application to refresh by itself.
I thought maybe sql server does not have enough memory, or perhaps there are not enough licensed connections?
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Programmer's Notepad is, one of the best free text editing tools available, simply because the developers appear to have second-guessed every weird problem or issue a programmer is likely to run into.
One of these problems is selecting and deleti…
Here is a helpful source code for C++ Builder programmers that allows you to manage and manipulate HTML content from C++ code, while also handling HTML events like onclick, onmouseover, ...
Some objects defined and used in this source include: