Click here to Skip to main content
15,891,136 members
Home / Discussions / C#
   

C#

 
AnswerRe: Image Quality Improve Pin
Luc Pattyn15-Mar-11 8:42
sitebuilderLuc Pattyn15-Mar-11 8:42 
GeneralRe: Image Quality Improve Pin
Orcun Iyigun15-Mar-11 9:14
Orcun Iyigun15-Mar-11 9:14 
QuestionCrystal Reports Problem Pin
Kevin Marois15-Mar-11 8:00
professionalKevin Marois15-Mar-11 8:00 
AnswerRe: Crystal Reports Problem Pin
Q_rioso28-Apr-11 1:34
Q_rioso28-Apr-11 1:34 
Questionrun program from many PCs and database in one machine ? Pin
Nabawoka15-Mar-11 6:53
Nabawoka15-Mar-11 6:53 
AnswerRe: run program from many PCs and database in one machine ? Pin
Praveen Raghuvanshi15-Mar-11 7:02
professionalPraveen Raghuvanshi15-Mar-11 7:02 
GeneralRe: run program from many PCs and database in one machine ? Pin
Nabawoka15-Mar-11 7:05
Nabawoka15-Mar-11 7:05 
AnswerRe: run program from many PCs and database in one machine ? Pin
Dan Mos15-Mar-11 7:50
Dan Mos15-Mar-11 7:50 
You can use SQL express as a server/service or as a local db.

Local db that is just the current PC can acess it:
"Server=.\SQLExpress;AttachDbFilename=c:\mydbfile.mdf;Database=dbname; Trusted_Connection=Yes;"

Use it as server "Data Source=myServer(or the PC ususally .SqlExpress);Initial Catalog=myDataBase(the actual DB);User Id=myUsername;Password=myPassword;"
This is a sql authentification. Since it's on a local network if all the computers are on the same VLAN they should recognize it by the computer name.

You can insert the IP instead of the pc/computer name but make sure to create a static IP first for the pc that
acts as a server.


Anyway you will need to carefully analyze the requirements. That is how many users will be accesing the DB
at the same time, the complexity of the reports...
If that(the number of simultaneous users) is more than 20, I sugeest SQL full not express.

The express version has one big limitation. It can only use one CPU/core. So from a performance point of view
bad for multi user access.

As something to read about. I try to make something like the following (if possible) for all the apps for a enterprise.

Analize the complexity of the app mainly the complexity of the reports cause a simple insert or update is not that
big of a problem. And if the complexity of the reports is big(that depends on the server hardware too) I use the following config:

client => appserver => sqlserver.

Client = any desktop/laptop.
AppServer = a server that acts as an intermediar between the client and the DB server. Or in other words
a super PC that creates complex reports based on the raw data/info received from the DB server and not only.

The DB server well that is the SQLServer.
Smile | :)
All the best,

Dan

modified on Tuesday, March 15, 2011 1:57 PM

GeneralRe: run program from many PCs and database in one machine ? Pin
Nabawoka15-Mar-11 8:16
Nabawoka15-Mar-11 8:16 
GeneralRe: run program from many PCs and database in one machine ? Pin
Dan Mos15-Mar-11 8:25
Dan Mos15-Mar-11 8:25 
QuestionCoverting MP3's to MP3 Pro VBR Pin
Chrispie12315-Mar-11 4:59
Chrispie12315-Mar-11 4:59 
QuestionEncryption with advapi32.dll Pin
garfield18515-Mar-11 3:38
garfield18515-Mar-11 3:38 
AnswerRe: Encryption with advapi32.dll Pin
Richard MacCutchan15-Mar-11 3:47
mveRichard MacCutchan15-Mar-11 3:47 
GeneralRe: Encryption with advapi32.dll Pin
garfield18515-Mar-11 4:45
garfield18515-Mar-11 4:45 
GeneralRe: Encryption with advapi32.dll Pin
Richard MacCutchan15-Mar-11 4:56
mveRichard MacCutchan15-Mar-11 4:56 
GeneralRe: Encryption with advapi32.dll Pin
garfield18515-Mar-11 5:06
garfield18515-Mar-11 5:06 
GeneralRe: Encryption with advapi32.dll Pin
Richard MacCutchan15-Mar-11 5:20
mveRichard MacCutchan15-Mar-11 5:20 
GeneralRe: Encryption with advapi32.dll Pin
OriginalGriff15-Mar-11 5:27
mveOriginalGriff15-Mar-11 5:27 
GeneralRe: Encryption with advapi32.dll Pin
Richard MacCutchan15-Mar-11 5:49
mveRichard MacCutchan15-Mar-11 5:49 
AnswerRe: Encryption with advapi32.dll Pin
OriginalGriff15-Mar-11 5:26
mveOriginalGriff15-Mar-11 5:26 
GeneralRe: Encryption with advapi32.dll Pin
Luc Pattyn15-Mar-11 5:38
sitebuilderLuc Pattyn15-Mar-11 5:38 
GeneralRe: Encryption with advapi32.dll Pin
OriginalGriff15-Mar-11 5:45
mveOriginalGriff15-Mar-11 5:45 
AnswerRe: Encryption with advapi32.dll Pin
Luc Pattyn15-Mar-11 5:57
sitebuilderLuc Pattyn15-Mar-11 5:57 
JokeRe: Encryption with advapi32.dll Pin
garfield18515-Mar-11 5:43
garfield18515-Mar-11 5:43 
GeneralRe: Encryption with advapi32.dll Pin
OriginalGriff15-Mar-11 5:47
mveOriginalGriff15-Mar-11 5:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.