weird ADO issue

  • Thread starter Thread starter Paul Shpilsher
  • Start date Start date
P

Paul Shpilsher

Hi all,

I apologize for posting in this NG if this post is a better fit for some
other group, however I am up against the wall here.

My program uses free threaded COM. Once in a while (depending on routines I
call) I instantiate ADO, use it and release.
Everything works fine on XP Professional, and on Windows 2000 (workstation)
however, when I run it on Windows 2000 server, in the beginning everything
works fine, and then, out of nowhere, I get intermittent failure (0x80010105
HRESULT) from:

ADODB::_ConnectionPtr spConn;
hr = spConn.CreateInstance( ADODB::CLSID_Connection );

(I use VC++7)

Similar behavior I get when I instantiate VBScriprt's RegExp component in
the same program. But here I am catching 0xC0000005 error from
m_spRegExp.CreateInstance( __uuidof(VBS_REGEX::RegExp) );


Yes, I know... maybe I don't release objects properly, or some other bug in
my software... I've tried almost everything there is to try.... the bottom
line It WORKS on XP sp2, but not on 2000 server sp4.

Please help, I am up against the wall here.

Thanks.

Paul
 
Run either C:\Program Files\Common Files\System\ADO\MAKAPT15.BAT or
C:\Program Files\Common Files\System\ADO\MAKFRE15.BAT to make ADO compatible
with either apartment or free threaded applications.

The free ADO model will be incompatible with some apartment threaded
applications like the older versions of IIS. For IIS 5 or 6, I don't know.
The nature of the called database (SQL-Server or Access MDB/JET) is also
important here. If you are calling only SQL-Server, I think that you may
use the free threaded ADO model even with apartment threaded applications.

Also, I don't see the usefulness of doing a free threaded component when you
will call such a big thing like ADO.

S. L.
 
Also, something like m.p.data.ado, m.p.vc.database or even
m.p.dotnet.languages.vc would have been a much better choice than this
newsgroup.

S. L.
 
Back
Top