Re: When upload file to Oracle database the data is truncated

"res0g2vv" <res0g2vv_at_verizon.net> wrote in message news:lk7p7.866$6o2.612158_at_paloalto-snr1.gtei.net...
> When I upload a AutoCad file (exceed 150 KB) into Oracle database(Long Raw
> datatype of that field)
> use ASP, the data is trunctated.(I use VB program check the file size, I
> found the actual file
> size(rs("attachcontent").ActualSize) is l byte less than the file
> size(rs("FileSize)). I found info from
> http://support.microsoft.com/support/kb/articles/Q201/2/36.asp said there
is
> a bug .I installed
> the latest version of MDAC 2.5 SP2(which contain Msadora.dll),but still
> doesn't work..... does any
> body know what cause this problem? what should I do?( I use Oracle 7.)
>
>
>

Upgrade to Oracle 8.1.7 where you can use the bfile datatype.

If you stick to Oracle 7, there will be more and more third-party tools, not to say operating systems on which Oracle 7 has never been tested. You will find yourself in a dead ally soon: you can't upgrade the server becomes it come with a higher version of the O/S and so and so on.

Regards

Sybrand Bakker, Senior Oracle DBA Received on Sun Sep 16 2001 - 15:18:11 CDT