PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEVWEBDEV e WINDEV Mobile

Inicio → WINDEV 2024 → HFSQL C/S server status
HFSQL C/S server status
Iniciado por ARV, set., 17 2021 10:44 PM - 4 respostas
Membro registado
498 mensagems
Popularité : +8 (8 votes)
Publicado em setembro, 17 2021 - 10:44 PM
Hi

I'm having a little program and I search about this but never came to a solution

I have this app on my servers to manage my DB
But for somereason the status of the server show a time complety different for the current time of my country like 5 hours ahead of the current time

If I execute a Query with SYSDATE funciont it will have the exact same date time I need but when I want to use HInfoServer(Connection,hInfoDate) it will show the exact same date but the hour minute and seconds are wrong

Someone know what it's happening?

--
Best Regards
ARV
Publicado em setembro, 19 2021 - 10:19 PM
most probably, one is returning UTC and the other local time

Use the appropriate wlanguage functions to change from one to the other
Membro registado
498 mensagems
Popularité : +8 (8 votes)
Publicado em abril, 18 2022 - 4:31 PM
Hi argus

Thanks for the reply I will use wlanguage functions, I can change the UTC time to a local time

I also use a API server to have the current date and time of my country if that fail then I will use the wlangauge to have the UTC date time if even that fails then I will use the sysdate to have the date time of the device the user is using.

--
Best Regards
ARV
Membro registado
9 mensagems
Publicado em abril, 29 2022 - 10:06 AM
I want to access windev database from C #.

Through the HFSQL ODBC driver.

static void Main(string[] args)
{
try
{
OdbcConnection MyConnection =
new OdbcConnection(
"Driver={HFSQL};" +
"ANA=w:\\C7.wdd;" +
"Server Name =10.90.6.20;" +
"Server Port =4900; " +
"Database =DBASE; " +
"UID =user; " +
"PWD =1234;");

MyConnection.Open();

MyData.Close();
MyConnection.Close();
}
catch (OdbcException eExcpt)
{
// Display the errors
Console.WriteLine("Source = " + eExcpt.Source);
Console.WriteLine("Message = " + eExcpt.Message);
}
// pause before exiting
Console.ReadLine();
}
MyConnection.Open(); Send this error:

Source =
Message = ERROR [08001] <DvDecEntete> file already defined.
Debugging information:
IEWDHF=32.2
Module=<WDHF>
Version=<26.0.313.5>
All parameter is ok!

What's the problem https://azar.pro ? And what is https://echat.date the solution?

--
TuqueroIMKJernalyn
Publicado em maio, 02 2022 - 9:25 AM
Après mûre réflexion, TuqueroIMKJernalyn a écrit :
I want to access windev database from C #.

Through the HFSQL ODBC driver.

static void Main(string[] args)
{
try
{ OdbcConnection MyConnection =
new OdbcConnection(
"Driver={HFSQL};" +
"ANA=w:\\C7.wdd;" +
"Server Name =10.90.6.20;" +
"Server Port =4900; " +
"Database =DBASE; " +
"UID =user; " +
"PWD =1234;");
MyConnection.Open();
MyData.Close();
MyConnection.Close();
}
catch (OdbcException eExcpt)
{
// Display the errors
Console.WriteLine("Source = " + eExcpt.Source);
Console.WriteLine("Message = " + eExcpt.Message);
}
// pause before exiting
Console.ReadLine();
}
MyConnection.Open(); Send this error:

Source =
Message = ERROR [08001] <DvDecEntete> file already defined.
Debugging information:
IEWDHF=32.2
Module=<WDHF>
Version=<26.0.313.5>
All parameter is ok!

What's the problem https://azar.pro ? And what is https://echat.date the
solution?


hello read this :

https://doc.pcsoft.fr/fr-FR/?3044313&name=ODBC_sur_Hyper_File_via_Visual_NET

--
Cordialement JeAn-PhI