Mark Breen
marklbreen at gmail.com
Sun Jan 16 04:39:00 CST 2011
Hello John, I am using Hamachi - since you mentioned it here a few years ago - and Access and SQL server since Jan 2008 and it works the same as a VLan over Cisco hardware. No performance difference between Hamachi and CISCO, Thanks for the info on Hamachi in 2007/8 BTW :) HTH Mark On 15 January 2011 23:37, jwcolby <jwcolby at colbyconsulting.com> wrote: > I developed a SQL Server database, with perhaps 10-15 tables, populated a > few with just a handful of records, created an Access database and built a > few forms. My strategy is to do Access because I can do it quickly, but > link it to SQL Server, the run the FE on a remote computer over Hamachi. > > Tonight I went to a local Arby's to test the speed of the system. The > local Arby's has an open wifi, which using Speedtest.net tested 5 mbit down, > 1 mbit up - typical low end cable in my area. > > So I tried to use the system and... well... it took an extremely long time > to connect, if it connected at all. Access mostly timed out trying to log > on. SQL Server Management System would log on sometimes. Sometimes not. > Trying to hit it at the actual Hamachi IP address worked but took awhile. > 15 - 30 seconds to connect (I did not time it). > > To be honest I am puzzled. Google finds plenty of folks trying this, some > succeeding, most pretty slow. Remote desktop is plenty fast. > > From inside of my office, out across the internet via Hamachi I have done > things like file transfers etc (in the past). Remote desktop has always > been very speedy, but there isn't much needed for RD. > > I had really expected faster connections / operation. I really expected > SSMS to just work, pretty much at speed. It didn't. > > Sigh, back to the drawing boards. > -- > John W. Colby > www.ColbyConsulting.com > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > >