Questions tagged [remote]
The remote tag has no summary.
135 questions
-2 votes
1 answer
30 views
Why am I getting a syntax error running the same code via openrecordset vs. direct connection to remote server
I've got two queries i need to run via remote server connection. They run fine if I run them by connect to the remote server FIRST, but if i use the openrecordset to run it from the command line, and ...
0 votes
0 answers
101 views
Postgresql: Does execute() or fetch() download result from remote?
When getting a query result from a remote server, does the execution of the query transmit the result to the local machine, or is it buffered on remote and only downloaded when fetching the result? ...
- 101
1 vote
0 answers
251 views
what permissions does user need to have to use linked server and its default remote user mapping
i have some linkedserver and for it created default maping that mapping list is empty and all goes thrue 'Be made using this seciurity context' and this works fine - i can querry this linked from any ...
- 113
2 votes
3 answers
106 views
How do I block all IP addresses from connecting remotely to Cassandra?
I want access to remote cassandra with one ip address. how can I change cassandra.yaml to block all ip address except ip that I want to connect? Can I do by cassandra.yaml ?
- 41
1 vote
1 answer
425 views
Enable remote access to database via proxy server
What's the most painless way to create something like a proxy server so that my dev team can access a database from anywhere? The server in question is a managed MongoDB database. Currently, I am just ...
- 111
1 vote
1 answer
1k views
How to set up MySQL remote hosts IP address for users with dynamic IP's
Background I need remote access from my Delphi PC application to a MySQL database hosted on a shared server at my ISP. This DB is not associated with any web site. All there is on my ISP account is ...
- 207
0 votes
1 answer
119 views
Different response time because it does not use the indexes created with the same query and same tables from the web server to the Oracle database
I have a database with Oracle 12c (12.1), where when making a query locally and even from TOAD or another remote tool, it returns the response in milliseconds, reviewing the execution plan I can see ...
- 169
0 votes
1 answer
2k views
ORA-03114 Unable to connect to remote Oracle database
I have an Oracle Database installed on Oracle Linux Server which I'm trying to connect to from my PC. I have configured the listener in the following way [oracle@ol8ngs1 ~]$ lsnrctl status LSNRCTL ...
0 votes
1 answer
434 views
Your database files were created by PostgreSQL version 13 [closed]
OS is openSUSE Tumbleweed. Previously I had PostgreSQL 13 installed. I just removed it by: > sudo zypper rm 'postgres*' > sudo zypper rr PostgreSQL > sudo rm -rf /usr/local/var/postgres ...
- 99
0 votes
1 answer
4k views
MariaDB remote access ERROR 1045 (28000): Access denied
MariaDB 10.3.27. Debian 10 Buster. I've followed the instructions to grant remote access to a user to my remote MariaDB server: Edited /etc/mysql/my.cnf: [mysqld] #skip-networking #bind-address = &...
1 vote
1 answer
1k views
MariaDB bound to 0.0.0.0, but doesn't appear to be listening to all IPs?
My MariaDB server accepts connections at port 43210 without problems on the public IP address of, we'll say, 123.123.123.123 on eth0. This is on an Ubuntu 18.04 server that also has 192.168.1.10 ...
- 111
0 votes
1 answer
1k views
Changes to server configuration option remote access are not supported in SQL Database Managed Instances
Having just set up our new SQL Server Managed Instance, restored a sample database for testing, and run Azure's vulnerability assessment, it produces this high risk finding: VA2120 - Features that ...
- 860
-1 votes
1 answer
956 views
Connect to remote sql server is possible only by ipaddress\sqlinstance,portnumber?
I've configured a remote Sql server on host machine. I have performed the follwing steps : Under Remote Server Connections, check the box against "Allow remote connections to this server". ...
- 71
0 votes
3 answers
549 views
Allow user to create databases on server and to see only the databases that are created by him, without creating login first
I want to implement the following use case using C# application and MS SQL Server Express 2014. I have a centralized database server in which there are already created some database (which have the ...
- 71
0 votes
1 answer
1k views
Making an Oracle XE instance network wide available
Im fairly new to Oracle so please bear with me. I want to install an Oracle 18c XE DBMS on a server and access it's databases remotely via DBeaver. First of all there is some confusion on which client ...
- 111