The remote tag has no wiki summary.
1
vote
2answers
16 views
MySQL Federated tables and Triggers
This is the scenario.
Have two MySQL servers (S1, S2) on different machines, with a database on each (DB1, DB2).
I have a table (T2) on DB2 that needs to "fectch" rows from another table (T1) on ...
0
votes
0answers
20 views
Trouble with ACE.OleDB.12.0 connection across domains
Here is the situation:
I have two servers, for simplicities sake we'll call them database-server and website-server.
The database-server is to hold an Access database that we're using during ...
0
votes
3answers
332 views
Export Postgres table on remote server to CSV file on local machine?
I have access to DB on remote server where I can do only select command,
So, I can execute:
COPY products TO '/tmp/products.csv' DELIMITER ',';
But on that server I don't have permission to ...
0
votes
0answers
88 views
Materialized view for a yet-to-be-defined DBlink
In our product we have a main application with an oracle 11g DB and an optional module with another DB.
We want the two to communicate through a dblink and I was told to put some code for the ...
1
vote
1answer
100 views
Slow queries to remote PostgreSQL db
I am running a Drupal site that is backed by Postgres. This is my first time running something with Postgres; I come from the MySQL world.
For doing dev work on the site, I connect to a VPN and ...
1
vote
1answer
1k views
Server requested authentication method unknown to the client [mysql_old_password]
Warning: PDO::__construct(): The server requested authentication method unknown to the client [mysql_old_password]
SQLSTATE[HY000] [2054] The server requested authentication method unknown to the ...
2
votes
1answer
584 views
Cannot connect remotely to sql server 2012 instance using SSMS
I have installed sql server 2012 Express on a local network machine, then added a new login: "sqlUser" mapped to "database1", and configured the instance to accept the remote access with both Windows ...
0
votes
2answers
204 views
Remote database connection problem?
I have two systems with Windows XP. I have installed SQL Server 2005 on a system and tried to use SQL Server Management Studio Express on both to use the database.
I am able to use the database on ...
3
votes
1answer
516 views
DB2 Defining remote database alias
I'm using DB2 9.7.0.3 for AIX.
I want to select data from a remote database, also running DB2 9.7.0.3 for AIX, and insert it into the local database I'm connected to.
I believe the query for this ...
6
votes
3answers
598 views
Connect to SQL Server behind NAT from remote machine
The scenario is that this is a SQL Server behind a corporate firewall with your standard setup to allow only minimal outbound traffic and zero inbound. However, port 80/443 are open, per the usual ...
1
vote
1answer
121 views
Connection to MySQL Remotely
I want to connect to MySQL Server hosted on a Linux Machine from my Windows Machine using Command Prompt with the following command:
prompt>mysql -u root -p -h remote_hostname
Connections, ...
1
vote
0answers
186 views
Timeout on remote query over database link
We are trying to verify if a database link is up before inserting data into a remote database. We have no control over the remote database's behavior and status. We need to set a timeout on a query ...
0
votes
1answer
424 views
I would like to launch a pg_dump command from a remote computer
I would like to launch the command: pg_dump.exe -h 255.255.255.255 -p 5432 -U postgres -F p -a -v -f "test.db.dump" mydb from a remote computer. Both the database and the remote computer are under xp.
...
1
vote
1answer
2k views
Connecting remote MySQL database to local MySQL database?
I want to write PHP code to be embedded in a Drupal7 module.
I want to call a procedure which can copy newly generated data in the local MySQL database to a remote MySQL database.
When data is ...
0
votes
3answers
343 views
Can a RDBMS connect to a remote server, execute a select query and copy them into a local table just with SQL commands?
I'm sorry it may sound stupid but I've been wondering about how multiple databases are automated before the virtualization era. Can a DB Adminsitrator make a stored procedure to get data from a remote ...
1
vote
2answers
456 views
Remote to a remote oracle server and get running instances?
I need to make a shell script that takes a list of servers and and check the running instances then run sql script in each instance!
now I do not want it to ask me for a password!
it's redhat and ...
5
votes
4answers
2k views
Select statement takes long remotely due to long “client processing time”, but short locally
While connected to our production server (SQL2008. very powerful machine), this select statement takes 2 seconds, spitting back all fields (4 MB of data in total).
select top 30000 * from person ...
3
votes
2answers
5k views
How to add a user with access to a single view?
I'm working with MSSQL Server Management Studio 2008 and I need to expose a view to a third party for their data reconciliation. I have created the appropriate view but I'm having trouble creating a ...
3
votes
3answers
693 views
How to connect to remote PostgreSQL server
I wrote a web app, using java + spring+ PostgreSQL, which I have up and running.
I have a tester for my system and I want him to be able to connect to my database directly to check the result of ...
2
votes
2answers
139 views
Connecting to SQL Server 2008 on windows server 2008
Hell all
I am new to windows server 2008 and we are trying to transfer our website from hosting to virtual server.
I installed SQL Server 2008 Express edition and I did the things like opening port ...
2
votes
1answer
163 views
What do I need to sync a local site office SQL Server with the Head Office SQL Server
The company has a desktop application powered by SQL Server from the head office that is dependent on an internet connection to our remote sites. Usually when we move to a new site there is a good ...
2
votes
1answer
205 views
Remote Database Backup
I am attempting to find a reliable service that does remote MySQL Database Backup.
Price is no object, unless it's absurdly expensive. I understand this question doesn't really have an answer, and I ...
4
votes
1answer
971 views
Remote Debugging
I'm having an issue with remote debugging. I have a non-domain server and a non-domain client PC. The client PC can successfully connect to the server and the instance, and it even runs SSMS as the ...
