Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Orphan Database Connections, Crystal thru VB

Status
Not open for further replies.
thorntone

thorntone

IS-IT--Management
Mar 2, 2001
12
0
0
US
We have a problem with orphaned user spid's in MS SQL Server when we run a crystal report through a DLL called from ASP code. The spid is initiated when the report call is made, but never clears out. Interestingly, the database association to the spid changes from the database the report is run against to the default database for the user ID when the report is completed. I assume that means that a database close is being implictly performed, but no SQL Server logoff (explicit or implicit) takes place.

I'm very interested in any advice anyone can lend.
 
Status
Not open for further replies.

Similar threads

K
  • Question
We're using command in crystal report
Replies
1
Views
184
hilfy
hilfy
D
  • Question
Crystal Reports for Visual Studio 2022 Download
Replies
2
Views
828
Joshua44
J
David Richardson
  • Locked
  • Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
242
hilfy
hilfy
SarahSCPDAdmin
  • Locked
  • Question
Crystal Reports - Group question 1
Replies
2
Views
183
SarahSCPDAdmin
SarahSCPDAdmin
CodeWell
  • Locked
  • Question
Crystal Reports RPTR Format Not Available
Replies
2
Views
144
CodeWell
CodeWell

Part and Inventory Search

Sponsor

Back
Top