PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WINDEV 2024 → HFSQL C/S server status
HFSQL C/S server status
Débuté par ARV, 17 sep. 2021 22:44 - 4 réponses
Membre enregistré
498 messages
Popularité : +8 (8 votes)
Posté le 17 septembre 2021 - 22:44
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
Posté le 19 septembre 2021 - 22:19
most probably, one is returning UTC and the other local time

Use the appropriate wlanguage functions to change from one to the other
Membre enregistré
498 messages
Popularité : +8 (8 votes)
Posté le 18 avril 2022 - 16:31
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
Membre enregistré
9 messages
Posté le 29 avril 2022 - 10:06
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
Posté le 02 mai 2022 - 09:25
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