Hi Silvia,

You first need to link your PHP/Apache install in Linux against an ODBC
Driver Manager.
You may obtain the iODBC Driver Manager at www.iodbc.org and follow the
HOWTO on that site for linking with PHP.

Then you will need a Driver - I suggest you download OpenLink's Multi-Tier
Driver, and use the ODBC Agent on the Windows box.
After you install the MT Driver, with client components on the Linux box and
server components on the Win box:
        1. create a DSN on the Win box using the MS Driver for Access.  for this
example let's name it "foo".
        2. create a DSN on the Linux box, either in the OpenLink Admin pages
(http://servername:8000) or simply by editing the relevant odbc.ini.
Configure the DSN as usual, except specify ServerType = ODBC, Hostname = [ip
of Win box], and Database = foo.

If you require assistance, free support is available at

Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software  http://www.openlinksw.com
Universal Data Access & Virtuoso Universal Server

> -----Original Message-----
> From: Silvia Mahiques [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 10, 2002 4:07 AM
> Subject: [PHP-DB] how connect a remote data base MSAccess with PHP in
> Linux system
> Hi friend!
> I have a question...
> I have a remote database in Microsoft Access on a WinNT System,
> and a Apache and PHP on Linux System. How can I connect this?
> There is one function in PHP for make this:
> odbc_connect(DSN,user,password)
> The question is:  what is DSN in my case? How I can to specified
> the host and path where is situate the data base?
> DSN (Data Source Name) in local host is the name of the DataBase,
> but in remote host, what I need do?
> Thanks in advance.
> Silvia Mahiques

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to