Re: myOLEDB

[Doogie Brodie <ukhad@xxxxxxx>]

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

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.