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

They show "unlimited" for SQL Server databases but what is the real deal?  I can't find a cost / mb 
stored anywhere.

John W. Colby
Colby Consulting

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

On 10/24/2012 12:40 PM, Doug Murphy wrote:
> 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
>