Share this page 

Memory usage with PB7 and MS SQL direct driverTag(s): Common problems

The memory used on the client is very large during a connection and on disconnect it comes back down again.

The fix is to put something in the DBParm property of the SQLCA object. Something like "Application='MyApp'" or whatever. In the development environment, edit the connection properties and make sure something is in the Application Name or Workstation Name on the Network tab.