Questions tagged [database-server]

68 questions
0
votes
1 answer

How to use the same static IP address with different ISPs?

I have a database server configured on AWS and I want to restrict access to it only from my computer's IP. The problem is as IP addresses get assigned dynamically by the ISPs, I manually need to whitelist my IP address before accessing the server…
0
votes
2 answers

reactjs data mapping, get data from server

I'm new reactjs I'm trying to save data that I got from server like object(array) but I can't. at render() function, what should I do to save data, I don't wanna display, just save to users (array) or something? I think that I should use "map" but…
Simpa407
  • 11
  • 1
  • 2
0
votes
1 answer

Find the database host name in plesk panel

I've created a database and database user in Plesk panel. I want to use the new database in another server, for this I need database host. Help me to find the database host in Plesk panel. (Note: it is an amazon server. I created a new instance and…
raj
  • 261
  • 3
  • 14
0
votes
2 answers

how to connect to mysql on host on another computer on network

For $conn = mysql_connect("192.168.0.235", "root", "") or die("Could not connect: " . mysql_error()); mysql_select_db("crossdomaintest"); $result = mysql_query("SELECT * FROM testing"); while ($row = mysql_fetch_array($result, MYSQL_NUM)) { …
S L
  • 14,262
  • 17
  • 77
  • 116
0
votes
2 answers

How to connect to a database on VPN from EC2?

I have a NodeJs web application running on amazon EC2 server. Now from this node app in EC2, I have to access a database system (SqlServer) which is in the customer's in house network which can be accessed only with a VPN. What are the possible…
0
votes
1 answer

FlexiDB Inserting 1000 rows is slow, how can I speed it up?

I am using FlexiDB Server, when I insert 1000 rows using the command below it takes some time: $.collection('collection_name').insert(row); How can this be accelerated?
Ben Osborne
  • 218
  • 4
  • 15
0
votes
1 answer

PostgreSQL internals- using GUC in an Operator?

I am creating my own index method in PostgreSQL based on GiST as extension. I want one of my functions (check out Examples section) in my operator to behave differently based on a value defined by the user- I want to avoid the user having to drop…
Zeruno
  • 1,391
  • 2
  • 20
  • 39
0
votes
4 answers

How to create a new database in MS SQL Server?

Sorry, if this has been asked previously. In services on a client, I can see that MS SQL Server has the status "started". and on this machine I don't have Microsoft SQL SERVER Management Studio. How can I create a new database? Thank you!
Dax
  • 438
  • 1
  • 8
  • 29
0
votes
1 answer

Is there any issue using the same postgresql database for two different servers?

I am using postgres database which is accessed by jboss and tomcat server. My server accidentally restarted and then postgres service was not showing in the services list. When I tried to open postgres local host server using pgadminIII it showed…
Antony Joslin
  • 309
  • 4
  • 17
0
votes
0 answers

Set up a database server that takes http requests

Sorry for the basic question, but I can't find a way to word it properly to find what I need. I'm making an Android application and I would like to make an SQL server database that I would put online (no localhost) to allow http requests to it, from…
zuokuok
  • 323
  • 1
  • 6
  • 16
0
votes
1 answer

JSONObject getInt(string) method causing java.lang.RuntimeException. Android Studio

I am trying to check if the user is entering the correct user id and password to log in to the app. My database is already deployed online. Everything runs smoothly until I am getting the results to check if the user is allowed to proceed. But the…
Rehan Yousaf
  • 235
  • 2
  • 4
  • 13
0
votes
2 answers

Recommended server layout/architecture for Rails application

What is the recommended server layout for a production Rails application that is expected to receive medium (not heavy, but not light either) traffic? I'm thinking of a setup running Apache and Passenger (mod_rails). How many application servers,…
0
votes
1 answer

Which process establishes the connection with the database server?

Let's suppose we have a single host where there is a Web Server and a Database Server. An external application sends an http request to the web server to access to the database. The data access logic is made for example by Python API. The web…
0
votes
0 answers

Batch file connect to database server to get table in the form of CSV file to application server

I got a requirement on the batch file script but I am new to write the Batch file script. Here is the requirement: I have Application and Database servers. Batch file run on Application server. connect to Database server. run the query present in…
Charan
  • 11
  • 2
  • 4
0
votes
0 answers

Emulate Oracle DB server to provide external callback

I am trying to think of a solution to provide my own callback to events which can only be pushed to an Oracle Database server (configuration parameters are ip, port, user, pass) by an external server. I have been told that, if i did have an Oracle…
Benoît
  • 16,798
  • 8
  • 46
  • 66