Does SQL Server 7 support compressed Data Files?

[HarryC]

Hi,<br>
<br>
I would be grateful if anyone could help me with the following:<br>
<br>
Can I store zip files in an SQL server database?<br>
And if so, how would I go about this?<br>
<br>
Thanks<br>
<br>

 

[calahans]

hi Harry,<br>
<br>
You could do this but you would need to use a programming language like C or VB to do this. I wrote an app in VB & SS7 to store word docs into a db. You need to use blob (Binary Large Objects) code.<br>
<br>
I out of the office at the moment, however if you look at this site you could get some sample code:<br>
<br>
<A HREF="

http://www.planetsourcecode.com/vb"

TARGET="_new">

http://www.planetsourcecode.com/vb</A><br>

<br>
If you still can't get some sample let me know and I'll get them later.<br>
<br>
Cal

 

[HarryC]

Sorry to be a pain,<br>
<br>
But I've looked on the &quot;PlanetSourceCode&quot; site and cant find the sample code.<br>
<br>
I will be using VB to try and put the zip file into the SQL Server 7 database, but am still not sure how to do this.<br>
<br>
I will be gratefull for any extra info that you can give me.<br>
<br>
thanks again<br>
Harry<br>

 

[calahans]

Harry,<br>
<br>
I won't be able to get the code until 3/4 days time (i'm out of office). In the meantime I suggest you post you question in the VB forum.<br>
<br>
C