Search the Community
Showing results for tags 'SQL Server'.
-
When user is waiting fairly time consuming SQL query to finish and application crashes (halts without a trace but that's a another problem) for some reason, database connection might leave table(s) locked. This will cause said table to be unreadable (without dirty read) until database server is restarted. I thought that any and all database connections will be disconnected and any possible locks will be released when application crashes but that doesn't seem to be case. Do any of you have any suggestions how to track down and solve this problem? Database backend is Microsoft SQL Server 2014 Express and I use FireDAC access it. uniGUI version is 1.0.0.1406 (Complete). // Mika
- 3 replies
-
- database
- sql server
-
(and 2 more)
Tagged with:
-
Using the (wonderful) UniGUI I can compile the same code into an exe and a dll just by changing one line in the project source. So, I upload both to my virtual private server. Windows exe runs fine and connects to SQL Server on the VPS using this connection string: Provider=SQLOLEDB;Initial Catalog=ISSYS_Live;Data Source=(local)\SQLEXPRESS;User Id=XXXXX; Password=YYYYYY;Integrated Security=SSPI; I then install the DLL as ISAPI under IIS 7 and run under Firefox. The program works fine but the SQL connection fails. I am missing something here. Is it: - Something I have to configure in IIS 7 - Something in SQL Server - Something in Windows firewall? Thanks Andy