PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WINDEV 2024 → ODBC
ODBC
Débuté par vvido, 21 mar. 2017 15:41 - 1 réponse
Posté le 21 mars 2017 - 15:41
I am trying to view the HFile data using an SQL tool.

It correctly connects to the ODBC source an correctly shows all HFile tables (files in the directory).
But if I want to execute a sql statement it fails.

My Statement: SELECT * FROM MyTestFile
Errorcode: Information 9 non supportée par le drive

Please advice
Posté le 30 mars 2017 - 10:55
Is the data on a different computer or remote drive?

In this case you have to use URNs on the 'Directory of files' in ODBC and not mapped drives.

\\Computername\Directory

I spent ages working this out as I couldn't find any information on it.

I also discovered that if you used PHP on a web page to pull out information from HFSQL then within that page you did not refer to -

\\Computername\Directory

You had to use -

\\\\Computername\Directory

Norman