PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → ODBC
ODBC
Iniciado por vvido, 21,mar. 2017 15:41 - 1 respuesta
Publicado el 21,marzo 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
Publicado el 30,marzo 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