alisonnz2001@... wrote:

>
> Hi all,
>
> i'm using interbase to store html source for an asp website, and the
> site had been working fine until the users attempted to add quite a
> large article.
>
> This returned the error '80004005' , which as far as i can work out
> is a kind of catch all ado error.
>
> All the characters to be inserted are OK (I've inserted the article
> in separate chunks without a problem), and i've extended the size of
> the varchar field to 20000 characters - the article to be inserted is
> roughly 8500.
>
> The maximum number of char's i have managed to insert is about 7000,
> is this the limit for a single insert query?
>
> Or can anyone think of a possible workaround?

It looks like you may have reached the limit of the buffer for a single
statement string.

Have you tried a using a parameterised query?

Paul
--

Paul Reeves
http://www.ibphoenix.com
taking InterBase further