PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEVWEBDEV and WINDEV Mobile

Home → WINDEV Mobile 2024 → [WM23] Stored Procedures on a server
[WM23] Stored Procedures on a server
Started by ARV, Dec., 13 2019 9:07 PM - No answer
Registered member
498 messages
Popularité : +8 (8 votes)
Posted on December, 13 2019 - 9:07 PM
Hi everyone,

I'm creating this thread because I want to know if it is possible to get access to another data base through a stored procedure on a server.

Here's the situation
I have two DB let's call it
DB1
DB2

on DB1 I have important tables of information to show to the user
on DB2 I have tables for managment connections to a lot of DBs

I want to create stored procedures for DB2 but those stored procedures need information of tables that only DB1 have.

I was hoping if there's any way possible to access the tables of DB1 through stored procedures of DB2.

Hope anyone know about a function or if I need to set something to make it work.
Thanks!

--
Best Regards
ARV