Re: Connection MySQL through ADO with MyOLEDB provider
- From: "Mehran Ziadloo" <mehran20@xxxxxxxxxxx>
- Date: Sat, 20 Aug 2005 08:50:23 +0430
Well it's MyOLEDB v3.0 and as long as I know it's the latest version.
Of course I have a connection object!! And I found a silly way myself:
try {
recordSet = connection->Execute(query.data(), NULL, 1);
}
I don't know why but this way it works fine!!
Thanks anyway.
Mehran Ziadloo
"Stephen Howe" <stephenPOINThoweATtns-globalPOINTcom> wrote in message
news:#uHcRhDpFHA.2904@xxxxxxxxxxxxxxxxxxxxxxx
> > try {
> > command->CommandText = query.data();
> > recordset->Open ( (IDispatch *) command, vtMissing, adOpenStatic,
> > adLockBatchOptimistic, adCmdUnknown);
> > }
>
> You need to have a connection for command object. Do you have one?
> Other than this it looks fine. It is probably a MYOLEDB problem
>
> You don't report the version number of MYOLEDB
>
> What I would do is this:
>
> 1. See if you can find a later provider (driver) of MYOLEDB that fixes
this
> problem
> 2. Failing that, find out if this is a known problem with this provider
and
> if there are any workarounds.
>
> S
>
>
.
- References:
- Connection MySQL through ADO with MyOLEDB provider
- From: Mehran Ziadloo
- Re: Connection MySQL through ADO with MyOLEDB provider
- From: Stephen Howe
- Connection MySQL through ADO with MyOLEDB provider
- Prev by Date: Suppressing TSQL print messages from SQL batches
- Next by Date: Logon password protection redirect to orignal page not working
- Previous by thread: Re: Connection MySQL through ADO with MyOLEDB provider
- Next by thread: Two related combo's in ASP
- Index(es):
Relevant Pages
|
|
