Automation Error 80004005 when creating a CDO object

[LennyE]

Hi All,

I've got an Access app that uses CDO to mail out report results. When running the application from my desktop it works fine, but when I try to execute it through Citrix I get the following error "80004005 Automation Error, Unspecified Error" I verified that the CDO library was loaded on the Citrix server on which the app is running.

The error is rather non-descript but I suspect that it has something to do with access to the CDO library. Any thoughts?

Lenny

 

[JScannell]

I assume that you copied the app onto the Citrix server and are running from there, right? Generally, client software isn't installed on a server. So while the app worked on your computer (you no doubt have MS Office installed) it can't work on the server.

My experience with having MS Office products on a server is that most network administrators won't allow it.

This doesn't solve your problem but should let you know where the problem lies.

Jerry

Jerry Scannell

 

[LennyE]

Jerry,

The application actually exists on a non-Citrix server that exists within the same domain. The Citrix server simply accesses the .mdb on that server to run it within MS Access.

My confusion was with CDO itself. I verified that cdo.dll was in-fact loaded on the Citrix server. I thought that the dll was all that was necessary to make use of the CDO library. What I'm finding out is that CDO is so intertwined with MS Outlook, that it must be loaded as well.

I have managed to talk my admin into loading MS Outlook and I am now able to instanciate the CDO session object and build my message, however when I try to send it I now get another error "Object not found".

This is a bit baffling because that application actually creates the message correctly as evidenced by the fact that I can find and send it from the Outbox of the mailbox when I access it through Outlook.

 

[JScannell]

You do know that there are two different CDO objects, don't you? The newer one (cdosys) and the older one (cdonts). You might be running into that problem. Check all the versions of everything so you know you are on track.

Jerry

Jerry Scannell