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

John,

<<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? >>

  That would be the case as a DNS entry just translates to an IP anyway.
The advantage to using DNS is that you can swap out servers, which have
different IP's, and nothing changes for the end user.  This is true with
anything (HTML, FTP, TELNET, AS2, etc)

Jim.
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Wednesday, October 24, 2012 11: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