Hello everybody,
Read my "Joke".
Working in WinNT4.0sp6+Apache1.3.14+PHP4.04pl1+Visual Fox Pro 6.0. Just now, my scripts work correctly. They connect to a .dbc Visual fox Pro file using ODBC. When the .dbc file is in the local machine, there are no problems. But when I try a DSN whi+
ch ODBC Driver points to a file on a network drive, the result is

[Microsoft][ODBC Visual FoxPro Driver]Can't open file \server\bd\mydatabase.dbc., SQL state S1000 in SQLConnect

But it happens only when the remote file is on a WINNT.
On Win95-98 it works.

I will be grateful if somebody helps me.

Regards,

    8 char filenames perhaps?

    Try NOT using php to connect to the odbc resource and see if you can get it.

    Another problem may be user permissions on the file on the network.

      it seem to be the NT service don't have permissions to read the file.
      try to add all local users with read permission to the folder and files.

        Thank you everybody (ziong let me be your fan!)
        As you've said, the NT service Apache had LocalSystem permissions which had not permissions to read a file in a remote machine. Of course, I solve it changing permissions of Apache service and let it works as a Administrator acount.
        Thank you everybody again.

        Best Regards,

          8 months later

          Thank you for your message!

          I had the same problem connecting from Domino server running on Windows 2000 Server to Visual Fox Pro database located on remote machine.

          I solved the problem your way, but the unwanted result of this action was that the Domino server console and other invoked programs were no longer visible locally.

          Bye!

          Bogdan

            Write a Reply...