jwcolby
jwcolby at colbyconsulting.com
Sun Jan 16 07:40:56 CST 2011
Are you running this over the internet I assume - over Hamachi wold imply that. What are your connection speeds at either end using speedtest.net? John W. Colby www.ColbyConsulting.com On 1/16/2011 5:39 AM, Mark Breen wrote: > 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 >> >> > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > >