[AccessD] MySQL db on Arvixe linux server

[Doug Murphy]

Thanks Stuart,

Is it possible to connect using ADO and perform operations programmatically?
I am not clear on why connections are limited on Linux servers. It seems the
MySql odbc driver likes to connect on port 3306. Is that typically blocked
on Linux servers. When I have a MySql database on a Windows shared hosting
server I can connect with ADO. The application I am looking at is simple and
has only one main table. It would be easy to keep Access on the client
computer synchronized with the server db if we can connect.

Thanks

Doug

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Stuart McLachlan
Sent: Wednesday, October 07, 2015 10:23 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] MySQL db on Arvixe linux server

I've changed the subject back to the appropriate one.

If it's on a shared hosting account, you almost certainly will not be able
to access it from Access.

The best I've ever managed in that situation is to export the data locally
at one end as plain text, compress it, upload/download it via FTP ,
uncompress and then import at the other end.  
It's a lot of work.


Still, it's worth contacting the hosting provider and checking whether you
can have remote 
access.

-- 
Stuart

On 7 Oct 2015 at 22:11, doug wrote:

> Jim,
> 
> I am guessing not. The db is on a shared hosting account. 
> 
> -------- Original message --------
> From: Jim Lawrence <accessd at shaw.ca> 
> Date:10/07/2015  9:41 PM  (GMT-08:00) 
> To: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com> Subject: Re: [AccessD] Stored Procedure
> as Rowsource for Chart 
> 
> Hi David:
> 
> Here is an overly simplified Youtube vid of connecting MS Access to a
> MySQL DB: https://www.youtube.com/watch?v=F06hvR6ksh4
> 
> Here is a link to some comprehensive lists of database to database
> connection string: http://www.connectionstrings.com and
> http://www.dofactory.com/reference/connection-strings and
> http://www.carlprothman.net/Default.aspx?tabid=90
> 
> Aside: If you use the standard method of generating an ODBC connect,
> the file created can be stripped down to a basic string by changing
> the file's extension to ".txt" and using the resultant connection text
> string directly within your Access connection module.
> 
> Do you have direct root access to the MySQL DB that you will be using?
> 
> 
> HTH
> Jim 
> 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com