FORUMS PROFESSIONNELS
WINDEV
,
WEBDEV
et
WINDEV Mobile
Accueil
|
Messages récents
|
Connexion
|
Déconnexion
|
Français
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
Connectez-vous…
ARV
#1
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
Signaler
0
0
argus
#2
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
Signaler
0
0
ARV
#3
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
Signaler
0
0
TuqueroIMKJernalyn
#4
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
Signaler
0
0
JeAn-PhI
#5
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
Signaler
0
0
→ Revenir à WINDEV 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (précédentes versions)
Français
English
Español
Portuguesa
Fermer cette fenêtre
Type de recherche
Uniquement les sujets
Tous les messages
Période de recherche
Date indifférente
Moins d'une heure
Moins de 24 heures
Moins d'une semaine
Moins d'un mois
Moins d'un an
Annuler
Aperçu de votre message
Ajouter une image
Importer une image depuis une URL
Envoyer une image depuis un fichier de votre disque
Déposez ici un fichier ou cliquez sur "Parcourir..."
ou
Annuler
0%
WLangage
SQL
XML, HTML
JAVA, Javascript
Texte