Francisco Tapia
fhtapia at gmail.com
Fri Oct 21 08:42:28 CDT 2011
John, I'm of course assuming you will continue using your db framework for the FE's. I cannot comment if the connection handling has improved with Access '07 / 2010?, but with the ADP's in 2000 and 2003 I had to go fully unbound so I could manage my connection objects so I would not get timed out. Given you are talking over the web, this is really where it comes into play, whenever I used a bound form over the interwebs I ended up with timeouts left and right...of course ymmv and this would definitely be something to investigate. if you are programming against web databases, this is where all that dba security stuff comes into play. You would absolutely NOT want any direct access to tables, (not because of your users) but if you've read any tech news sites the anonymous and other hacker groups use sql server injection methods to obtain data etc. if you have userid's that have blanket direct access to tables then the said intruder could easily dump the entire contents of your non-profit db's (ala sony). You will absolutely want to program everything through sprocs to minimize the impact. good luck. in our environment and with our host, we simply sent the host a copy of your db backup file which they restored on their end. Our db was supporting web front ends and in one minor case a MS Access 2003 DB FE. in the end we re-wrote it and re-deployed the application via the web and many of the easy features of Access have been lost forever to these users, but it was a business decision not to invest so much time in deploying Access FE's that could not easily be updated and suffered windows updates/office service pack hell. -Francisco http://bit.ly/sqlthis | Tsql and More... <http://db.tt/JeXURAx> On Thu, Oct 20, 2011 at 9:48 AM, jwcolby <jwcolby at colbyconsulting.com>wrote: > > Given the huge amounts if data your moving about what about performance. > Using the web databases? > > I do many different things. ;) > > This is not about my monster sql server, but rather about some almost tiny > databases used as the data store for access front ends for my non-profit > clients. It gets the data off of my servers and out to the web where it is > 1) Always available and 2) faster data pipe. > > > John W. Colby > Colby Consulting > > Reality is what refuses to go away > when you do not believe in it > > On 10/20/2011 12:31 PM, Martin Reid wrote: > >> John >> >> Given the huge amounts if data your moving about what about performance. >> Using the web databases? >> >> Martin >> >> Sent from my Windows Phone >> ______________________________**__ >> From: jwcolby >> Sent: 20/10/2011 16:42 >> To: Discussion concerning MS SQL Server >> Subject: Re: [dba-SQLServer] Using SQL Server through my web site >> >> I selected my Web host specifically to allow me to have a sql server >> database. What I did not >> examine closely is how many databases or how much they cost. My current >> ISP only allows me one >> MSSQL and one MySQL database which is really pretty silly. I can purchase >> more, but even then only >> up to 3 maximum which is even more silly, and those extra only come with >> package upgrades which cost >> a lot more money. >> >> I still want to figure this out just to see what the performance is like >> and solve the technical >> problems of using them for the future. >> >> John W. Colby >> Colby Consulting >> >> Reality is what refuses to go away >> when you do not believe in it >> >> On 10/20/2011 10:44 AM, Doug Steele wrote: >> >>> John, I just got this link from ZDNet - it might interest you: >>> >>> http://whitepapers.zdnet.com/**abstract.aspx?docid=3422473&** >>> promo=550&trial=25439928&tag=**nl.e550<http://whitepapers.zdnet.com/abstract.aspx?docid=3422473&promo=550&trial=25439928&tag=nl.e550> >>> >>> Doug >>> >>> On Thu, Oct 20, 2011 at 12:33 AM, Michael Maddison< >>> michael at ddisolutions.com.au> wrote: >>> >>> Hi JC, >>>> >>>> I've done it but I don't do it often. >>>> IIRC Our host requires us to upload a backup of the db. >>>> We let them know via email the db is ready, including user details and >>>> they have it set up in no time. YMMV. >>>> You should be able to get the IP via your Plesk (or similar) terminal >>>> and create a connection from Enterprise manager or use the built in >>>> tools (Plesk). >>>> Your host login should have admin privs over your database only. >>>> Name the db well as it will be sitting with many others. >>>> Never really got the backup tools to work with my Host so I email them >>>> to drop a backup into a folder I created and I ftp it back here. >>>> Got a feeling there will be issues with the user account, you may need >>>> to drop and recreate the login. >>>> Oh yeah, probably doesn't need to be said but I don't think you can use >>>> Windows Authentication. >>>> >>>> Good luck >>>> >>>> Michael M >>>> >>>> >>>> -----Original Message----- >>>> From: dba-sqlserver-bounces@**databaseadvisors.com<dba-sqlserver-bounces at databaseadvisors.com> >>>> [mailto:dba-sqlserver-bounces@**databaseadvisors.com<dba-sqlserver-bounces at databaseadvisors.com>] >>>> On Behalf Of jwcolby >>>> Sent: Wednesday, 19 October 2011 11:02 PM >>>> To: Sqlserver-Dba >>>> Subject: [dba-SQLServer] Using SQL Server through my web site >>>> >>>> I buy a web hosting plan where I have the ability to build sql server >>>> databases though my web account. I have never used this but I need to >>>> do so now. I haven't a clue how to get started. I have written an >>>> email to the hosting company (PowerDNN) asking them for documentation on >>>> "how to" >>>> but I am wondering if any of you guys do this? >>>> >>>> I have built a bunch of SQL Server back end databases for Access FEs. >>>> this is all working well but the databases are running on a VM on my >>>> server at my home office which has obvious limitations. I am hoping >>>> that I can push these databases out to my web host and reconnect the FEs >>>> to those databases out on the web. That would make scaling issues go >>>> away. >>>> >>>> Is anyone doing this? Any tricks / tips / cautions etc? >>>> >>>> -- >>>> John W. Colby >>>> Colby Consulting >>>> >>>> Reality is what refuses to go away >>>> when you do not believe in it >>>> ______________________________**_________________ >>>> dba-SQLServer mailing list >>>> dba-SQLServer@**databaseadvisors.com<dba-SQLServer at databaseadvisors.com> >>>> http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> >>>> http://www.databaseadvisors.**com <http://www.databaseadvisors.com> >>>> >>>> >>>> ----- >>>> No virus found in this message. >>>> Checked by AVG - www.avg.com<http://www.avg.com**> >>>> Version: 10.0.1411 / Virus Database: 1522/3962 - Release Date: 10/19/11 >>>> >>>> ______________________________**_________________ >>>> dba-SQLServer mailing list >>>> dba-SQLServer@**databaseadvisors.com<dba-SQLServer at databaseadvisors.com> >>>> http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> >>>> http://www.databaseadvisors.**com <http://www.databaseadvisors.com> >>>> >>>> >>>> ______________________________**_________________ >>> dba-SQLServer mailing list >>> dba-SQLServer@**databaseadvisors.com<dba-SQLServer at databaseadvisors.com> >>> http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> >>> http://www.databaseadvisors.**com <http://www.databaseadvisors.com> >>> >>> >>> ______________________________**_________________ >> dba-SQLServer mailing list >> dba-SQLServer@**databaseadvisors.com <dba-SQLServer at databaseadvisors.com> >> http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> >> http://www.databaseadvisors.**com <http://www.databaseadvisors.com> >> >> ______________________________**_________________ >> dba-SQLServer mailing list >> dba-SQLServer@**databaseadvisors.com <dba-SQLServer at databaseadvisors.com> >> http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> >> http://www.databaseadvisors.**com <http://www.databaseadvisors.com> >> >> >> ______________________________**_________________ > dba-SQLServer mailing list > dba-SQLServer@**databaseadvisors.com <dba-SQLServer at databaseadvisors.com> > http://databaseadvisors.com/**mailman/listinfo/dba-sqlserver<http://databaseadvisors.com/mailman/listinfo/dba-sqlserver> > http://www.databaseadvisors.**com <http://www.databaseadvisors.com> > >