Possible connection problem

[SimonHawkins]

Hi,

Not sure if this is the correct place to post this, but...

I'm running a clustered setup with 2 web servers and 2 SQL
servers. Each web server has a digital certificate. I've
got a stored procedure that inserts into a table, and then
selects other data to be returned to my ASP page. The
query runs fine through Query Analyzer, but from the ASP
page it does the insert but doesn't return the select
data. This is strange because it works fine on a couple of
test environments (non clustered) but not on the live
site. I've spent a lot of time looking for any stupid
mistake in my query and I'm pretty sure it's OK. This has
led me to wonder if something is going wrong in the
connection (an area I don't know too much about).

Is there any reason why the connection would break down
once the initial data had been transferred, and before the
select data is returned?

Any help or ideas gratefully appreciated!

 

[mwolf00]

Please post your code for where you connect, call the stored procedure and load the recordset. -----------------------------------------------------------------
Be nice. It's only doing what you tell it to do.
mikewolf@tst-us.com