RE: [PHP] ODBC

Ashley, Sure, you can install OpenLink's Multi-Tier ODBC Driver. There are many people who have had success using this architecture: 1. install the drivers, client side on Linux, server side on Windows 2. create a DSN on the Windows box using the MS Access driver, let's call it "foo" for this example. 3. create a DSN on the Linux box, with ServerType = ODBC and Database = foo 4. all other DSN settings on the Linux box should be self-explanatory, but be sure to set the appropriate environment variables in your PHP script using putenv(). These include LD_LIBRARY_PATH and ODBCINI - see the HOWTO at http://www.iodbc.org/odbc-phpHOWTO.html for putenv() examples and an understanding of the architecture. Let me know if you experience problems. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Virtuoso Universal Server -----Original Message----- From: Ashley M. Kirchner [mailto:ashley@pcraft.com] Sent: Friday, August 02, 2002 1:34 PM To: PHP-General List Subject: [PHP] ODBC Can PHP be used on an Apache server (linux) to connect to a (remote) MS Access server (NT) through ODBC? If so, does anyone have examples of how this is done? And if not, what other choices do I have? -- W | I haven't lost my mind; it's backed up on tape somewhere. +-------------------------------------------------------------------- Ashley M. Kirchner <mailto:ashley@pcraft.com> . 303.442.6410 x130 IT Director / SysAdmin / WebSmith . 800.441.3873 x130 Photo Craft Laboratories, Inc. . 3550 Arapahoe Ave. #6 http://www.pcraft.com ..... . . . Boulder, CO 80303, U.S.A. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php