Hello - we have an Access database and want to begin to migrate the data to MySQL for others to access the data (read-only for now) using a web portal. Looking for a connection string to use in VBA to link the tables in MySQL to Access. The MySQL database is hosted on siteground if that helps. Thanks!!!
Connection string for MySQL
- Thread starter CedarTree
- Start date
- Local time
- Today, 00:01
- Joined
- Jul 9, 2003
- Messages
- 16,850
Not sure about the VBA option, but this might be a start:-
And:-
How to Connect to Your MySQL Database Remotely Using ODBC - WebHostingHero.org
This tutorial explains how to setup an ODBC connection to a remote MySQL database.
webhostinghero.org
And:-
- Local time
- Today, 00:01
- Joined
- Jul 9, 2003
- Messages
- 16,850
And this might provide a route for creating the VBA code:-
Don't know for sure, haven't read it.
Don't know for sure, haven't read it.
Okay thanks will look into…And this might provide a route for creating the VBA code:-
Don't know for sure, haven't read it.
isladogs
MVP / VIP
- Local time
- Today, 00:01
- Joined
- Jan 14, 2017
- Messages
- 18,510
MySQL connection strings - ConnectionStrings.com
Connection strings for MySQL. Connect using MySqlConnection, MySQLDriverCS, SevenObjects MySqlClient, Devarts MySqlConnection, MySQLProv.
www.connectionstrings.com
cheekybuddha
AWF VIP
- Local time
- Today, 00:01
- Joined
- Jul 21, 2014
- Messages
- 2,651
What is siteground? Are they just a webhost, or do you have a VPS with them?
Do they allow direct remote access to the MySQL server?
If not, do they allow SSH access to your VPS instance?
If they are just a webhost then it is unlikely you will be able to access the MySQL instance from outside your webserver.
Unless you can access them directly there is no point in trying to work out the connection string.
In this case you would probably have to set up a web API and use that for your db access. Otherwise your probably stuck with phpMyAdmin (
)
Gasman
Enthusiastic Amateur
- Local time
- Today, 00:01
- Joined
- Sep 21, 2011
- Messages
- 15,630
What is siteground? Are they just a webhost, or do you have a VPS with them?
Do they allow direct remote access to the MySQL server?
If not, do they allow SSH access to your VPS instance?
If they are just a webhost then it is unlikely you will be able to access the MySQL instance from outside your webserver.
Unless you can access them directly there is no point in trying to work out the connection string.
In this case you would probably have to set up a web API and use that for your db access. Otherwise your probably stuck with phpMyAdmin (
Web Hosting Perfected - SiteGround
Web hosting services helping 3,000,000+ domains thrive online with ultrafast speed, unmatched security, and 24/7 fast and expert support! Get started now!
www.siteground.co.uk
My bosses use them as well, but just for hosting and email.
We moves from TSOHost who I thought were pretty good.
cheekybuddha
AWF VIP
- Local time
- Today, 00:01
- Joined
- Jul 21, 2014
- Messages
- 2,651
(even via SSH ?)
This is a key question.
The answer is: Not by default. You must explicitly grant remote access to individual IP addresses first.
