Detecting Open Database Connection

[drtree]

Hi All,

I'm creating a web application using JavaScript and have created a function that returns a recordset based on the contents of one of the parameters - a SQL statement. To get the recordset to work properly after it's been returned from the function, I've had to leave the database connection open and was just wondering - is there anyway to close it once I'm done with the recordset? Can I, through JavaScript, determine if there are any active connections to the Access database I'm using as the backend?

Thanks for your help,

Dr Tree

 

[drtree]

Sorry for the double post!

 

[BillyRayPreachersSon]

Are you talking server-side or client-side JavaScript here?

Dan



[tt]Dan's Page [blue]@[/blue] Code Couch

http://www.codecouch.com/dan/

[/tt]

 

[drtree]

Dan - thanks for the reply. In this case, I'm using server-side JavaScript. Also, I was doing more research last night into the issue and do you think I should be looking into creating a disconnected recordset or would it make more sense to load the contents of the recordset into an array (and then close out the connection)?

Dr Tree