I have written an application which connects to SQL Server using ADO. I get the following error on executing the app on a windows 2003 SBS server with MDAC 2.8 SP2 installed:
"The exception unknown software exception (0x0eedfade) occurred in the application at location 0x77e55dea"
When I look in the Application Event Log it is showing an Error 1000 with the explanation of:
"Error occured in application AQM.EXE Version 0.0.0.0 faulting module Kernel32.dll, version 5.2.3790.1830 fault address 0x00015dea"
I have tried to re-engineer the changes made and have found that the error occurs when certain files are added to the uses clause of a unit even though none of the procedures or functions or variables are called.
The application works fine on Windows XP SP2 and on Windows 2000 Servers which made me think that it is something to do with the security changes made to MDAC concerning broadcasts to the sql server. This has me completely stumped and is now a serious problem as I cannot ship the software to be run via Microsoft Terminal Server.
I am currently Developing in Delphi v5, looking to move to Delphi 2006 but this problem has taken precedence over the migration. On the server I have logged on as the domain administrator.
Your help would be much appreciated.