PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → Runtime set up for MSSQL
Runtime set up for MSSQL
Iniciado por kel, 01,ago. 2019 03:00 - 2 respuestas
Publicado el 01,agosto 2019 - 03:00
Hi
I am having trouble setting up my software on other clients computers, I am using MSSQL and every client has a different server and database name. I am currently reading the setup from a XML file in the local exe folder.

and I am using the following code
Easyconnect..Provider = hOledbSQLServer

Easyconnect..Server = xmlconfigread("Server","",sXmlfilename)
Easyconnect..Database = xmlconfigread("Database","",sXmlfilename)
Easyconnect..User = xmlconfigread("User","",sXmlfilename)
Easyconnect..Password = xmlconfigread("Password","",sXmlfilename)

bRetbyte = HChangeConnection("*",Easyconnect)

bRetbyte = HOpenConnection(Easyconnect)
The programme does not error but no data is displayed in the browse

I have my code in a local procedure in the main window. Should it be somewhere else?
Publicado el 01,agosto 2019 - 19:49
Call the db init in the initprocess of the project
Publicado el 05,agosto 2019 - 02:59
Hi Thanks for the reply
Where would I find the DB init or the init process?