Using remote function

[raffaeleM]

Hi all,
I have a problem regarding the access to a DB located on the server SR1 from a DB located on a server SR2. I have to run a recursive select using tables on SR1 and use the result set in the db on server SR2.
I tryed to define a function on server SR1 and call it from the server SR2 using function template and function mapping but I can't call the remote function because it seems not existent in SR2 db.

Can you, please, tell me some ideas for doing that?

thank you.

[ADezii]

Hi all,
I have a problem regarding the access to a DB located on the server SR1 from a DB located on a server SR2. I have to run a recursive select using tables on SR1 and use the result set in the db on server SR2.
I tryed to define a function on server SR1 and call it from the server SR2 using function template and function mapping but I can't call the remote function because it seems not existent in SR2 db.

Can you, please, tell me some ideas for doing that?

thank you.

Try this sample approach. The following code will execute the Public Function fReverseString("<single String Argument>") in the Test.mdb Database, in the Folder C:\Test\, from the Current Database. It will pass the Single Argument "Philadelphia" to fReverseString(), which in turn will return the String in Reverse in a Message Box. Hope this helps:

Dim appAccess As Access.Application
 
'Create instance of Access Application object.
Set appAccess = CreateObject("Access.Application")
 
'Open C:\Test\Test.mdb database in Microsoft Access window.
appAccess.OpenCurrentDatabase "C:\Test\Test.mdb", False
 
'Run Function Procedure.
appAccess.Run "fReverseString", "Philadelphia"
 
'Clean up
Set appAccess = Nothing
 

[raffaeleM]

sorry, may be I was not clear. My db is a db2 on server1 and a db2 on server2 and I have to call a function defined on server1 from an application using data on server2 mixed with data on server1.

Tanhk you for suggestion.