I want to get some suggestions how to resolve the following scenario. I have some images which stored in a folder of the server in which the SQL Server 2000 is running. In a LAN environment, I can map to the server and retrieve images and connect to the SQL Server through ODBC. However, in a remote access environment, I can still connect to the SQL Server through ODBC using TCP/IP but I cannot map to the server and retrieve images. Should I just store the images into the SQL Server image column? Besides this linkhttp://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en- us/part3/c1161.mspx, are there any articles/webcasts I should check out before using image column? Thanks, Peter
Did you store the path of the images and retreive them? That would be simple method Madhivanan Failing to plan is Planning to fail
well, there are many link if you search http://www.sqlteam.com/item.asp?ItemID=986 http://support.microsoft.com/?kbid=255632 http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6014 many more will be there
Yes sir, it is advisable to store the path of Image folder rather storing images into the column, before we used to store images into the DB but it would effect performance and then we store the path of image and now we are satisfy. hsGoswami ghemant@gmail.com
Read the link. It is the by far most complete discussion on that topic I've found so far. The topic tends be frequently discussed and almost always this ends up in heated discussions. The article gives arguments for both approaches in a very neutral way. Other links, webcasts? None of importance, I'm aware of. But make sure, you read closely through the article. And you can also have a look at the implementation at Terraserver. -- Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
Images are saved in server folder and i want to retreive them throught reference of sql 2005. So please can you tell me how can i save reference in sql and retrieve the same in Datalist control.
Good to see that you did a search before you posted. However, you ended up in a section for the 7.0 and 2000 versions of SQL Server. Also, your questions seems to relate more to Reporting Services, so I would suggest that you re-post there.
