[AccessD] Arvixe web hosting - was Free Cloud based MySQL

John,

Can't speak for Robert but I use Arvixe for a number of SQL Server databases
and connect without specifying the port. SQL Server Management studio may
have a default but I don't mess with it. When connecting from Access I put
the connection in the table def and relink every time the database opens. My
connection is of the format shown below.

ODBC;DRIVER=SQL Server Native Client
10.0;SERVER=poppy.arvixe.com;APP=MicrosoftR WindowsR Operating
System;DATABASE=DATABASENAME;UID=USERNAME;PWD=PASSWORD;

I have found Arvixe tech support to be excellent and when called have given
great assistance.

Doug

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Wednesday, October 24, 2012 8:21 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Arvixe web hosting - was Free Cloud based MySQL

Robert,

I have databases that I am managing on my own servers using Hamachi.  I
would like to get rid of this and do it out on the internet.  What I need to
know from you is how do you manage more than one database?  Using Hamachi I
hit an IP address which is literally a number, with that ,1433 at the end.

On my server I have multiple databases, each of which have users set up by
me, with passwords etc and inside of SQL Server those users can "see" only a
single database.  Thus if I come in as UserXYZ I can get at DatabaseXYZ and
if I come in as UserABC I can only get at DatabaseABC.

I assume that If I go with this company the same methodology is going to
work except that the IP will now be ColbyConsulting.com,1433?  BTW it is
possible to change that default port to another port number to help defend
against probing of that port.  I am not sure how much it helps.

What CMS do you use for the web side of things?

John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it

On 9/28/2012 1:13 PM, Robert Stewart wrote:
> I use Arvixe for hosting.  I can admin it through SSMS (SQL Server.
> I can also access it with MS Access if I add ,1433 to the end of the 
> ODBC server name.
>
> 1433 is the normal port for SQL Server.
>
> While it is not free, It is only about 200 for 2 years.
>

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