By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,647 Members | 1,444 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,647 IT Pros & Developers. It's quick & easy.

Using remote function

P: 2
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.
Mar 11 '08 #1
Share this Question
Share on Google+
2 Replies


ADezii
Expert 5K+
P: 8,607
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:
Expand|Select|Wrap|Line Numbers
  1. Dim appAccess As Access.Application
  2.  
  3. 'Create instance of Access Application object.
  4. Set appAccess = CreateObject("Access.Application")
  5.  
  6. 'Open C:\Test\Test.mdb database in Microsoft Access window.
  7. appAccess.OpenCurrentDatabase "C:\Test\Test.mdb", False
  8.  
  9. 'Run Function Procedure.
  10. appAccess.Run "fReverseString", "Philadelphia"
  11.  
  12. 'Clean up
  13. Set appAccess = Nothing
  14.  
Mar 11 '08 #2

P: 2
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.
Mar 13 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.