Lotus Notes Scheduled Agent - Error in Loading DLL

We use an address lookup system (QAS) within our bespoke Domino application.  The address data, dll's and ini files are on a network path, and the code in the application looks at this when searching for addresses.  This works really well.

I have a requirement to automatically create some Notes documents, which will involve populating an address.  I have written a scheduled agent that picks up data from a SQL table and creates a Word document, which is then attached to a Notes document and saved in our application.

If I test this agent from my client, it works fine, but when running from the server I get the following error:

"error: Error in loading DLL"

This occurs at the point where the agent is carrying out the address search.  The server is able to access the network path and see the ini/dll files.  I have tried moving the ini file/DLL locally onto the server in various locations, including windows\system32 and the domino application directory, but always get the same error.

Any help would be greatly appreciated. Thanks.
daviesgroupAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

madheeswarCommented:
From my experience, .... (ofcourse not related to DLL stuff)
The DLL is not authorized to run against the Address book. Since access is needed.
In the DLL, you can pass the username and password to access  the Address Book.
Hope it helps.

-Maddy
madheeswarCommented:
For confirming access problem, when the DLL access the Address Book, check the log file in Domino server. It should give 'You are not authorized...." some sort of access denial message.
To over come this, you need to pass User Name and password as we do to send email through VB.
daviesgroupAuthor Commented:
There are no authorisation problems on the server. The only message thats comes up on the server log is the Error in Loading DLL.  I have put print statements around this area of my code to confirm this, so I can see what's happening.

Why would the DLL access the address book?  QAS is an off the sheld address lookup tool. You pass a post code and house number/name and it returns the full postal address. The DLL is part of the QAS software.
Introduction to R

R is considered the predominant language for data scientist and statisticians. Learn how to use R for your own data science projects.

madheeswarCommented:
Oh...I see.
I am not aware of QAS software.
Apolozise for providing a wrong suggestion.
daviesgroupAuthor Commented:
No problem madheeswar, thanks for trying...
daviesgroupAuthor Commented:
Thanks for that.  I had tried everything mentioned here, but still no joy.
qwaleteeCommented:
First thing I would do is try running the client on the server and confirm that QAS works on the box altogether.

Next thing I would do is confirm that your agent is authorized to make calls to DLLs.  I doubt that is the problem, because I would expect a different error, but you never know.

Next, I would contact the vendor and find out if there is anything they need to set up WITHIN the application.  There might be issues with teh DLL you are claling needing to call additional DLLs and not being able to find them.

It might also be worth finding out if they have another way to call the system, such as OLE, COM, ActiveX, DDE, or running an EXE with parameters.
Computer101Commented:
PAQed with no points refunded (of 500)

Computer101
EE Admin

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.