weird ADO issue

TheMSsForum.com: The Microsoft Software Forum

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
Top

Re: weird ADO issue by Sylvain

Sylvain
Tue Apr 05 00:54:24 CDT 2005

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.

"Paul Shpilsher" <Paul.Shpilsher@meteorlogix.com> wrote in message
news:d2sagh$qqu$1@domitilla.aioe.org...
> 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
>
>
>
>
>
>
>
>


Top

Re: weird ADO issue by Sylvain

Sylvain
Tue Apr 05 01:01:57 CDT 2005

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.

"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:%23pnPsPaOFHA.524@TK2MSFTNGP09.phx.gbl...
> 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.
>
> "Paul Shpilsher" <Paul.Shpilsher@meteorlogix.com> wrote in message
> news:d2sagh$qqu$1@domitilla.aioe.org...
>> 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
>>
>>
>>
>>
>>
>>
>>
>>
>
>


Top