Best option for storing files in a app

Question

0.00/5 (No votes)

See more:

Hi! I'm working in a vb6 app with SQL Server 2008. This app is a kind of CRM, so we have a entity for the customer and we would like to attach some files to each customer (ex: docx, xlsx, jpeg, and so on). The app will be accesed by several users and this files has to be available for all of the users. The first option I was thinking was storing the files directly in the database SQL in a byte field, but for obvious reasons I'm not convinced. Another option was to simply store the path of the file, but in this case the file may not be available for all users.
Could you give me your opinion about the best way to do this? I'll be very grateful!
Tks in advance and excuse my rusty english!

Cristian

Posted 27-Dec-14 2:55am

Ing. Cristian Marucci

Add a Solution

Comments

Maciej Los 27-Dec-14 10:19am

Why vb6? Who wants to use it anymore? I'd suggest you to write this app with any .net language: vb.net, c#, etc.

Ing. Cristian Marucci 27-Dec-14 19:00pm

Believe me, I don't want to use it... but my client needs to do it in vb6 cause is a new functionality in an existing app...

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Accepted Answer · 2014-12-27T05:36:00

Solution 1

It depends on many factors...
As per my experience, i'd suggest to store files outside the database, but the path to them in a database.

Posted 27-Dec-14 5:36am

Maciej Los

Comments

Ing. Cristian Marucci 27-Dec-14 19:06pm

Tks for your reply! Would you store a path to a shared folder in the network for example?

Maciej Los 28-Dec-14 7:38am

Yeah...