If it works locally and not over the network then it's a security problem.

What user account is your webserver running as? If it's LocalSystem then that's the problem, as LocalSystem doesn't have access to network resources.

    Originally posted by Vex
    If it works locally and not over the network then it's a security problem.

    What user account is your webserver running as? If it's LocalSystem then that's the problem, as LocalSystem doesn't have access to network resources.

    Hi
    i'm currently using apache 2, how do i set the account for the webserver?

      On windows 2000 it's done in the services admin control (Settings->Control Panel->Administrative Controls->Services). You can specify the logon user for each service, you'll need to give Apache2 a user account that has network access.

      On other OS I don't know.

        Originally posted by Vex
        On windows 2000 it's done in the services admin control (Settings->Control Panel->Administrative Controls->Services). You can specify the logon user for each service, you'll need to give Apache2 a user account that has network access.

        On other OS I don't know.

        Hi

        Spot on,

        Thanks very much for your help!

        Steve

          well, i have this:
          <?php $connect = odbc_connect('DSN-name', 'Username', 'Password') or die ("unable to connect");
          $query = "SELECT * FROM Title" ;
          $result = odbc_exec($connect, $query);

          while($row = odbc_fetch_array($result)) {
          $TitleID = $row[TitleID];
          $Title = $row[Title];
          echo $Title; }?>

          and the 1st part seems to work, but for the second part i get this:

          Call to undefined function: odbc_fetch_array()

          I am using a system dsn, so that works. ( note that you can never use a user dsn. those only respond to a user that directly opens the DB AND that user MUST be logged on/in. This does NOT apply to system DSNs)

            Well, if you've read the comments, they say it doesn't work, and to use a different function to do your fetch.

            Either that, or use the function given in the second comment as a work around....

              i think the fetch_into works, but theres this:[code]
              if (odbc_fetch_row($result))
              {while(odbc_fetch_into($result, $row, $my_array) )
              {echo $my_array['Title'];}}
              else {echo "Failed!";}[/code]
              this time it only gives an error on the $my_array. how do i solve this? (errormessage says it              s undifined...)

                What version of PHP are you using?

                  4.1 i think...

                  but never mind it anymore, i finally got the right code, and now i`m getting a script-time-out... thanks anyway. too bad, I already have so much data in my access file too. (from my asp site)

                  and i dont think theres a way to link access ables with MySql...

                    Write a Reply...