I have a VB6 SP6 MDAC 2.8 application talking to SQL Server 2000. 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. 2 2002
David C. Barber (da***@NOSPAMdb arber.com) writes: 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.
Sounds indeed very strange, and I suspect that is is not really SQL
Server problem. But I don't really have a clue.
The one thing I can think off is that loading of the EXE across the
write uses up the network bandwidth. But for 30 seconds? I don't really
believe in that myself.
What does your connection string look like?
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
"David C. Barber" <da***@NOSPAMdb arber.com> wrote in message
news:a8******** ************@co mcast.com... I have a VB6 SP6 MDAC 2.8 application talking to SQL Server 2000. 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.
Just a guess ... could it be an authentication problem? Do you specify the
username and account to use explicitly in the application or do you rely on
windows authentication. If you are using windows authentication then as a
test try explicitly using a username and password and see if that helps. If
that works then I'm not sure where you go from there but it may give you a
clue.
Brian www.cryer.co.uk/brian This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Steven |
last post by:
hi all
i'm primarily a ASP web developer, so i'm not sure if i can do this or not.
i want to allow client's on my site to run a local version of the site off
their laptop. i want to give the user an option on the site that grabs all
the ASP pages, extracts just their records for MS SQL and exports to MS
Access, then packs into a zip file for download. no problem with any of the
steps so far. what should happend next is the user runs my...
|
by: David C. Barber |
last post by:
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...
|
by: Wade |
last post by:
I would like to install the .Net 1.1 framework on a Web Server running W2K
to be able to run ASP.NET files, but I'm not sure where to find the files I
need for the .Net framework.
I have ".NET Framework 1.1 Service Pack 1" (NDP1.1sp1-KB867460-X86.exe) and
"ASP.NET Security Update for .NET Framework 1.1 SP1"
(NDP1.1sp1-KB886903-X86.exe).
The SP1 will not install unless 1.1 is already installed (I thought that SP1
was the whole 1.1...
|
by: Hrvoje Vrbanc |
last post by:
Hello all!
What would be the most convenient way to deploy a locally developed ASP.NET
application on a remote server that has .NET Framework (correct version)
installed but I don't have any control over it?
I tried simply copying files, then I created a Web Setup project locally and
built it. I have then installed the application locally from the EXE and MSI
files and then transferred the newly created files to a remote server by...
|
by: Steven Babb |
last post by:
I have taken over responsibilities for a .NET app that runs on IIS Server
locally and has a user that has a local Access database that launches the app
from a URL. They are receiveing the following error:
Server Application Unavailable
The web application you are attempting to access on this web server is
currently unavailable. Please hit the "Refresh" button in your web browser
to retry your request.
Administrator Note: An error...
| |
by: Steve Franks |
last post by:
I am using VS.NET 2005 beta 2. When I run my project locally using the
default ASP.NET Development Web Server it runs using a root address like
this:
http://localhost:11243/testsite/
However when I deploy to a remote test server running real IIS, the real
root of my application becomes:
http://localhost/
What I want to do is have it so that on my local machine the asp.net dev
|
by: Paul |
last post by:
Anyone know where I can find some good resources to help us choose between
SQL and Oracle ( Progress Openedge as well ) . Any comments on what you
would choose ?? We are creating a new Warehouse Management System which wil
manage our very large inventory.
Anyway comments suggestions welcome
Thanks
Paul
|
by: PAHSTeacher |
last post by:
I am using VB in VWD 2005 to write a web application.
I have stored my code for several custom VB classes in the App_Code folder.
When I run my application locally from VWD it runs fine.
When I run the Application from the web server, I get an error from any code from my WebpageName.axpx.vb files that use my class code.
For example, lines such as
Dim MO as new MyObject
|
by: =?Utf-8?B?QWRyaWFuTW9ycmlz?= |
last post by:
Hello!
I'm trying to copy a file from another computer on the network that I do not
have permission with my current logon details to access.
If I open the folder using the Windows file manager with the path "\\
192.168.2.2\temp" (where temp is a shared directory on server \\192.168.2.2),
windows prompts for a User Name and password of a user who has permission on
that computer to access that directory. If I enter valid details, the...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |