Re: myOLEDB

[Steve B <steve@xxxxxxx>]

Thats what i looked for i cant find any interger declaration in the 
vb 
code. I did use small int as the primary key in the dbase but modified this
to big int. Maybe i will try recreating the table.

Surely the driver wouldnt have such a small limit when mysql can handle Gb
dbases mine is only 1.6 meg not even a month of logging.


At 09:09 21/05/2002 +0100, you wrote:
>I know nothing about MySQL, but I do know about VB..... Its either
a
>problem in VB or in the OLEDB driver..... 32767 is the maximum
value
>storeable in a 2 byte integer (VB type declaration Integer) but if
that
>was a problem, you'd likely get a numeric overflow error in VB. Just
on
>the off chance that you are assigning an ID value or something to
an
>Integer in VB, change its type declaration to Long which allows up to
4
>bytes... 2147483647
>
>But I get a feeling someone has used an 2 byte integer in your
OLEDB
>driver..... :S
>
>Doogie
>
>Steve B wrote:
> > Yes, i can via phpmyadmin.
> >
> > I have removed any vb error trapping and it does not bomb out
> >
> > At 17:54 20/05/2002 +0100, you wrote:
> >  >Obvious question, though...
> >  >
> >  >Is it a MySQL server issue or an OLEBD issue? If you go
to a client such
> >  >as MySQLFront connected directly, can you insert
rows?
> >  >
> >  >M.
> >  >
> >  >-----Original Message-----
> >  >From: Steve B [mailto:steve@xxxxxxx]
> >  >Sent: 20 May 2002 17:18
> >  >To: ukha_d@xxxxxxx
> >  >Subject: [ukha_d] myOLEDB
> >  >
> >  >
> >  >Hi,
> >  >
> >  >Who was using myOLEDB under vb 6 to connect to mySQL
?
> >  >
> >  >All was fine until i have hit 32767 records in a table
and cant seem to
> >  >insert more and i am lost. Grateful for any help
> >
>
>
>Yahoo! Groups Sponsor
>ADVERTISEMENT
><http://rd.yahoo.com/M=226014.2032696.3508022.1829184/D=egroupweb/S=1705041992:HM/A=1000239/R=0/*http://ads.x10.com/?bHlhaG9vaG0xLmRhd=1021968884%3eM=226014.2032696.3508022.1829184/D=egroupweb/S=1705041992:HM/A=1000239/R=1>5a7d996.jpg
>5a7da61.jpg
>
>For more information: 
><http://www.automatedhome.co.uk>http://www.automatedhome.co.uk
>Post message: ukha_d@xxxxxxx
>Subscribe:  ukha_d-subscribe@xxxxxxx
>Unsubscribe:  ukha_d-unsubscribe@xxxxxxx
>List owner:  ukha_d-owner@xxxxxxx
>
>Your use of Yahoo! Groups is subject to the 
><http://docs.yahoo.com/info/terms/>Yahoo!
Terms of Service.

Steve.

http://www.bov.nu

Yahoo! Groups Sponsor

ADVERTISEMENT

For more information: http://www.automatedhome.co.uk
Post message: ukha_d@xxxxxxx
Subscribe:  ukha_d-subscribe@xxxxxxx
Unsubscribe:  ukha_d-unsubscribe@xxxxxxx
List owner:  ukha_d-owner@xxxxxxx

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.