Connection to SQL Server 7 using MDAC 2.6

Hi All

I have a really nagging problem with an app we developed a while ago.
Whilst running the exe from a share in a small network with the SQL server
in the same network, using a simple switch the clients run fine and connect
to the server first time.

When the server is put behind a firewall, port 1433 opened and the exe now
on another server on a routed network, the connection times out first time
and then connects immediately the second time. We have the relevant DNS
setup in our DNS server and have added the details to the local host file.
We have even added the client using the client network utility.

Although it connects retrieving rows from the server is slow. When the
local exe file is copied to the local machine the problem disappears.

Does anyone know what causes this behaviour so we can modify the application
or setup.

Any help would be greatly welcomed.
Thanks

Phil


.

Relevant Pages

  • Re: Who is using the EXE
    ... Running applications across a network is a bad idea for several reasons, ... The normal solution is to write a small launcher program which is installed ... if it finds a newer one on the server it copies it over the local ... I developed an application using VB6, placed the exe in a shared ...
    (microsoft.public.vb.general.discussion)
  • Re: XP x 3+clipper=SLOW
    ... maybe a little when loading exe. ... I had the problem on "server" when i used mapped drive, ... it sounds like there is something wrong with how the network is ... Clipper applications and similar file sharing apps are run. ...
    (comp.lang.clipper)
  • long logon
    ... server on all of the clients and that resolved it the first time. ... Definition Detection) and then completely remove it from the server ... scanned the network during the logon process with Ether Peek and its not ...
    (microsoft.public.windows.server.sbs)
  • Re: Application caching
    ... Microsoft MVP - Terminal Services ... We have set up Server 2008 with Terminal Server for about 10 users. ... All those users use the same application (a single exe from a network ...
    (microsoft.public.windows.terminal_services)
  • Network Printing problems, 1.st time ok, 2.nd not printing
    ... we have 20 user with XP Pro, working on server through RDC ... on network printer in short time. ... there is "printing-error". ... First time ok, right after that everything stops and in the ...
    (microsoft.public.win2000.printing)
Quantcast