Re: Very strange behavior of SQLServer with connection from CGI

From: Mattia (matt_at_none.com)
Date: 02/15/05 

Date: Tue, 15 Feb 2005 09:15:18 +0100

I understand, but the funny thing is that when I run the program just
executing it, it works everytime.
The problem is when I call it from the web server (on the same machine
where I run it by executing it).

Do you have an idea why when I run the software locally, launching the
exe, it originates only TCP/IP packets, and when I run it through the
webserver as a cgi it originates this UDP packet?

I mean, the oledb string is exactly the same.
It is because the user that executes the program the first time is the
local user, and the second time (when through the webserver) the user
is the INET user?

I'm sure the solution is there.

Thanks,
Mattia

On Mon, 14 Feb 2005 14:07:51 -0500, "Geoff N. Hiten"
<SRDBA@Careerbuilder.com> wrote:

>Not sure on the whole connection/reconnection issue. You may have an MDAC
>or connection pooling issue. Make sure your client systems are up to date
>with the latest MDAC. Older MDAC versions have problems with named instance
>resolution. Clustered instances look like named instances from a client
>perspective, otherwise they are identical to a standard SQL server
>implementation.
>
>You specify ports with xxx.xxx.xxx.xxx,portnum.
>
>You may also be running into a windows security issue. Windows attempts to
>create a SSPI session for windows networking if there is a common security
>context when a socket is created. This attempt and failure may also be
>causing your problems.
>
>Finally there could be DNS issues, but that seems very unlikely since you do
>get one good connection..

Relevant Pages

  • Re: Very strange behavior of SQLServer with connection from CGI
    ... executing it, it works everytime. ... Older MDAC versions have problems with named instance ... >You may also be running into a windows security issue. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Very strange behavior of SQLServer with connection from CGI
    ... executing it, it works everytime. ... Older MDAC versions have problems with named instance ... >You may also be running into a windows security issue. ...
    (microsoft.public.sqlserver.security)
  • [Full-disclosure] Acunetix WVS 5 improper file path handling (EoP)
    ... Acunetix WVS 5 improper file path handling ... Tested on: Microsoft Windows 2000 SP4 ... This attack is commonly referred to as the ... executing user but could also be launched with elevated ...
    (Full-Disclosure)
  • Re: DOS command
    ... What you think is executing the program ... Real Dos Prompt not for Window's Command Prompt. ... another to run within from Windows as you run other programs. ...
    (microsoft.public.windowsxp.general)
  • Re: Simple WinForm ( Not Responding ) Refesh Issue C# 2.0
    ... Windows is event driven, which all the little things you see on the user ... interface is done by firing a whole bunch of various events. ... regular application is also single threaded, which means executing event ... in a simple loop where each turn does not take much time. ...
    (microsoft.public.dotnet.languages.csharp)