|
i want to run windows form program in more than one PC and the database to be in one PC and other PCs connect to it
DB (sql server)
>>>>>>>>
how can i control
*in setup of sql server
*or on connection string
*and what the requirements to make this is need to windows server or sql express
________________________________
tell me the steps and requirements please
|
|
|
|
|
You can create a WCF service that will interact with database on one machine and have various clients(Window/web) running on different machines. The client will interact through a URI of the service.
Praveen Raghuvanshi
Software Developer
|
|
|
|
|
the program will run on local network
|
|
|
|
|
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.
All the best,
Dan
modified on Tuesday, March 15, 2011 1:57 PM
|
|
|
|
|
thnx alot MDL=>Moshu
in sql server is need to enable tcp\ip or named pipes or something another in configuration
or when i setup sql express need to enable thing in setup
i try to use ip 127.0.0.1 and return exception
is there any port needed in the connection string
|
|
|
|
|
Hy,
0)Using 127.0.0.1 won't work when trying to access it form another computer. that is for localhost(s).
1) There is a setting when installing the SQL server. I haven't installed it in a while but I'm sure that there is
2) Normally no port needs to be changed.
Do you have SQL Management Express? If yes try to connect to the db using SQL auth not windows auth.
All the best,
Dan
|
|
|
|
|
Hello Everyone,
I am making use of podcast's very often. And in some versions of the podcast the quality is very low and have some scratching sounds in them. And I do not like to listen to them like that. So I started to play with different file formats.
I have a very old music match version that converts from MP3 to MP3 Pro VBR file format. In this format the scratches is hardly noticeable.
But I do not like Music Match on my system as it has plenty of bugs and known problems with vista onwards - or at least my version that i should have chucked 100 years ago - Don't get me wrong Music Match is great Not trying to make the product bad.
But anyhow... Does anyone know of any open source library that I can embed in a C# project to convert the files to the same file format?
I would really appreciate it
Thanks,
Chrispie
|
|
|
|
|
Hi.
I'm starting to develope with encryption, and I'm supposed to use some functions inside advapi32.dll
I've been searching for information but nothing general to learn from the begining this encryption thing.
Does anybody know a good place with information about this? A predefined class or code? There must be something done, because what I need to do is quite simple, just encrypting and decrypting text (not whole files), for passwords.
Thanks in advance for your help.
PS: Visual Studio 2005, C#.
|
|
|
|
|
Google[^] is always he first place to look.
I must get a clever new signature for 2011.
|
|
|
|
|
Thanks, but of course, if I'm writing here is because I googled before.
Don't answer for that please. There is no need.
|
|
|
|
|
garfield185 wrote: I'm writing here is because I googled before.
So what exactly is your problem?
I must get a clever new signature for 2011.
|
|
|
|
|
|
garfield185 wrote: Read the question again.
Done; now what?
I must get a clever new signature for 2011.
|
|
|
|
|
I assume the OP didn't like the advice: countered.
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
Manfred R. Bihy: "Looks as if OP is learning resistant."
|
|
|
|
|
I must get a clever new signature for 2011.
|
|
|
|
|
I'm with Richard: Google.
You say you have looked, but it can't have been that hard, or your Google-fu needs a lot of practice.
Give it practice, and look: Do your own research and you will learn something that will be useful for the rest of your career. Try to get others to do it, and you will never learn how.
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
Manfred R. Bihy: "Looks as if OP is learning resistant."
|
|
|
|
|
Now give me a fish. I need a fish. It is urgent.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
Fish fish = new Cod(FishUnit.Kilo, 10.3, FishFilleted.False, FishStatus.AliveInWater, FishDeliverySpeed.VeryFast);
TNT OK?
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
Manfred R. Bihy: "Looks as if OP is learning resistant."
|
|
|
|
|
Now we're cooking.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
I know you're right.
But, it's been 2 hours since I wrote the question, and still no result. Of course, I do work, while I wait for your answers. I know when to write a question on the forum or not. I was just asking for some resource.
Thanks for your help.
|
|
|
|
|
It's too general a question: you can find basics by googling "encryption MSDN" - there are probably several different tutorials right there. Don't be so lazy!
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
Manfred R. Bihy: "Looks as if OP is learning resistant."
|
|
|
|
|
garfield185 wrote: But, it's been 2 hours since I wrote the question, and still no result.
No result? I gave you the link to a page full of results. Did you go and investigate any of them, or are you just going to sit here whining because no-one is doing your work for you?
I must get a clever new signature for 2011.
|
|
|
|
|
If all you're doing is encrypting a password, why not just use the encryptions class built into the .NET Framework?? It'll save you from P/Invoking all those functions yourself.
|
|
|
|
|
The problem is that I must use RC4, and the advapi32.dll, because we have other applicactions in powerbuilder using this system.
I am supposed to follow the same steps.
Thanks.
|
|
|
|
|
Good Day,
I'm trying to create a dynamic crystal report viewer.
I need to show only the ACTIVE PARAMATER that is used by a particular report.
Sample:
Parameters in Report Status of Parameter
Company Used in report
Division Used in report
Date Not use in report
Ledger Used in report
I'm able to show the parameters on the form but it is reading all the parameters saved in the crystal report.
I need to ignore those who are not active.
Thank you for your help in advance.
tutzkie
|
|
|
|