sql server odbc: SQL Server from ASP (thru IIS) -- sql server odbc

SQL Server from ASP (thru IIS)

kejoseph NO[at]SPAM hotmail.com
11/18/2004 9:48:02 PM

sql server odbc:

I have an app which connects to SQL Server via an ASP (thru IIS). At
times I get SQL errors which are listed on the site below -
http://support.microsoft.com/default.aspx?kbid=328476

I need to know the following

1. How do I know whether I am using ODBC or OLE DB ?
2. How do I set a retry count for ensuring that the application does
not return an error but tries again.
3. In SQL Server how do I monitor these connections (via Perfmon) to
check whether there are any issues ?

Any further inputs will be highly appreciated.

Thanks,

RE: SQL Server from ASP (thru IIS)

jam96-BuffaloJoe
12/2/2004 1:59:01 PM

for ODBC go to the ODBC admin and turn tracing on . on the tracing tab. look
at the file created. This monitors odbc.

to watch on the SQL Serve Side: go to Enterprise manager and watch the
processes
or Server>Management> Current Activity

Use Try catch Finally end try
with a goto in the catch for that error

Catch ex as Exception
if ex.tostring = your error then goto the line to try again.

Mabe a counter as to not do to many times.

Joe

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server odbc group.