PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WINDEV Mobile 2024 → [WM23] Stored Procedures on a server
[WM23] Stored Procedures on a server
Débuté par ARV, 13 déc. 2019 21:07 - Aucune réponse
Membre enregistré
498 messages
Popularité : +8 (8 votes)
Posté le 13 décembre 2019 - 21:07
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