|
| Iniciado por Kel, 15,jun. 2016 22:00 - 1 respuesta |
| |
| | | |
|
| |
Miembro registrado
1 mensaje |
|
| Publicado el 15,junio 2016 - 22:00 |
Hi
I need to access two MSSQL databases at the same time, I currently use Clarion and have order Windev and Webdev.
The reason I need this is twofold.
1.We run servers with multiple client data bases on the same mssql server, the clients connect to a control database that will then automatically get their settings on which data base to connect to.
2. The control data base also has a common email file that holds all the advance shipping notices for all users and sends them using a window service.
Also I cannot seem to find how you can change the SQL server name as this is not known at the time of creating the software, if the client has their own sql server we just attach the database to it and edit our connect string which is in an INI file.
Thanks in advance
--
Kel |
| |
| |
| | | |
|
| | |
| |
| Publicado el 16,junio 2016 - 13:25 |
Hi Kel
look in the help at hchangeconnection. You'll need to define two
connexions first, of course, but then you can use it to define which
file is connected to which connection, and voila...
of course, all parameters of the connection ca come from an ini file,
using iniread to get them
Best regards
--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting
More information on http://www.fabriceharari.com |
| |
| |
| | | |
|
| | | | |
| | |
|