[AccessD] MySQL db on Arvixe linux server

[Doug Murphy]

Can't speak for all hosts, but the few I am familiar with seem to allow it
on Windows servers. Maybe Windows is so bad with security they don't bother.
You can do this on Azure also, connect to a SQL server db that is. They do
allow you to set which IP addresses can connect. But if you don't have a
fixed IP that isn't very helpful.

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

It's not MySql or Linex Servers.

It's a matter of basic security.   Web hosting organisations need to lock
down their systems 
very tightly because they are under constant attack using every newly
identified security bug in their environment.  

I'm surprised that your Windows host provider has opened MyDQL server to
remote connection from outside their environment, very few do so.

Yes you can use ADO with the ODBC driver, but again, only if the DB engine
accepts the connection.

FWIW, You should do the same with any corporate SQL Server installation
inside a LAN for secruity reasons - configure it to only allow connections
from the same sub-net.

--
Stuart

On 8 Oct 2015 at 8:34, Doug Murphy wrote:

> 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
> 
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 



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