PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEVWEBDEV and WINDEV Mobile

Home → WEBDEV 2024 → HFSQL file password (there is no forum group HFSQL)
HFSQL file password (there is no forum group HFSQL)
Started by EKoster, Jan., 04 2024 1:45 PM - 1 reply
Registered member
16 messages
Posted on January, 04 2024 - 1:45 PM
I have installed the hfsql odbc driver. I can use this in python and read data from the database and place it in polars. The thing is, some tables have a password on the file. These tables give an error when quering them via the odbc.

Two solutions, both with 1 question:
1. Query the table via the odbc driver. Question, how can I add the password to the driver
2. Remove the password from the file. Question, how can I remove the password from the file (I know the password)
Registered member
16 messages
Posted on January, 04 2024 - 2:25 PM
Or
Export to xlsx with wdmap. But I need to know how to excute that via the command line