Welcome! Log In Create A New Profile

Advanced

[WD22] Use a view of HFSQL from an outside program via ODBC

Posted by Stefan B. 
Forum List Message List New Topic
Stefan B.
[WD22] Use a view of HFSQL from an outside program via ODBC
August 22, 2019 12:18PM
Hi all,

We want to use a view, made in the ControlCenter of HFSQL, via an ODBC-connection on HFSQL.
We can see al filetables that are defined in the analysis, but cannot see the view.
Is it possible to see views via ODBC or is it not? Or is this made possible in a newer version of WinDev/HFSQL?

We have got some extra information from PCSoft. Views are not supported in version 22. And the ODBC-driver only shows datatables that are defined in the analysis. So we tried to define a view in the analysis. That worked, but it's also not visible via ODBC.
PCSoft wrote that views in version 23 are supported! So we installed version 23 of the HFSQL database server and version 23 of the ODBC-driver, but it doesn't help us. Both the 32 bits and the 64 bits versions are tested, but with no avail. The views are still invisible.

Regards, Stefan



Edited 1 time(s). Last edit at 08/29/2019 09:59AM by Stefan B..
Reply Quote
Newer Topic Older Topic
Author:

Your Email:


Subject:
Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: