PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → Windev, PHP and ODBC
Windev, PHP and ODBC
Iniciado por norman, 21,ene. 2016 15:47 - 1 respuesta
Publicado el 21,enero 2016 - 15:47
I have a multi-user WIndev application that uses shared Hyperfiles in a folder. The application itself works fine.

I wrote some PHP code which I use on a IIS web page which uses the ODBC connector to access some specific data within the Hyperfiles. Using either a static IP or something like DynDns it is possible to get restricted data access externally using this page. Again it works fine.

In fact it all works fine while the data folder is on the same computer as the web server. It doesn't matter if its the C: drive or any drive that is plugged in. The moment that the data is on our network NAS drive it no longer works and I get an error accessing the data. The NAS drive is a mapped drive. It works quite happily with the application.

I have altered the data directory in the OBDC (32bit) administrator and in my connection string. All fine while using the local drives of C: to G: but it fails the instant I use the mapped drive.

It strikes me as something to do with permissions but I turned UAC off and it made no difference at all. We have three NAS drives and they all give the same error. It's the same on a shared folder on another computer. I even tried using the URL and the IP address of the NAS drive in the connection string.

Has anyone had anything similar?
Publicado el 22,enero 2016 - 01:31
Hi Norman,

look at the permissions for IUSER on your web server (or equivalent
name). THat's the one doing the web stuff. Give it permission to access
your network (for security reasons, it doesn't have it by feault)

Best regards

--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting

Ready for you: WXShowroom.com, WXReplication (open source) and now WXEDM
(open source)

More information on http://www.fabriceharari.com


On 1/21/2016 9:47 AM, Norman wrote:
I have a multi-user WIndev application that uses shared Hyperfiles in a
folder. The application itself works fine.
I wrote some PHP code which I use on a IIS web page which uses the ODBC
connector to access some specific data within the Hyperfiles. Using
either a static IP or something like DynDns it is possible to get
restricted data access externally using this page. Again it works fine.

In fact it all works fine while the data folder is on the same computer
as the web server. It doesn't matter if its the C: drive or any drive
that is plugged in. The moment that the data is on our network NAS drive
it no longer works and I get an error accessing the data. The NAS drive
is a mapped drive. It works quite happily with the application.
I have altered the data directory in the OBDC (32bit) administrator and
in my connection string. All fine while using the local drives of C: to
G: but it fails the instant I use the mapped drive.
It strikes me as something to do with permissions but I turned UAC off
and it made no difference at all. We have three NAS drives and they all
give the same error. It's the same on a shared folder on another
computer. I even tried using the URL and the IP address of the NAS drive
in the connection string.

Has anyone had anything similar?