Hi all

I have a C# application managing some clients on a SQL Server database accessed through local network and also through VPN, and here is my problem.

To update the versions of this application I store the recent exe files on the database and they are downloaded to the client's computer when they start the application. Everything works fine except for the VPN users. The file is almost 5MB and they get timeouts.

What is the best way to transfer this files on to the client's computers, specially to the ones using the VPN

Anyone as a bit of C# code to demonstrate how to retrieve large files from a BLOB

Thanks in advance

"Everything works fine except for the VPN users. The file is almost 5MB and they get timeouts."

What do you mean by this can you elaborate a bit

Best Regards,

Rizwan aka RizwanSharp

Hi

your problem is with the speed of your connection :)

if you are in a local network, things work because you have a fast, local connection..

however, when you are doing this over the vpn, the retrieval takes so long that your connection times out...

you could try and set the timeout on the connection to be a lot longer, but that won't really solve the issue...

the BLOB in sql is a file i would imagine

The solution really depends on your needs..

can you get away with storing the files in a CMS

you can look at things like

sharepoint http://msdn2.microsoft.com/en-us/office/aa905503.aspx

groove http://www.microsoft.com/downloads/details.aspx familyid=baa487e9-e1b9-4a10-beea-1fd906b77f92&displaylang=en

does the file need to get updated, or does it just have to be downloadable...

if downloadable is all it needs you could create a simple asp.net site which
allows you to retrieve the file from sql and send it as a file (so with the save dialog etc) to your user

perhaps you can use the briefcase pattern where the user downloads the
info on a laptop or some such and takes it with him, to synchronize on return (a bit like a pda synchs)

So, all in all, please tell me more about the solution you require ;)

Hope this helps you out, please close the thread if it does

Have you considered to use "Publish" feature of VS Studio to distribute your applications instead of a database query You can publish to web server or ftp server. To me distributing new exe through sql queries is a little strange. In the "Publish" section (in your project property), you can specify the option that when the application is started, it should automatically check updates, and you can specify what's the minimum required version. This covers your use scenario, does it