Re: ODBC, SQL Server, Frustration

So you never see the INSERT INTO make it to the SQL Server in SQL Profiler?

If you don't see it make it to the server, this indicates a problem with the
driver.

If you do see it make it, I would suspect blocking on server side, for
example you could have an open transaction that is blocking the insert.

If it hangs on the client side and nothing makes it to SQL Profiler, then
what I would do is compare the dll versions of all the drivers on QA versus
other machines.

Look specifically at sqlsrvr32.dll in windows\system32 folder, compare these
on good and bad machines. You can also try swapping them out this dll is
not system file protected.

--
Matt Neerincx [MSFT]

This posting is provided "AS IS", with no warranties, and confers no rights.

Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Arnie" <none> wrote in message
news:e1uNyDvrFHA.2880@xxxxxxxxxxxxxxxxxxxxxxx
> Warren Read wrote:
>> Were you able to resolve this? It isn't a situation that i've ever
>> heard of. Perhaps upgrading to MDAC 2.8 would help?
>>
> Thanks for the reply. Nope, no solution yet. My original post was
> incorrect. Two of the three servers are W2K3, the other is W2K. The
> problem server is one of the W2K3 ones.
>
> I just don't know where to go from here. The ODBC trace and server-side
> trace didn't show anything. I don't know where else to look. The worst
> thing is that each of our three groups have three servers; one each for
> SQL Server, Oracle and DB2. The SQL Server for QA is the only place the
> problem occurs.
>
> Any suggestions from anyone, no matter how off the wall, would be
> appreciated.
>
> - Arnie
>


.

Relevant Pages

  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... I also checked the individual patch levels for the .NET drivers, SQL Server ... The SQL Server is fully patched, however Windows Update reported that the OS ... Lock pages in memory -- I guess you might have taken care of it as well. ...
    (microsoft.public.sqlserver.clustering)
  • RE: migrating from wmsde to sql server
    ... Click Start, point to All Programs\Microsoft SQL Server, and then click ... then click New SQL Server Registration. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Best replication architecture?
    ... Looking for a SQL Server replication book? ... So if it is subscribing to Publisher 1, ...
    (microsoft.public.sqlserver.replication)
Loading