Excellent observation. I've altered the code to close the connection as well
as the resultset and will respond back to confirm that change does allow
another dynamic odbc connection to be opened without restarting coldfusion.
I do not use dynamic odbc excel connections much. But one thing
I'm using the following code to read an excel file. But it only runs
once and I have to restart coldfusion before it will be successful again,
...
rs.close();
I do not use dynamic odbc excel connections much. But one thing that jumps out
at me is you are closing the resultset, but not
2 matches
Mail list logo