Solved

Com+ Application Hangs

Posted on 2001-08-22
12
287 Views
Last Modified: 2013-11-25
I'm running into an issue with several COM+ applications that I'm trying to deploy.  For testing purposes the application contains a series of simple updates to a database and makes use of Transactions.  It was coded in VB 6 and setup as a COM+ app.  

I've then created a client (also in VB) that calls the object and the associated method.  The issue I'm having is that the first time the client is run things go smoothly and everything works as planned.  However if I try to run the client application again it hangs while trying to instantiate the component and I get an error stating:

Object server is stopping when Ole Service Contacts it

-I've searched MSFT and the other sites but haven't really found anything to point me towards my error.  Any thoughts about what might be the culprit?

thanks
-Matt
0
Comment
Question by:mattyk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
  • 2
12 Comments
 
LVL 7

Expert Comment

by:Z_Beeblebrox
ID: 6413374
Hi,

Did you set your class in COM+ to SingleUse or something like that? Not sure if it would make a difference...

Zaphod.
0
 
LVL 5

Expert Comment

by:rkot2000
ID: 6413536
<ping>.. Listening
0
 
LVL 5

Author Comment

by:mattyk
ID: 6413648
Nope.  Also the components will work just fine until I set their Transaction Support to Requires or Requires New and then they begin hanging.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 5

Expert Comment

by:rkot2000
ID: 6413661
can you post some code I devepoped for mts and com+ maybe i can see someting
0
 
LVL 5

Author Comment

by:mattyk
ID: 6413849
Yeah actually it's pretty simple.
Public Function UpdateOrderDetail() As String
   
   

    Dim intRowsReturned As Integer
    Dim strSQL As String
    Dim objInformixConn As ADODB.Connection
    Dim strInformix As String

    strInformix = "DSN=Xxx"

    intRowsReturned = 0
    strSQL = "Update orders set resp_sent='Y' where order_id='895265'"

    Set objInformixConn = New ADODB.Connection

'    objInformixConn.Open strInformix
'    objInformixConn.Execute strSQL, intRowsReturned
'    objInformixConn.Close

    Set objInformixConn = Nothing


    GetObjectContext.SetComplete
    UpdateOrderDetail = "Success"

End Function

If you uncomment the portion that connects to the DB the component will hang if it's part of a Transaction (if it's not part of transaction it will run reliably)

-matt

0
 
LVL 5

Accepted Solution

by:
rkot2000 earned 100 total points
ID: 6413882
maybe you have old informix odbc drvier

When I did development for oracle 8.1.6  I used ado trunsactions, you try it

Upgrade MTS 2.0 DTC to Support IBM DB2 and Informix Databases

http://support.microsoft.com/support/kb/articles/Q192/6/81.ASP?LN=EN-US&SD=gn&FR=0&qry=informix&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=TRS
0
 
LVL 5

Author Comment

by:mattyk
ID: 6414154
Yeah I'm in the process of trying to move things over to ADo transactions instead but the catch is for the production app that I'm building I was counting on being a two phase commit to Informix and Oracle, hence the need to use COM+ transactions.

As for the drivers I've already updated to the supported drivers (without them I got a different set of error messages :) )

thanks for your help so far
Matt
0
 
LVL 5

Expert Comment

by:rkot2000
ID: 6414205
did you apply all fixes for oracle ?
did you play with connection pooling for informix ?
try disable connection pooling.
did you create your com+ package as sever package or as client library ?
0
 
LVL 5

Author Comment

by:mattyk
ID: 6414334
did you apply all fixes for oracle ?
I'm not even really using Oracle at this point in the test

did you play with connection pooling for informix ?
yeah I thought of that but pooling is already disabled

did you create your com+ package as sever package or as client library ?
I tried it both ways with no success, it still hung regardless of the setting

-matt
0
 
LVL 5

Expert Comment

by:rkot2000
ID: 6414379
my last idea : check transaction timeout property for COM +
in one application it was set one sec.
0
 
LVL 7

Expert Comment

by:Z_Beeblebrox
ID: 6414664
Hi,

Do you have COM+ connection pooling enabled? What about JIT? I would try running it with both disabled.

Zaphod.
0
 
LVL 5

Author Comment

by:mattyk
ID: 6418115
Well folks in the end I developed a workaround with ADO transactions instead so I will accpeting that as the answer as it provided an acceptable workaround.

-matt
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

689 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question