I´d like to know if it is possible to connect to my rds database from my local machine (windows) using windows odbc data source. My problem is that I use SSH and i don´t know how can I input the parameters in odbc data source. I need this type of connection because I want to access RDS via vba excel. My database is Postgresql.
DNS ODBC Driver configuration for SSH RDS
683 Views Asked by Fabio Takahashi At
2
There are 2 best solutions below
0
Devart
On
Indeed, you can use Devart ODBC Driver for PostgreSQL to access data in the specified environment. Please check additional information in the documentation: https://docs.devart.com/odbc/postgresql/ssh.htm
Related Questions in POSTGRESQL
- Only the first SQL script gets executed inside Docker Postgres container
- Compare fields in two tables
- Hibernate ClobJdbcType bindings: what are the diferences?
- Postgres && statement Error in Mybatis Mapper?
- Can this query be optimized? (Choosing a random row to insert, that excludes previously inserted Rows)
- Connection terminated unexpectedly while performing multi row insert using pg-promise
- Processing multiple forms in nodejs and postgresql
- How to copy data from SQLite to postgreSQL?
- PGAdmin4 configured behind a reverse proxy but unable to connect to Postgresql server
- Updates to pgsodium encrypted values don't use specified key_id
- Connecting to Postgres running in a Docker container using psql
- Can't connect to local postgresql server from my docker container
- Django Arrayfield migration to cloud sql (Postgresql) not creating the column
- Get list of matching keywords for each post
- docker-compose can't reset postgresql database
Related Questions in SSH
- Is there a way to prevent vscode from forwarding ssh agent to remote dev container?
- problem to push files on a repository git
- How to connect to ssh server with domain name
- GIT SKIP EMPTY DIRECTORIES
- Share files from the server without data or internet usage
- Is it possible for `sudo` to fail temporarily with the correct password? Hacking suspected
- How to add a second ssh public key to authorized_keys file in the server?
- Termux: Different scrolling behaviour after "screen"-command
- Remote debugging via SSH Tunnel
- Why can I not login to a new linux system (amazon linux 2023) from an old one (CentOS 6)
- Can't establish ssh connection to IP address but can to git
- Using Maven to feed minikube on a VM
- Connect ssh to cisco switch with ansible
- PowerShell Command via SSH
- How to automate an SSH login with a batch file?
Related Questions in ODBC
- Snowflake ODBC xdg-open Missing X server or $DISPLAY
- Stata + ODBC driver requires login too often
- mysql with odbc to ms access - runtime error 3146 (odbc call failed)
- Informix Golang client package
- Access won't open past the splash screen
- Can't make sense why ConnectionError: Data source name not found and no default driver specified
- Issue interacting via dbplyr with remote SQL tables probably since odbc or DBI or dbplyr package update
- CentOS/RHEL download dependencies
- Error connecting to SQL Server using pyodbc: Data source name not found and no default driver specified
- How to Implement Multi-Parameter Queries in SSRS Report Builder with Databricks ODBC?
- C++ Poco ODBC issue with setting char type in sql
- Firbird DB multiple connections problem using BDE+ODBC connection
- SQL Server configuration giving [ODBC Driver 17 for SQL Server TCP Provider: Error code 0x2746
- connecting to postgres using ODBC windows with gssencmode not working
- Providex ODBC CONCAT issue
Related Questions in RDS
- RDS table opened in RStudio. How do I find field Names?
- show timezone - PostgreSQL 11 - different value depending on client?
- Problem connecting to RDS from EC2 instance: Is the server running on host/accepting TCP/IP connections on port 5432?
- Why master user does not have all privileges on all tables in RDS postgres?
- ERROR 1064 (42000) Delete statement in RDS
- I cant connect to AWS RDS using Postgres
- RDs format weights more than csv one for the same dataframe
- Postgres select query with exclusice lock performance issue
- Postgresql ERROR: could not establish connection
- cannot connect to RDS SQL server through powershell
- Trigger is not working in Amazon Aurora when executing Liquibase changeLog
- RDS Gateway > Update Resource authorization policies with Powershell
- Ad network traffic and Lambda invocation mismatch
- Can no longer connect to RDS MySQL after upgrading to Ubuntu 20.04 (rails)
- How to set up connection to AWS rds via ssh to server from python?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
If you have a publicly accessible database (not recommended by AWS) and your IP address is allowed, then the normal ODBC connection will work.
By the sound of your setup, you have a private database. In which case, your options are:
Devart (https://www.devart.com/odbc/postgresql/) and Cdata (https://cdn.cdata.com/help/FPG/odbc/RSBPostgresql_c_SSH.htm) both have ODBC drivers that support SSH tunnelling.
Neither are free.