Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
I will try out the information which you provided. Thanks.
I have also discovered that I was probably going about things incorrectly. I had set up 16 different named connections, one for each of the 16 databases. I had set up a single remote view. Apparently, once a remote view is set up, it retains the connection name. I tried (unsuccessfully) to get the remote view to accept a different connection. Instead, I can use DBSETPROP to change the details of the named connection to which the view is linked. Before I attempt to open the view, I simply pass whichever connection string is appropriate for that company division, to DBSETPROP. That seems to achieve what I needed.
Best wishes,
Randy
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement