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 |
|
sudheesh_k_s
Starting Member
10 Posts |
 Posted - 2004-12-22 : 05:44:59
|
| I have a table with two fields one field of int datatype and the other Image data type. I have inserted quite a lot of Images into the tables. And i can display the images in VB. Every thing is fine. Now the problem is I need to update another table on another server over which i cannot connect directly. I thought of inserting the image data field into a notepad directly from the table and from VB open the notepad and insert into the next table. But it doesnt work. Is there any way i can do it.ThanksSudheesh |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-12-22 : 07:28:52
|
| I gotta ask this question first: Is there a specific reason why you are storing the images in the database, rather than on a file server [with the path + filename in the database]?Kristen |
 |
|
|
sudheesh_k_s
Starting Member
10 Posts |
Posted - 2004-12-23 : 00:27:49
|
| Yes. Actually I know it increases the DB size considerably. Actually we r into Jewelery software. We have over 15000 designs stored as JPG files which i insert into the table. I have to display the images through out in the software and have to include it in crystal reports too. Even to access the folder where the image is stored takes time. Its faster this way from the network. Plus i have to distribute the software to different clients too. So this is the easiest way. The question i asked is for distribution purpose where we have the software running at different location. I have to update that server. So I was thinking of writing the image data to notepad and send it on email where the frontend will read and insert into the table |
|
|
|
|
|
|
Insert Images