Doug Murphy
dw-murphy at cox.net
Wed Oct 24 17:53:04 CDT 2012
I have two DotNetNuke sites running on Arvixe, different accounts. We have another on PowerDNN. Arvixe runs DNN just as well as PowerDNN and is much cheaper. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Wednesday, October 24, 2012 3:14 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Arvixe web hosting - was Free Cloud based MySQL Do you use one of their supported CMS? I have been with DNN for so long I haven't a clue what I should use to build my actual site but I need to get there. 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