I’m new to Unity and am trying to build a game that pulls information from an Access database using ODBC. Most of the functionality works when I first run it in the unity editor, but the second time I try it crashes with a file already in use error. I used Visual Studio 2012 to write the dll that is handling the connectivity, and when I try to run a test program in there after running unity a similar error occurs. The only way I can resolve it right now is to close unity completely and reopen it. I’ve made sure I’m closing the connection after running each query, but it doesn’t seem to help.
Actually I think I’ve got this taken care of. Seems to be a permission issue on the folder containing the database. The problem has to do with permissions on the folder containing the database, because running unity as admin solves the problem.