JSL - Save Database() leaves a database connection open - can this be closed?

Question

Hi all,

I've been trying different things for a while now and can't figure it out.  In JSL, the Save Database() command appears to leave a database connection open.  Since there isn't a handle to it, I can't figure out how to close the connection.  Is there a way to close this connection?

thanks,

Hyde

HydeMiller · Answer

Thanks for the suggestion but it doesn't appear to make a difference.  I set it to <not pooled> and it still leaves a session hanging.  By the way, I'm using ODBC Driver 11 for SQL Server.  Is this what you use?

stan_koprowski · Answer

Hyde,

It looks like there is a connection pooling option in the ODBC driver.

Might want to take a look at the driver and ensure ConnectionPooling is set to false (0).

Stan

HydeMiller · Answer

Yeah, I thought of that too and single stepped through the program.  There is no connection prior to Save Database() and one left hanging after it.  Another way around it would be to get a list of open database connections.  However, I didn't find any JSL that provided that information.  I also tried to trick Save Database() into providing a handle to the connection but nothing I tried worked.