Re: connection string causes blank page

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Aaron Bertrand [MVP] (aaron_at_TRASHaspfaq.com)
Date: 05/07/04 

Date: Thu, 6 May 2004 21:40:41 -0400

> Can anyone give me a clue as to how I might progress in tracking the
> error(s)?

First off, you could try showing us the actual code that InterDev produced.
If you are using any of its wizards, you might try opening notepad and
creating a file that does simply this:

<%
    set conn = CreateObject("ADODB.Connection")
    conn.open "<sybase connection string here>"
    conn.close()
    set conn = nothing
%>

If this hangs, try a page without an ADODB.Connection at all. Maybe you
have a much more generic problem. If the above just spins, try to set low
timeout values (see http://www.aspfaq.com/2066) and introduce some basic
error handling so you can catch the error message yourself instead of
relying on IIS to report it to you correctly (and your browser to not muck
it up). 

-- 
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/