Re: ODBC - Problem with VARCHAR(16383)

bob brown wrote:
>
> Michael Austin <maustin_at_firstdbasource.com> wrote in message news:<3C6B1403.23C6A1A4_at_firstdbasource.com>...
> > Bob,
> >
> > What version of ODBC for RDB driver are you using. Version of Rdb, and
> > SQL/Services, OpenVMS etc...
>
> ODBC for Rdb is 2.10, Rdb version is 7.0. Do you think I should get
> the latest ODBC driver?

That would no hurt although I suspect that IIS is truncating the data somewhere along the line.

I would put in some debug code to display the variable in question to make sure that what you are about to send is the actual data.

I would also probably do something much different like install the Apache web server and use the Rdb Web Cartridge. What happens is that you send to the database via a "POST" method. I have successfully send up to 65535 bytes to a VARCHAR(65535) field. Then just return the results with links to your page. not that difficult to achieve. I have a C program that basically does this type of function, but it is not universal in that I have coded it to only do certain parts and is tied directly to a particular database/table/columns.

-- 
Regards,

Michael Austin            Registered Linux User #261163
First DBA Source, Inc.    http://www.firstdbasource.com
Sr. Consultant
704-947-1089 (Office)
704-236-4377 (Mobile)