ODBC connections never seem to drop...???

[angelleye]

when I view client connections in FM Server Admin I have a whole bunch of xdbc connections that never drop out. I've attached a screenshot for you to take a look at.

We have about 20 employees here. All the rest of those 1000+ connections are from non-dropping xdbc connections that my web applications are connecting with.

I've double checked all my scripts to ensure that I am closing the connection after opening it up. I even created a new WebApp user in FileMaker and I'm using that in 1 place only, ensuring to close it after done using it in the script, and it is also being left in there a bunch of times. I even noticed when creating the WebApp user that I could set it to timeout after it hasn't been used for a certain time. I figured that might fix any that don't drop for whatever reason, however, they're all getting left in there anyway.

Any information on why this is happening or how I can fix it would be greatly appreciated. Thanks!

[angelleye]

More on this. Even if I right click on them and say disconnect, or even say disconnect all clients, these will not go away.

[Jamie Tougas]

We are seeing the same thing as well. Many of our users are hitting FMS for reporting purposes through ODBC and the connections are staying open. We also have custom applications accessing the data via ODBC and they to are in the list even though the code is calling the disconnect and dispose for the connection.

[Colin Keefe]

It's a bug, and Server v3 reportedly fixes it - at least the issues with ODBC sessions supposedly timing out and leaving the connection open.

FileMaker Server Win Updater