Posted by Erland Sommarskog on 09/22/07 09:10

Daniel Loose (no@reply.de) writes:
> i also tried uid instead of user id and pwd instead of password, which
> i assume are just aliases?, that is, i now use the same structure as
> in the original project, the objects mentioned in the connstring seem
> to exist, the sql auth seems to work since now the server manager
> after restart logs in with sql auth, using u/p = u1/p1 -- but, it
> still doesnt work. but, the problem appearance slightly differs now:
> still, ie takes 5 minutes to "load" the page - but then, no error
> message at all appears anymore, nor does the page itself - just a
> blank screen. whats up??
>
> i guess, only error logs could still help me out? where to find them?
> where to get more details? thanx again!!!!

If you get blank page in your browser, I would suspect that there is a
problem with the HTML sent to the broweser. For help to debug that part,
you may be better of in an ASP forum.

If it takes five minutes before you get that far, I would guess this is
because it takes five minutes to run the query. You can verify in Mgmt
Studio that you are connected by running sp_who2. You should be able
to identify your process.

As for why it takes five minutes to run the query, that it's impossible
to tell with the meager information given.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]