PROFESSIONAL NEWSGROUPS
WINDEV
,
WEBDEV
and
WINDEV Mobile
Home
|
Recent messages
|
Connect
|
Sign out
|
English
Home
→
WINDEV 2024
→
HFSQL C/S server status
HFSQL C/S server status
Started by ARV, Sep., 17 2021 10:44 PM - 4 replies
Connect yourself…
ARV
#1
Registered member
498 messages
Popularité : +8 (8 votes)
Posted on September, 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
Report
0
0
argus
#2
Posted on September, 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
Report
0
0
ARV
#3
Registered member
498 messages
Popularité : +8 (8 votes)
Posted on April, 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
Report
0
0
TuqueroIMKJernalyn
#4
Registered member
9 messages
Posted on April, 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
Report
0
0
JeAn-PhI
#5
Posted on May, 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
Report
0
0
→ Go back to WINDEV 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (earlier versions)
Français
English
Español
Portuguesa
Close this window
Search type
Only topics
All the messages
Search period
Any time
Past hour
Past 24 hours
Past week
Past month
Past year
Cancel
Preview of your message
Adding an image
Import an image from a URL
Send an image from a file of your disk
Drop a file or click "Browse..."
or
Cancel
0%
WLanguage
SQL
XML, HTML
JAVA, Javascript
Text