Database Programming, Extract BIG EXE File from SQLServer 6.5

Tech
#1 / 4

Extract BIG EXE File from SQLServer 6.5

I have finally succesfully insert a big EXE file into SQLServer!!!

But I can Only Extract a 32 ko of this file????

I have tryed with BlobField, BlobStream... Stream and File... I have tryed
with the UUEncode and UUDecode too!!

Think I need some help please...

JSG

Wed, 18 Jun 1902 08:00:00 GMT

Steve Koters
#2 / 4

Extract BIG EXE File from SQLServer 6.5

Quote:

> I have finally succesfully insert a big EXE file into SQLServer!!!

>But I can Only Extract a 32 ko of this file????

>I have tryed with BlobField, BlobStream... Stream and File... I have tryed
>with the UUEncode and UUDecode too!!

Sounds like you are using the native BDE driver for Microsoft SQL Server
and have not reset the BLOB SIZE configuration parameter of the driver from
its default value of 32 (that is, 32K).

1. Run the BDE Administrator.

2. In the left pane, on the Configuration tab, expand the tree:

Configuration
Drivers
Native
MSSQL

3. Set the BLOB SIZE parameter in the right pane to the desired value.

4. Save changes and quite BDE Administrator.

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Steve Koterski "Health nuts are going to feel stupid someday,
Felton, CA lying in hospitals dying of nothing."
-- Redd Foxx

Wed, 18 Jun 1902 08:00:00 GMT

Tech
#3 / 4

Extract BIG EXE File from SQLServer 6.5

Is it possible to get the Blob Size Higher than 1000K???
I need 5 meg of Blob!!!

JSG

THX For the answers!

Quote:

>> I have finally succesfully insert a big EXE file into SQLServer!!!

>>But I can Only Extract a 32 ko of this file????

>>I have tryed with BlobField, BlobStream... Stream and File... I have tryed
>>with the UUEncode and UUDecode too!!

>Sounds like you are using the native BDE driver for Microsoft SQL Server
>and have not reset the BLOB SIZE configuration parameter of the driver from
>its default value of 32 (that is, 32K).

>1. Run the BDE Administrator.

>2. In the left pane, on the Configuration tab, expand the tree:

> Configuration
> Drivers
> Native
> MSSQL

>3. Set the BLOB SIZE parameter in the right pane to the desired value.

>4. Save changes and quite BDE Administrator.

>_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
>Steve Koterski "Health nuts are going to feel stupid someday,
>Felton, CA lying in hospitals dying of nothing."
> -- Redd Foxx

Wed, 18 Jun 1902 08:00:00 GMT

Steve Koters
#4 / 4

Extract BIG EXE File from SQLServer 6.5

Quote:

>Is it possible to get the Blob Size Higher than 1000K???
>I need 5 meg of Blob!!!

Not positive, but I believe this configuration parameter only affects the
volume of data the BDE can handle all in one go. Try accessing the BLOB
data using a TBlobStream object. Its Read method allows you to specify the
amount of data to read (expressed in bytes). Try reading the data out in
multiple chunks.

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Steve Koterski "Health nuts are going to feel stupid someday,
Felton, CA lying in hospitals dying of nothing."
-- Redd Foxx

Wed, 18 Jun 1902 08:00:00 GMT