[pro_vb] Re: DCOM - activex call on clientHi,
Thanks for the response.

I had the same doubt & I opened DB connection only inside the mthd. Pls note
that the client part is functional when used on the same server PC.

To trace further, I logged msg into a txt file on the server side. I found
logs in the Class_Initialise event but doesn't seem to get inside any method
at all.

I implemented a simple mthd as

Public Function Test() as String
    Test = "Test"
End Sub

When this mthd is called frm the client appl running on the server itself,
value is returned but when called frm a different client PC, I get the err
Method '~' of object '~' failed.

Any more suggestions?

Our server is NT4, so I'm not in a position to use COM+ (clients will be
Windows 98). As a nxt step, I need to give a try with COM instead of DCOM.
  -----Original Message-----
  From: JohnRLick@h... [mailto:JohnRLick@h...]
  Sent: Tuesday, February 18, 2003 12:58 AM
  To: professional vb
  Subject: [pro_vb] Re: DCOM - activex call on client


  I have not done alot with DCOM. I jumpped from Client-Server to COM+, but
  what it sounds like to me is that your "Operation is not allowed when the
  object is closed" error is due to you not opening (or closing early) a
  connection to the DB.

  I would trace your logic on that. Maybe you are creating a new instance of
  your EXE, and it does not have a connection that you created earlier.

  As far as your Object variable or With block variable not set, maybe this
  is an indication that your connection object hasn't been created.

  You didn't really give enough information to know for sure. But maybe this
  will help.

  > I have an activex exe compiled & registered on NT4 PC. the client part
  works
  fine on the same PC but gives the message
  Runtime error - 3704
  Operation is not allowed when the object is closed.

  The mthd called returns a recordset frm DB.

  The server, event viewer has logged
  Logged: MsgBox: , Run-time error '91':

  Object variable or With block variable not set



  Any suggestions?

  DCOM95 is installed on the Windows95 client. Both server & client has MDAC
  2.5.



  Regards,
  S.Malathi, IT Project Analyst
  ADNOC Distribution
  P.O. 4188, Abu Dhabi
  Tel : 6959480 (D)
  Mob : 050 5316055



  DISCLAIMER:
  --------------------------------------------------------------------------
-
  ----------------------------------
   Please note that our domain name is changed from adnoc-fod.co.ae to
adnoc-
  dist.co.ae
   Hence change your email addresses accordingly to reflect these changes.
   This communication may contain confidential information.  If you are not
  the intended recipient
   please inform us immediately.
   For complete disclaimer note please visit our website at:
   http://www.adnoc-dist.co.ae/emaildisclaimer.htm


   Adnoc Distribution-Tel:02-6771300;Fax:02-6722322;
   Email:webmaster@a...;Website:http://www.adnoc-dist.co.ae



DISCLAIMER:
-------------------------------------------------------------------------------------------------------------
 Please note that our domain name is changed from adnoc-fod.co.ae to adnoc-dist.co.ae
 Hence change your email addresses accordingly to reflect these changes.
 This communication may contain confidential information.  If you are not the intended recipient 
 please inform us immediately.
 For complete disclaimer note please visit our website at:
 http://www.adnoc-dist.co.ae/emaildisclaimer.htm
                                                                                                                             
 Adnoc Distribution-Tel:02-6771300;Fax:02-6722322;
 Email:webmaster@a...;Website:http://www.adnoc-dist.co.ae