The tag has no wiki summary.

learn more… | top users | synonyms

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
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 ...
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
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
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 ...