SQL Server 200
-
I am using SQL Server 2000 on back end and .Net C sharp on front end. Server is connected with more than 30 users. On user’s computers there are different files having different formats like MS Word, Excel, Txt and Visio etc with more than 4 MB size. I want to see these files through database, edit, save them and resend to users through database on LAN. How Can I Do All This in Window Application without sharing any directory? Best Regards and Thanks for your kind Help:
-
I am using SQL Server 2000 on back end and .Net C sharp on front end. Server is connected with more than 30 users. On user’s computers there are different files having different formats like MS Word, Excel, Txt and Visio etc with more than 4 MB size. I want to see these files through database, edit, save them and resend to users through database on LAN. How Can I Do All This in Window Application without sharing any directory? Best Regards and Thanks for your kind Help:
If you want to pass them using the database, check out storing binary data in a table. SQl 2005 support large data as binary, i suppose SQL 2000 has the image (or text but is limited) field for this. Otherwise you'll can store the IP Addresses of each client and send it using the windows socket. Another way to do it is using a FTP server and store and retrieve them bij using FTP connections. It's called FILE Transfer Protocol for some reason :-) the choice is your's... greetz Kurt