goliver
September 20th, 2001, 11:07 AM
vb6 sp5, sql server 7, win2k sp1.
my app is structured as a win32 ui, stateless middle tier, stateless data tier, sql server sp's.
I'm having trouble with updates to the database. When I set the connection object to nothing prior to exiting the data tier, it takes about 10 seconds to complete that statement.
I'm happy to provide whatever details you might want. Anyone got an idea what this might be?
my app is structured as a win32 ui, stateless middle tier, stateless data tier, sql server sp's.
I'm having trouble with updates to the database. When I set the connection object to nothing prior to exiting the data tier, it takes about 10 seconds to complete that statement.
I'm happy to provide whatever details you might want. Anyone got an idea what this might be?