[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.dotnet.framework.odbcnet

MyOleDB gets connected/disconnected at every Execute

Hemanshu Shah

4/6/2002 7:21:00 AM

I am writing a .NET application in C#, using MyOleDB to connect to mysql
database.

What I found is following queries does not work.

After inserting a record in table having auto increment column,
select last_insert_id() always returns 0.

Also
Select 5 returns always 0.

Also
Select Connection_ID() always return 0.

Also I saw process, of mysql and it seems that, OleDB creates connection to
mysql for each execute of OleDBCommand, instead of maintaining connection
till we close it.

Any suggestions??
4 Answers

Bob Beauchemin

4/6/2002 8:26:00 AM

0

I would suspect a problem with the MyOLEDB provider. I've tested a lot of
OLE DB providers and the OleDb data provider doesn't do that with any of
them. You might try the MyODBC driver (and Odbc data provider) as folks have
more success with it.

Bob Beauchemin
bobb@develop.com


"Hemanshu Shah" <hemanshu_shah@hotmail.com> wrote in message
news:eLNwRnS3BHA.1272@tkmsftngp03...
> I am writing a .NET application in C#, using MyOleDB to connect to mysql
> database.
>
> What I found is following queries does not work.
>
> After inserting a record in table having auto increment column,
> select last_insert_id() always returns 0.
>
> Also
> Select 5 returns always 0.
>
> Also
> Select Connection_ID() always return 0.
>
> Also I saw process, of mysql and it seems that, OleDB creates connection
to
> mysql for each execute of OleDBCommand, instead of maintaining connection
> till we close it.
>
> Any suggestions??
>
>
>

Hemanshu Shah

4/8/2002 8:12:00 PM

0

Thanks Bob!!

But I was facing problem with ODBC .NET with mysql driver when a column is
null value. Many users have posted this problem in this forum itself.

There is a fix available by MS but only to its subscribers and I am not one
of them.

I will try to post this bug in MyOLEDB list if possible.

Thanks once again!!


"Bob Beauchemin" <no_bobb_spam@develop.com> wrote in message
news:#veRmPT3BHA.2816@tkmsftngp05...
> I would suspect a problem with the MyOLEDB provider. I've tested a lot of
> OLE DB providers and the OleDb data provider doesn't do that with any of
> them. You might try the MyODBC driver (and Odbc data provider) as folks
have
> more success with it.
>
> Bob Beauchemin
> bobb@develop.com
>
>
> "Hemanshu Shah" <hemanshu_shah@hotmail.com> wrote in message
> news:eLNwRnS3BHA.1272@tkmsftngp03...
> > I am writing a .NET application in C#, using MyOleDB to connect to mysql
> > database.
> >
> > What I found is following queries does not work.
> >
> > After inserting a record in table having auto increment column,
> > select last_insert_id() always returns 0.
> >
> > Also
> > Select 5 returns always 0.
> >
> > Also
> > Select Connection_ID() always return 0.
> >
> > Also I saw process, of mysql and it seems that, OleDB creates connection
> to
> > mysql for each execute of OleDBCommand, instead of maintaining
connection
> > till we close it.
> >
> > Any suggestions??
> >
> >
> >
>
>

Bob Beauchemin

4/8/2002 9:35:00 PM

0

Hi,

I know the bug you are referring to, it doesn't apply to NULL values, but
empty string values. Check Frederick Bartlett's post onthis subject as well.

Apparently, you need to file a support call with Microsoft (which you can do
without being a member of anything, although it may cost
something...Frederick?) to get the fix. From the docs, this appears to
(perhaps) be based on the fact that it hasn't undergone sufficient
regression testing yet.

The MyOLEDB forum would be your best bet for problems with this provider.

Cheers,
Bob Beauchemin
bobb@develop.com


"Hemanshu Shah" <hemanshu_shah@hotmail.com> wrote in message
news:#td8Pfy3BHA.2648@tkmsftngp05...
> Thanks Bob!!
>
> But I was facing problem with ODBC .NET with mysql driver when a column is
> null value. Many users have posted this problem in this forum itself.
>
> There is a fix available by MS but only to its subscribers and I am not
one
> of them.
>
> I will try to post this bug in MyOLEDB list if possible.
>
> Thanks once again!!
>
>
> "Bob Beauchemin" <no_bobb_spam@develop.com> wrote in message
> news:#veRmPT3BHA.2816@tkmsftngp05...
> > I would suspect a problem with the MyOLEDB provider. I've tested a lot
of
> > OLE DB providers and the OleDb data provider doesn't do that with any of
> > them. You might try the MyODBC driver (and Odbc data provider) as folks
> have
> > more success with it.
> >
> > Bob Beauchemin
> > bobb@develop.com
> >
> >
> > "Hemanshu Shah" <hemanshu_shah@hotmail.com> wrote in message
> > news:eLNwRnS3BHA.1272@tkmsftngp03...
> > > I am writing a .NET application in C#, using MyOleDB to connect to
mysql
> > > database.
> > >
> > > What I found is following queries does not work.
> > >
> > > After inserting a record in table having auto increment column,
> > > select last_insert_id() always returns 0.
> > >
> > > Also
> > > Select 5 returns always 0.
> > >
> > > Also
> > > Select Connection_ID() always return 0.
> > >
> > > Also I saw process, of mysql and it seems that, OleDB creates
connection
> > to
> > > mysql for each execute of OleDBCommand, instead of maintaining
> connection
> > > till we close it.
> > >
> > > Any suggestions??
> > >
> > >
> > >
> >
> >
>
>

Fredrick Bartlett

4/9/2002 4:58:00 AM

0

No, they do not charge for "Hot Fix" support calls. They open a "Free"
support incident.

"Bob Beauchemin" <no_bobb_spam@develop.com> wrote in message
news:ewTeKRz3BHA.1712@tkmsftngp04...
> Hi,
>
> I know the bug you are referring to, it doesn't apply to NULL values, but
> empty string values. Check Frederick Bartlett's post onthis subject as
well.
>
> Apparently, you need to file a support call with Microsoft (which you can
do
> without being a member of anything, although it may cost
> something...Frederick?) to get the fix. From the docs, this appears to
> (perhaps) be based on the fact that it hasn't undergone sufficient
> regression testing yet.
>
> The MyOLEDB forum would be your best bet for problems with this provider.
>
> Cheers,
> Bob Beauchemin
> bobb@develop.com
>
>
> "Hemanshu Shah" <hemanshu_shah@hotmail.com> wrote in message
> news:#td8Pfy3BHA.2648@tkmsftngp05...
> > Thanks Bob!!
> >
> > But I was facing problem with ODBC .NET with mysql driver when a column
is
> > null value. Many users have posted this problem in this forum itself.
> >
> > There is a fix available by MS but only to its subscribers and I am not
> one
> > of them.
> >
> > I will try to post this bug in MyOLEDB list if possible.
> >
> > Thanks once again!!
> >
> >
> > "Bob Beauchemin" <no_bobb_spam@develop.com> wrote in message
> > news:#veRmPT3BHA.2816@tkmsftngp05...
> > > I would suspect a problem with the MyOLEDB provider. I've tested a lot
> of
> > > OLE DB providers and the OleDb data provider doesn't do that with any
of
> > > them. You might try the MyODBC driver (and Odbc data provider) as
folks
> > have
> > > more success with it.
> > >
> > > Bob Beauchemin
> > > bobb@develop.com
> > >
> > >
> > > "Hemanshu Shah" <hemanshu_shah@hotmail.com> wrote in message
> > > news:eLNwRnS3BHA.1272@tkmsftngp03...
> > > > I am writing a .NET application in C#, using MyOleDB to connect to
> mysql
> > > > database.
> > > >
> > > > What I found is following queries does not work.
> > > >
> > > > After inserting a record in table having auto increment column,
> > > > select last_insert_id() always returns 0.
> > > >
> > > > Also
> > > > Select 5 returns always 0.
> > > >
> > > > Also
> > > > Select Connection_ID() always return 0.
> > > >
> > > > Also I saw process, of mysql and it seems that, OleDB creates
> connection
> > > to
> > > > mysql for each execute of OleDBCommand, instead of maintaining
> > connection
> > > > till we close it.
> > > >
> > > > Any suggestions??
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>