Jason,
One option you have is to install OpenLink's Multi-Tier driver, ODBC
Agent, which will allow you to "piggyback" on DSNs on other machines,
e.g:
webserver with PHP, client side MT driver
DSN (let's call it "local_dsn") with ODBC as ServerType, and IDS as Name
db server with MS Access, server side MT driver
DSN called IDS using MS driver for Access.
so:
PHP-->local_dsn in client side MT--------------------->server side MT
driver--->ODBC Agent--->IDS DSN----.mdb file.
Selecting the appropriate platforms and database at the OpenLink
"Software Availability" link will lead you to the appropriate components.
Let me know if you need additional clarification, although this example
is pretty well laid out in the OpenLink MT docs.
Cheers,
Andrew
On Friday, August 9, 2002, at 04:48 PM, Jason Morcom wrote:
> Forgive my ignorance but i can not find how to connect to an Access 2000
> (mdb) file through PHP if the file is on another computer in a lan (not
> on
> same computer as Apache/PHP server) I have no problem connectig to an
> mdb
> through ODBC and a valid DSN(system) for a local mdb file, but i get a
> general error (see below) when the DSN points to a file through a mapped
> drive "R:\file.mdb" or an actual path "\ \server\dir\dir\file.mdb"
> {{{
> Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The
> Microsoft
> Jet database engine cannot open the file '(unknown)'. It is already
> opened
> exclusively by another user, or you need permission to view its data.,
> SQL
> state S1000 in SQLConnect in c:\apache\htdocs\www\php\tmpa2w9rldsv.php
> on
> line 1
> }}}
> I have no passwords on this file and its not being used exclusively by
> anyone.
>
> Here is my PHP code:
> <?php $connect = odbc_connect("IDS","","");
>
> The "IDS" is of course a valid system DSN. I have used this DSN by
> Crystal
> Reports with no problems. And i am not using the file when i do my PHP
> tests.
>
> There is no username or password in the DSN as i assume i do not need
> one. I
> can only assume i have to pass some sort of authorization string with
> the
> ODBC connect or i just cant do it this way. I've heard many things about
> using IIS for the server but I am using Apache on Win2k and don't wish
> to
> change. If it matters the file i need to access is on a Win NT 4 server
> but
> its just a shared folder with the correct permissions.
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
