Are you using the OLE-DB Provider for SQL Server - or are you using the OLE-DB Provider for ODBC????? If you go to www.microsoft.com/data - you can download the latest components - and the OLE-DB Provider for SQL Server - which should make your life a lot easier....

>I use ado to connect to an SQL server.
>
>I have to store informationin fields.
>Sometimes this can be very big.
>IF the information exceed the 65000 I get an error.
>
>The binay field is a kind off array with a maximum of 65000.
>
>Has someone a solution for this.
>
>Kind regards,
>
>
>Jan Dorresteijn