Doug Murphy
dw-murphy at cox.net
Wed Oct 24 15:43:08 CDT 2012
Have not run into a limit. The web sites and databases we run on Arvixe aren't large but they do advertise no limit on the number of databases. So far I have only created 3 sql server db on one hosting account. No problems. Doug -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Wednesday, October 24, 2012 10:30 AM To: Access Developers discussion and problem solving Subject: Re: [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 > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com