Questions tagged [remote]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
70 views

SQL remote connection with new user fails

Besides the sa user in the SQL server, I created a new user (called test) which only has read permissions. The user was created via MSSMS, with the following properties: Sql server authentication ...
0
votes
0answers
135 views

Tuning MySQL 5.0 / Linux TCP/IP settings for remote connections

I have installed MySQL 5.0 on a remote server over the internet and connected my JAVA application to it. It works fine, yet I see some delay retrieving results from the database compared to MySQL ...
0
votes
1answer
1k views

How to connect to remote MySQL from a specific IP?

I have two IPs (192.168.13.1 and 192.168.13.2) in my Server A and have provided select access to another Server B for secondary IP/virtual IP (192.168.13.2). mysql> show grants for web_app@192....
0
votes
1answer
312 views

postgresql query hangs indefinitely over VPN - new firewall

We have a product where a local linux machine "SCANNER" does some polling on a local network and then stuffs information into a database in our cloud server over an OpenVPN connection, using pg_query (...
0
votes
1answer
416 views

Mysql Remote IP blocked

I have a peculiar issue with some database connections: I've got this (test) script on 2 different servers: $link = mysql_connect($db_server, $db_user, $db_passwd); if (!$link) { die('Could not ...
0
votes
1answer
344 views

Can I restore a .bmp file of full database backup to an Oracle 12c EE instance running on RDS?

I've got an Oracle 12c EE database set up on an RDS box with no SSH access. I do, however, have SQL Developer and SQL PLUS tools. Is there any way I can restore a full backup into this database using ...
0
votes
1answer
29 views

Problem remotely connecting to MySQL database

Good afternoon everyone. I have 3 servers on 2 different networks, all of which run MySQL. I can use mysql -u<user> -p -h<ip-addr> from server 1 to server 2 and back without a problem. ...
0
votes
1answer
371 views

Can I reference a specific column in a remote table (MySQL)?

I have two databases (MySQL) on two different servers, and one table references a table in the other. However, I am unable to point the reference to a specific column in the remote table for some ...
0
votes
1answer
181 views

Remotely inserting 3.5m records mysql

I need to remotely insert 3.5 million rows to my amazon rds. Currently my data is in an access database, for which I will use bullzip, access to mysql to create dump files. I have created my schema on ...
0
votes
1answer
2k views

Want to remove global_name from DB links (Oracle 11g)

I am trying to call remote function via DB LINKS. However, My global name contains the string ON and I believe it causes an error. The Error I have is ... SQL> var tmp varchar2(2); SQL> ...
0
votes
0answers
712 views

Can't connect to other instance of SQL Server 2012

I'm working through a Microsoft exam study book. I have set up 2 SQL Servers (both 2012 Standard on Server 2008 R2) and a DC. The book wants me to remotely connect SQL-A to SQL-B. Unfortunately the ...
0
votes
1answer
54 views

Can mariaDB contain indices only with data coming from remote tables?

I'm trying to think through a setup with a central mariaDB instance (A) accessing data on physically remote servers (B). All queries to the database (A) can be answered from indices only. Indices are ...
0
votes
0answers
7k views

Connect to a Remote MySQL

I'm trying to connect to a MySQL remote Server but I always get: RROR 2003 (HY000): Can't connect to MySQL server on 'IP' (111 "Connection refused") I follow this rule in the remote server GRANT ...
0
votes
0answers
41 views

Continue a command on the remote MySQL server when I exit local MySQL workbench?

I'm issuing a DROP TABLE command that is taking a very long time. If I close down my local MySQL Workbench, will the command still be running and finish on the remote server? If it doesn't, is there ...
0
votes
0answers
542 views

Which local port does MySQL Workbench forward to in 'Standard TCP/IP over SSH' connections?

So if I was to set up an ssh tunnel for MySQL in terminal I would forward remote 3306 to local 3307: ssh -L 3307:127.0.0.1:3306 user@domain.com mysql -h 127.0.0.1 -P 3307 -u user -p db When ...
0
votes
1answer
998 views

remote connection to mysql

have two machine PC#1 with db mysql and appache and PC#2 with a c# form try to connect to this db here is my connection string used in PC#2: SERVER=My_public_ip;PORT=3306;DATABASE = my_test; UID = ...
0
votes
1answer
141 views

Remote SSIS development

I'm currently developing SSIS packages which include transferring data between two servers. The servers are in the same local LAN, but I'm remote to them. Is there any way that I can develop the ...
-1
votes
2answers
387 views

TNS connection forward

There are 3 machines as follows: Machine A - Remote Exadata DB machine Machine B - Remote machine from which only I can connect to port 1521 of Machine A Machine C - Local Machine (To run SQL ...
-1
votes
1answer
114 views

Unable to connect to mysql remote

I am struggling to connect MySQL database with my application, I am having the following set up 3 Applications running in cluster mode and trying to connect with same DB. MySQL database running on ...
-2
votes
1answer
678 views

Connect an desktop application to my SQL Server using internet

I want to connect a desktop app to a SQL Server using internet, not local. The app will run on every network in the world with internet and the data will retrieve and send from my PC using SQL Server.....