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 (1 Viewer)
- Thread starter CedarTree
- Start date
- Local time
- Today, 11:53
- Joined
- Jul 9, 2003
- Messages
- 16,282
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, 11:53
- Joined
- Jul 9, 2003
- Messages
- 16,282
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, 11:53
- Joined
- Jan 14, 2017
- Messages
- 18,225
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, 11:53
- Joined
- Jul 21, 2014
- Messages
- 2,280
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, 11:53
- Joined
- Sep 21, 2011
- Messages
- 14,303
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 (
Hosting Services Crafted with Care - SiteGround
Our web hosting is trusted by more than 3,000,000 domains for its top speed, unmatched security, 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, 11:53
- Joined
- Jul 21, 2014
- Messages
- 2,280
(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.
