Re: irregular connection issue

No, I was actually referring to ODBC tracing that you find in the ODBC
Administrator at the O/S level. But, since I haven't used it since '99, I'm
not qualified to recommend it, or know if it will do what you need

--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm

Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com


"BigSam" <BigSam@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:33FD5F00-9431-4512-A6A7-9CC810798807@xxxxxxxxxxxxxxxx
Do you mean to use SQL Profiler to trace the activity? What events?

Thanks,

"Kevin3NF" wrote:

no...you were clear...I just didn't read closely enough.

I would suggest turning on ODBC tracing if I knew how to help review the
output...

--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm

Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com


"BigSam" <BigSam@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B16BFA10-EE85-4D25-9DD2-AEFE236AC781@xxxxxxxxxxxxxxxx
I must not have been clear - SQL & the IIS application run on the same
server.

"Kevin3NF" wrote:

Run Netmon on both ends. Sounds very much like a flaky switch or some
other
piece of hardware that appears normal 99%of the time

--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm

Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com


"BigSam" <BigSam@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:594474FB-DF78-46F5-811E-D17BE7CC4738@xxxxxxxxxxxxxxxx
Occasionally we are getting the generic "SQL Server does not exist
or
access
denied" connection message. KB 328306 does an ok job describing the
situation, the problem we're having is that it doesn't occur with
each
connection. The IIS application runs on the same server as SQL does,
so
I
don't think any of the network related issues apply. The server is a
stand
alone server, so I don't think any of the domain related issues
apply
either.
The server is running W2k3 & SQL 2k.
We've written an ASP page to read records until it encounters a
problem.
The
record count varies every time - it can occur on the 1st read or the
3000
read.
Any de-bugging suggestions will be greatly appreciates.

Thanks,








.

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