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 |
|
Auric
Yak Posting Veteran
70 Posts |
 Posted - 2005-01-25 : 12:06:14
|
| Hey guys haven't posted in a while, been busy dealing with my academic priorities if ya know what I mean...Anyway, I am starting to embark on a fairly large VB.net database project, converting my existing access app into a full blown VB.net/SQL/ASP portal. I have a question, been reading a few texts and well I can't figure it out. Can you pull graphics/ole objects into VB that is stored on an sql server??Thanks guys,Josh |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2005-01-25 : 14:35:17
|
| Can you yesShould you generally noIt's best to store the PATH to the file in SQL server, and store the file on the file system. You can do some searching on here about such, but that's what everyone is gonna tell you. There are a lot of reasons why, but just take my word on it or do some searching.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
Auric
Yak Posting Veteran
70 Posts |
Posted - 2005-01-25 : 14:43:58
|
| Hey Michael, I know that you generally shouldn't... for what the client uses the database for, and the setup of their network..for the admin to give us space on the server for pictures and other stuff would be a bitch..it was hard enough to get them to give me an SQL DB to work with. (Stupid schools!) The only good news is that the records#'s are low, in the table that houses the pics max of 500, and surprisingly what we have now runs pretty fast. Any suggestions on how I would do something, despite being recommended not to, would be great. Josh |
|
|
|
|
|
|
|
|
Graphics,VB and SQL Server