Is it possible to make an ODBC connection to AWS EC2 (MYSQL) with MS ACCESS as the front end? If anyone knows how to do it, please let me know.
Answer # 1
It seems that you can do it by downloading /installing the ODBC driver and setting AWS EC2, etc., referring to the following article.
Here are excerpts and quotations from the table of contents of the article and prominent notes. See the article for details.
By using MySQL Connector /ODBC (Open DataBase Connectivity), you can connect to the MySQL database from Excel or Access.
However, please note that there are the following restrictions when using ODBC.
You cannot install multiple versions of ODBC on a single PC. Also, objects that use ODBC will only work with the version at the time of creation.
Visual c++ Redistributable Package Installation
Connector /ODBC uses run-time components to run c++ applications built using Visual Studio 2015.
The installer checks it at startup, so let's install it first.
Visual c++ Redistributable Package for Visual Studio 2015
There are x64 (64-bit version) and x86 (32-bit version) installers.
How to check how many bits of installed MS-OfficeOr I want to get the bit information of Office installed by the command
Connector /ODBC installation
MySQL :: MySQL ConnectorGo to and click Download to the right of the ODBC Driver for MySQL (Connector /ODBC).
There are 32-bit and 64-bit versions of the driver.
As before, download the same MS-Office architecture that you have installed, not the operating system architecture.
It is necessary to open the MYSQL port (3306), allow connection from the outside, and create an account for external connection.
Open MySQL port
You need to open port (3306) on both your EC2 instance and your Windows server.
Add MYSQL /Aurora to EC2 instance
Create a new inbound rule on the server
How to launch and publish Bitnami Redmine on AWS EC2 in just 30 minutes
Allow MySQL to connect from outside
Comment out "bind-address= 127.0.0.1" in my.ini (MySQL configuration file).
After saving the file, restart the Bitnami Redmine Stack service set.
Create an account for external connection
Start the Bitnami Redmine Stack command prompt and create an account for connecting to MySQL from the outside. Only "Select" was allowed for each database.
Confirmation of connection from home PC
Start the ODBC driver from Access etc. and check the connection.
For "TCP /IP Server", enter the public DNS or public IP. In "User /Password", enter the account you created earlier to connect from the outside. Click the [Test] button when you are finished.
- When I put a linked table in Microsoft Access from SQL Server and try to calculate it with a query, it overflows
- How to SSH into an AWS EC2 instance
- General Question on Building A Database
- Structure of database components
- python : incorrect SQL request
- sql : How to add a few lines to the table in access?
- I want to pass through the PATH of Minimagick (ImageMagick) with CRON on AWS EC2
- AccessVBA How to not open the form when opening another access from the main access