Com+ Application Hangs

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
LVL 5
mattykAsked:
Who is Participating?
 
rkot2000Commented:
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
 
Z_BeeblebroxCommented:
Hi,

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

Zaphod.
0
 
rkot2000Commented:
<ping>.. Listening
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
mattykAuthor Commented:
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
 
rkot2000Commented:
can you post some code I devepoped for mts and com+ maybe i can see someting
0
 
mattykAuthor Commented:
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
 
mattykAuthor Commented:
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
 
rkot2000Commented:
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
 
mattykAuthor Commented:
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
 
rkot2000Commented:
my last idea : check transaction timeout property for COM +
in one application it was set one sec.
0
 
Z_BeeblebroxCommented:
Hi,

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

Zaphod.
0
 
mattykAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.