PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEV, WEBDEV and WINDEV Mobile

Home | Recent messages | Connect |  | English US
Home → WINDEV 2024 → ODBC
ODBC
Started by vvido, Mar., 21 2017 3:41 PM - 1 reply
#1
Posted on March, 21 2017 - 3:41 PM
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
#2
Posted on March, 30 2017 - 10:55 AM
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
→ Go back to WINDEV 2024