home bbs files messages ]

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