Active X DLL, calling from server

I have written a simple Active X Dll and would like to store it on a local server.

If the DLL is Stored on the Client,this code works:


Function MakeBig(Value As String) As String
MakeBig = UCase(Value)
End Function

After making reference to DLL:

Dim Test As Project1.Class1
Private Sub Form_Load()
Dim bb As String
Set Test = New Project1.Class1
bb = Test.MakeBig("Reedy")
End Sub

I want to call it on the server and making a reference to the dll isn't what I need.

I have tried, but this doesn't work:

Declare Function makebig Lib "d:\Dll\Test.dll" (x As String) As String

bb = makebig("Reedy")

Error: Can't find dll entry point makebig in "C:\Dll\Test.Dll"

I want the dll on the server for when changes needed, it's easier to update!

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

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.

I don't think you can call VB dll function as simple dll function. I think what you are looking for is DCOM.

Read this, it will help you...

To understand all about DCOM read this,
I think you have to make a typelib for your client in
Project Properties|Component because you are using a remote dll

Then you reference this typelib
and set up Remote automation

Declaring a function is only for C/C++ like DLL's (these export their functions, VB ActiveX's do not)
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

To run it on a server it needs to be an activex exe methinks.
IF your running an ActiveX component it needs to be an ActiveX Exe as it needs to run in its own process (since its on another machine).

When you compile the ActiveX Exe you need to set the project properties to create remote server files.

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
Dean_ReedyAuthor Commented:
Thanks again!
Time to learn DCOM!!!!
This question was awarded, but never cleared due to the JSP-500 errors of that time.  It was "stuck" against userID -1 versus the intended expert whom you awarded.  This corrects the problem and the expert will now receive these points; points verified.

Please click on your Member Profile and select "View Question History" to navigate through any open or locked questions you may have to update and finalize them.  If you are an EE Pro user, you can also choose Power Search to find all your open questions.

This is the Community Support link, if help is needed.  Also a question is posted there specific to these changes that apply to the experts here.  Also, I am including the link to our All Topics, since many new ones have recently been added.
Thank you,
Moderator @ Experts Exchange
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
Microsoft Development

From novice to tech pro — start learning today.