Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.lang.visual.basic    |    MS Visual Basic discussions, NOT dot-net    |    10,840 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 9,573 of 10,840    |
|    David C. Barber to All    |
|    VB6/SQL Server application runs locally,    |
|    19 Jun 05 15:51:47    |
      From: david@NOSPAMdbarber.com              I have a VB6 SP6 MDAC 2.8 application talking to SQL Server. Once I've       installed this application on my local machine I have been able to move the       .exe file to a file server and it runs just fine from there for all my local       users. This is very handy for updating the application without having to       reinstall it on each user's machine each time. They just use a shortcut       pointing to the file server .exe file              My problem has become that we have some users at remote locations that VPN       into our network who also want to use this application. When it's installed       locally on their machines, or even on file servers at their locations,       everything works fine. However, when they run the .exe off of my file       server the SQL Server connections times out on the initial connection open       after the default 30 seconds every time. Run from their own desktops or       file servers it connects within 2 seconds every time. This is on both       Windows 2000 and XP Pro machines. Even when I tell the shortcut to use       their local drive for the working directory the same problem happens.              This goes against everything I've seen with server-based files for 15 years.       Once a file is loaded in the computer for execution, why does it matter       where it came from? What "baggage" can an .exe file carry with it that will       cause it to not execute when hosted on one server, but run just fine from       the desktop or another, closer server? The only known difference is that       the connection speed is much better when I run it locally here to that file       server.              Help.              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca