Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


MTS & SQL Server locked up.

MTS & SQL Server locked up.

MTS & SQL Server locked up.

I'm desperately needing to find the answer for my problem.

I've a client app that's an ActiveX EXE (let's call it EXE). Another app (let's call it APP1) passes an id to my ActiveX EXE, and the ActiveX EXE would call an MTS component to fetch some data from the SQL Server (based on that id) and passes the data back to the ActiveX EXE. The EXE uses the data to populate a form and show it. Simple enough.

The ActiveX EXE is installed on workstations (> 50), but about 10 - 20 workstations uses it at almost the same time, but never all together). The EXE works fine for about 10 - 15 days, and one day for no apparent reason, when APP1 tried to call the EXE, all of the workstations' EXE would display a server busy dialog box (with "Switch To" and "Retry" buttons), and it just wouldn't go away. If I tried to open up MTS Explore on the server, I couldn't. It's wouldn't open up. SQL Server was also not responding (Enterprise Manager and ISQLW wouldn't run). I had to reboot the server. As soon as I rebooted the server, I could open up MTS Explorer. When I checked the status view of the component that the EXE calls, I could see "Objects", "Activated", and "In Call" columns all had "21" in them. They were not going away. I had to shut down the package to clear it. After I cleared it, my ActiveX EXE worked fine again. However, after 10 - 15 days, the same problem would happen again. This morning, we found out one of the hard drives (RAID) on the server was faulty because the firmware on it needs to be updated. I don't if that would have anything to do with my problem.

I have made sure (let 2 other developers checked) all objects in APP1, EXE and MTS component are all releasing their objects when the code exits. We figure because something might not be releasing when there's a failure, the problem arises.

I hope someone could help me. Thx.


RE: MTS & SQL Server locked up.

This is very indicative of a memory leak somewhere. Make sure that you're correctly releasing the objects when no longer in use. Ensure that all obselete instantiated objects are released in your error handler events as well. That's one thing that often gets overlooked.

Neil Konitzer, President

RE: MTS & SQL Server locked up.

I have already made sure that all objects are released. In addition, I have "on error resume next" in my error handler so that if any error happens, it would proceed to a section of the code that would release ALL objects in used in the procedure.

I hope it's the faulty drive that's causing the problem. Or else, I don't know what to do, except get fired.   :(


RE: MTS & SQL Server locked up.

For anyone who's interested... the problem I experienced was bowled down to faulty hardware, specifically the harddrive. That's what causes the intermittendt "Switch To" and "Retry" problem.

Happy new year.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close