kg11
June 27th, 2001, 12:53 PM
I have a section in my webclass, where I Process a tag and replace it with data from a SQL server 2000 database.
Call DataEnv.ArrayRunComment(m_nArray, m_nRun)
If DataEnv.rsArrayRunComment.RecordCount > 0 then
DataEnv.rsArrayRunComment.MoveFirst
TagContents = TagContents _
& DataEnv.rsArrayRunComment.Fields("General_Comment_VC") _
& "</textarea></td></tr></table>"
else
TagContents = TagContents & " </textarea></td></tr></table>"
End If
DataEnv.rsArrayRunComment.Close
When I run the asp page from the project environment, everything works fine and dandy. The data is retrieved and the page displayed.
When I access the web-site directly, the page
hangs when it tries to get data from SQL Server.
I have no problem whatsoever running from the project environment.
When I comment the above code, so that no data is retrieved from the SQL server database (but I still retrieve some other data from an oracle database), the page displays just fine when I launch it outside the project environment.
Any help would be appreciated.
Thanks
KG
Call DataEnv.ArrayRunComment(m_nArray, m_nRun)
If DataEnv.rsArrayRunComment.RecordCount > 0 then
DataEnv.rsArrayRunComment.MoveFirst
TagContents = TagContents _
& DataEnv.rsArrayRunComment.Fields("General_Comment_VC") _
& "</textarea></td></tr></table>"
else
TagContents = TagContents & " </textarea></td></tr></table>"
End If
DataEnv.rsArrayRunComment.Close
When I run the asp page from the project environment, everything works fine and dandy. The data is retrieved and the page displayed.
When I access the web-site directly, the page
hangs when it tries to get data from SQL Server.
I have no problem whatsoever running from the project environment.
When I comment the above code, so that no data is retrieved from the SQL server database (but I still retrieve some other data from an oracle database), the page displays just fine when I launch it outside the project environment.
Any help would be appreciated.
Thanks
KG