PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEVWEBDEV and WINDEV Mobile

Home → WINDEV 2024 → OLE DB provider HFSQL not working
OLE DB provider HFSQL not working
Started by Berets, Oct., 29 2019 7:31 PM - 1 reply
Posted on October, 29 2019 - 7:31 PM
Hi

im trying to set up a linked server in SQL Server using HFSQL OLE DB, it kinda work but i can't do query on table i get this error message :
The ole DB provider "PCSoft.HFSQL" for linked server "ServerTest" could not map ordinals for one or more columns of object "DBSHEMA_TABLES"


I also did some test with Excel where i can read table data with HFSQL ODBC driver but i can't when i use the provider
i get this error :
The value can't be null. Name of the parameter : pUnk


Used version 22 and 24 for my tests.
Do anyone have an idea about what is wrong with the provider?
Posted on January, 20 2020 - 5:27 PM
Hi,

I've got the same probleme. Did you find a solution ?

best regard
Pierre