GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEV
,
WEBDEV
e
WINDEV Mobile
Inicio
|
Mensagens recentes
|
Conecte-se...
|
Disconnect
|
Português
Inicio
→
WINDEV 2024
→
HFSQL C/S server status
HFSQL C/S server status
Iniciado por ARV, set., 17 2021 10:44 PM - 4 respostas
Conecte-se…
ARV
#1
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
Denunciar
0
0
argus
#2
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
Denunciar
0
0
ARV
#3
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
Denunciar
0
0
TuqueroIMKJernalyn
#4
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
Denunciar
0
0
JeAn-PhI
#5
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
Denunciar
0
0
→ Voltar para WINDEV 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (versões anteriores)
Français
English
Español
Portuguesa
Fermer cette fenêtre
Tipo de Pesquisa
Apenas tópicos
Todas as mensagens
Período de pesquisa
Qualquer momento
Última hora
Últimas 24 horas
Semana passada
Mês passado
Ano passado
Cancelar
Pré-visualização da sua mensagem
Adicionar imagem
Importar uma imagem de uma URL
Enviar uma imagem a partir do seu disco
Deixe um ficheiro ou clique em "Procurar ..."
ou
Cancelar
0%
WLanguage
SQL
XML, HTML
JAVA, Javascript
Texto