Got it to work correctly. I needed to set transactions to manual for the ODBC connection. I changed it to use the SQLCOMMIT() function as well. Now it releases the resources and the EM can access the table immediately after I create it. Thanks for pointing me in the right direction!
Jim White
Time is a wonderful teacher. Unfortunately it kills all of its students.