Local Database Setup???

[joshl_1995]

Hello Community,
I was wondering if there is a way to use some kind of local server such as Wamp, Xampp, easyPHP etc... something like that and set it up so everyone on the same network can access the database on the server.

The server will be running on a dedicated server computer (A computer stored in a room running the server), an online database is not an option it needs to be a lan database.

F.Y.I: I have never worked with servers before so I don't know how they work I only know what they look like so I don't know if all servers have one computer running it all.

[Ancient Dragon]

You don't need web server software unless you want to use a browser to connect to the database. If you write your own program such as with C/C++, C#, VB.NET, etc all the program needs is the ip address of the computer that hosts the database server. If however you are writing a browser-based program then the hosting computer may need a web server program such as wamp (which includes mysql, apache2 and php).

[cmps]

First of all the server is running linux or windows ?
For linux you can use the lampp which is provided by the same company that created the xampp. To access the server from another computer, type the ip of the server in the browser so you will be able to access the xampp as a normal user. To access files you need an FTP software like filezilla.

[JorgeM]

F.Y.I: I have never worked with servers before so I don't know how they work I only know what they look like so I don't know if all servers have one computer running it all.

A server or a workstation really has little difference other than the role of the system. A computer is called a server, once it takes the role of running some software or service that will be servicing hosts on the network. Most of the time, this computer is running a server version of an operating system because a server version is geared for that purposed. However, if you were to run Windows 7 with a app that is accessed by users on the network, techincally its a server.

In your case, to give you better guidance, we need more infomation. For example... how will clients access this server? Is there a desktop application that will be installed on each host on the network? Will they be using a web browser instead?

What database platform are you going to install? MySQL, MSSQL, Oracle, etc...?

[joshl_1995]

Ok well sorry to say but all of you have all missunder stood what I wanted.
What I want is to setup a database on one computer (That is on the same network, as all the employees) and there will be a program on all the employees computers that will access the database stored on the server computer. Also the server computer will be running windows. So the IP would not be a dedicated IP it will be like a sub IP such as eg. 10.1.1.1. While I'm testing this I've installed Xampp on my computer and tried accessing it from another computer I can access the Xampp fine but I can't access the database running in Xampp.

[cmps]

what is the error message ? Access Forbidden or what ?

[joshl_1995]

First of all what is better to use? easyPHP, Wamp or Xampp. I'm used to using Wamp but I thought I might ask.

This is a error message:
Could not connect to the database: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

[cmps]

Personally I use xampp, but wampp is also recommended. For me, I would go with xampp.

Try to google the error, I have found many solutions for many cases. Take a look:
http://www.google.ca/#output=search&sclient=psy-ab&q=Could+not+connect+to+the+database:+A+connection+attempt+failed+because+the+connected+party+did+not+properly+respond+after+a+period+of+time%2C+or+established+connection+failed+because+connected+host+has+failed+to+respond&oq=Could+not+connect+to+the+database:+A+connection+attempt+failed+because+the+connected+party+did+not+properly+respond+after+a+period+of+time%2C+or+established+connection+failed+because+connected+host+has+failed+to+respond&gs_l=hp.3...771.771.0.992.1.1.0.0.0.0.0.0..0.0....1...1c.1.23.psy-ab..1.0.0.mVIs7rwn5FY&pbx=1&bav=on.2,or.r_qf.&bvm=bv.50165853,d.dmg&fp=3122fa12accf04e4&biw=1366&bih=601

[joshl_1995]

Ok, I've fixed it. I'm using Xampp, added a new user to the phpmyadmin and just tried connecting to the database using those credentials.

[cmps]

Congrats, but there is a default user for phpmyadmin, user "root" pass "" have you tried it ?

[joshl_1995]

Yer I tried that but for somereason it didn't work, I think that is because that is the local account so I had to create a normal account.

[joshl_1995]

Thanks