Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amitkumarmadhukar
Starting Member
45 Posts |
 Posted - 2004-06-24 : 09:10:00
|
| Question:How we can store images(*.jpeg,*.bmp,*.gif) and movies files(*.dat,*.avi,*.mpeg) in sql server permanentaly through application developed in Visual Basic.tell the technique and example codeamit kumar madhukar |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-24 : 09:50:27
|
| Don't. You need to store these on a file server where they belong. Just store the directory and filename in SQL Server. If you insist on storing it in SQL Server, look on www.asp.net. They have an example for you including the code. It is in VB.NET though. I'm sure other people on here know where you can find some VB examples.If you do this, you'll be coming back here for more help later on. It really is not a best practice at all.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-06-24 : 09:58:03
|
| Look up READTEXT and WRITETEXT in bol...And get ready for the pain...Do what Derrick suggests...Wonder if Yukon enhaces that...Brett8-) |
|
|
|
|
|
|
Image and Movie Storage over SQl Server