I'm having problem with COM+ Services failing after three or four days running with an application using ADO in a clustered invironment.
This happens every 3 to 4 days and when we fail it over, it works for 3 to 4 more days.. What happens is ADO can't connect to the SQL server that is on the same machine as the application. I'm using a trusted connection string to connect to SQL using OLEDB. This cluster has around 200GB total storage on an array. Can anyone help me here. Am I doing something wrong in my C++ app connecting to ADO?
Error found in Event Viewer.
The COM+ Services DLL (comsvcs.dll) was unable to load because allocation of thread local storage failed.
Process Name: CDE.exe
Error Code = 0x80070008 : Not enough storage is available to process this command.
COM+ Services Internals Information:
File: .\comsvcs.cpp, Line: 289
I'm #import "location\\ado...etc.." (no_namespace)
I'm not where the code is so I don't know off hand the full location of the ADO DLL, but it's in the code.
I'm using GetRows get get my data..
Using SafeArrays to hold my data as I use it..
I'm kind of throwing these things out there, just in case I don't know something about Clusters and using these different things together causing problems or not.