Extract BIG EXE File from SQLServer 6.5 
Author Message
 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
 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
 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
 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
 
 [ 4 post ] 

 Relevant Pages 

1. Big problem with the sqlserver 6.5

2. VerQueryValue to extract file version from an EXE

3. EXE file is too big!

4. Extremly big log files after importing a table to 7 from 6.5

5. create a tab delimited file using isql.exe (SQL Server 6.5)

6. (SQL 6.5)How Run a .EXE File in Stored Procedures?(NULL)

7. restore backup files from sql server 6.5 to sqlserver 7.0

8. Accessing 6.5 files from SQLServer 7.0

9. How to convert flat file data into SQLSERVER 6.5

10. VB5 - Access 97 - SqlServer 6.5 - non-disappearing tmp file

11. can't restore a backup from file on sqlserver 6.5

12. DAO Blob Adding/Extracting (audio files, text files, image files, program files)


 
Powered by phpBB® Forum Software