Very strange behavior of SQLServer with connection from CGI

mdurliSPAMFILTER_at_hotmail.com
Date: 02/14/05 

Date: Mon, 14 Feb 2005 17:12:41 GMT

Hello,
I developed a win32 .exe CGI that connects to a clustered SQLServer to
report some data.
The software is written with Borland C++Builder.
This is the oledb string:
Name=Provider=SQLOLEDB;Password=xxx;Persist Security Info=True;User
ID=xxxx;Data Source=xxxxx;Initial Catalog=xxxxx;Network
Library=dbmssocn

It suddendly stopped working on my customer network, so I made some
test and I verivied that the problem is on the connection with
SQLServer: my test program just opens a connection, closes it and
exits, reporting in a log file if the open was successful or failed.

If I run the program locally, just launching it, no problem, it works.
I can run it mutilple time continuosly and is connects every time.

If I run the program through my webserver, as a CGI that's how it is
supposed to work (http:\\localhost\scripts\connect.exe), it connects
the first time, and then I have to wait 40 seconds to connect again
successfully, or it fails.

If I try against MY sqlserver on my laptop or on my network no 40 sec
problems, but on my customer network, with THEIR SQLServer , if I try
to connect from their webserver, or from my laptop webserver, I have
this 40sec problem.

I analyzed the network traffic, and I discovered that when I run my
test program locally it originates only TCP/IP packets, and SQLServer
answers only with TCP/IP.
But when I use it from the webserver as a CGI, it originates an UDP
packet, then SQL answers with another UDP packet, and then they
communicate over TCP/IP.
This when it works: the second time my program continues to send the
UDP packet, but it receives no answer, and fails the communication.

I can only say that:
- we haven't touched the program for months, and it really stopped
working suddendly, so I suspect that something in my customer netowrk
has changed
- I tried many different OLEDB strings, disabling connection pooling
and all the services, calling the SQLServer by name or IP...
- the problem can't be related to my program, because now is really
just an oledb connection test

Anyone have an idea?

Thank you very much,
Mattia

Relevant Pages

  • Very strange behavior of SQLServer with connection from CGI
    ... I developed a win32 .exe CGI that connects to a clustered SQLServer to ... UDP packet, but it receives no answer, and fails the communication. ... I tried many different OLEDB strings, ...
    (microsoft.public.sqlserver.security)
  • Very strange behavior of SQLServer with connection from CGI
    ... I developed a win32 .exe CGI that connects to a clustered SQLServer to ... UDP packet, but it receives no answer, and fails the communication. ... I tried many different OLEDB strings, ...
    (microsoft.public.sqlserver.connect)
  • Re: What is the difference between sqlClient and OleDb ?..
    ... SqlClient can only be used with SqlServer. ... OdbcClient are libraries that can be used to access any oledb and odbc ... OleDb is a more generic/abstract interface which means that it can be ...
    (microsoft.public.dotnet.framework.adonet)
  • SQL Server Connection failure
    ... I have an application which uses OLEDB to connect to ... My app is not able to connect to SQLServer when my machine is ... upgraded from windwos 2000 to ...
    (microsoft.public.sqlserver.connect)
Quantcast