Questions tagged [database-server]
68 questions
1
vote
1 answer
How to safeguard my mysql_connect password (My database server's password)?
*This question is for NON-local host's.
*I am using a web-host service. NOT my personal server.
To use mysql_connect, to connect to a database's server, one needs to create a php file and save it in the web host's server. This file must have (within…
Omar
- 11
- 1
1
vote
1 answer
DB Server Requirements Advice
I am building a MySQL database with a web front end for a client. The client and their staff will use this webapp on a daily basis, creating anywhere from a few thousand, to possibly a few hundred thousand records annually. I just picked up a second…
Garfonzo
- 3,876
- 6
- 43
- 78
1
vote
2 answers
how to config apache point to another index in different server?
I am configuring 3 tiers setup(webserver, database server, and application server). I want to separate everything into 3 three servers. I have already separated between the application server and the database server. Regarding to webserver and…
Kimly Vith
- 53
- 1
- 6
1
vote
0 answers
How to fix "inconsistency occurred between the server state and the php.ini state" in Zendcore Extension Configuration of Oci8
Unable to run .php oracle server connection file because it is giving an error in Zendcore Extension Configuration i.e "Extensions marked with a symbol '!' indicate that an inconsistency occurred between the server state and the php.ini state.…
Muhammad Mohsin
- 11
- 2
1
vote
1 answer
Mongodb server. How to automatically change the status is expired when expired
In mongodb I have a collection (user), where there is 2 information is status and expiry (date). How to automatically change the status is expired when expired at database server. Thanks
ThuanIT
- 33
- 7
1
vote
2 answers
Connect directly to a remote SQL Server with Delphi
I've created a Delphi application that runs on multiple client computers across the country. The database it uses is SQL Server which is heavily dependent on stored procedures.
The problem is the DB needs to be on a central server with no…
Siavash
- 358
- 1
- 5
- 19
1
vote
0 answers
How to reconnect to database server on personal PC?
I am just starting to learn SQL. I downloaded MySQL and created a server with it on my PC. I was able to connect to the server and start trying SQL commands. Now its a couple days later, when I open MySQL workbench and try to connect to the…
Steve
- 61
- 1
- 2
1
vote
0 answers
Vagrant configuration will not be effected with installing "MySQL Database server"
I have already configured MySQL Workbench with vagrant and accessing sites as www-devsite.com. I need to have install new sites on localhost as we do by using WAMP/XAMP on windows but I don't know following installations will effect or damage my…
usmanjutt84
- 353
- 5
- 21
1
vote
0 answers
Web Server and Database Server in a Docker Container
I am quite new to Docker and was wondering if there is any possible way I can find out how a Docker would be used to secure a Web Server and a Database Server. I have Apache Web Server and MySQL Database Server up and running and perfectly…
RichieR
- 11
- 1
1
vote
0 answers
Database server and application server speed issue
I have a web application developed in ROR and used MongoDB as a database.
When the application and database are on the same server, the application loads faster and also the queries execute faster.
But when I move them on separate servers(separate…
Sagar Kamble
- 602
- 4
- 12
1
vote
1 answer
How to connect an iOS app to SQL server without webservices?
I am given a task to retrieve data from a database server.
I have the following details:
HOST
PORT
DATABASE
USERNAME
PASSWORD
But how can I fire a connection from iOS to the database server directly?
No SOAP/RESTful APIs available.
malhobayyeb
- 2,725
- 11
- 57
- 91
1
vote
1 answer
How to change timezone in Oracle Database specific to one SID, system having many DB SID Configured
I have to change timezone for the particular Database(SID). Where I have DB Server is having multiple Database (SID) Configured and installed.
When i have connected Particular SID and run below Query :
alter database set time_zone='-05:00'
I got…
Gautam
- 3,707
- 5
- 36
- 57
1
vote
1 answer
Connect to db2 server in windows
I am connecting to a db2 database server using this piece of java code.
import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;
public class DatabaseConnect {
Connection co=null;
Statement st=null;
…
div
- 1,475
- 3
- 22
- 32
1
vote
1 answer
DBMS And Database Server Software
OK.. I have done research on this but the more I look into this the more I get confused. So thought of posting it here.
DBMS provides database server functionality
DBMS has a server component and a client component
DBMS = database server…
higgs_boson
- 119
- 1
- 6
1
vote
1 answer
Use a specific database and table in MSSQL (Visual Studio)
I am working in Visual Studio and using the SQL manager built into the studio. Now I am connecting to several databases and I would very much like to be able to save and open my SQL queries and still have them access the correct database and…
Mr.Glaurung
- 516
- 6
- 17