Paul,
You can simply download the binary at www.iodbc.org and
configure --with-iodbc as per the HOWTO.
If you tried this and then got "undefined function" then this means you
didn't use the correct php binary or somesuch.
Ensure that ODBC support is compiled in by examining the output of a
phpinfo();
You will still need an ODBC driver, as iODBC is simple the Driver Manager
(enabling use of a driver).
To enable BSD to access an Excel spreadsheet will require the following
configuration.
BSD Client
------------------------
PHP --with-iodbc (using iODBC SDK, use non-threaded option if you get
pthread errors)
Client-side ODBC - OpenLink MT Client
DSN (in odbc.ini) configured with:
Host = windows box below
ServerType = odbc
Database = server-side DSN below ("foo")
Environment variables in your PHP script:
putenv("ODBCINI=path/to/odbc.ini");
putenv("LD_LIBRARY_PATH=path/to/odbcsdk/lib");
(ODBCINSTINI is optional)
Windows Server
----------------------------------------------------------------------------
---
Server-side ODBC: OpenLink MT "ODBC Agent" (choose Access in the selection
dropdowns)
"foo" - DSN configured with the Microsoft driver for Excel that can open the
spreadsheet
All components are available as free downloads from OpenLink's website.
Free support is available at http://www.openlinksw.com/support/suppindx.htm
Hope this helps!
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -----Original Message-----
> From: Paul G [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 15, 2002 5:29 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] FreeBSD 4.2 and ODBC
>
>
> Hi All,
>
> I'm just new to this list and I'm hoping somebody might have
> information leading to a PHP that can access an MS Excel
> Spreadsheet. FreeBSD 4.2, PHP 3.0.18 (for gif GD), Apache1.3.12.
>
> I have had no luck getting any of the ODBC functions to work with
> this OS (odbc_connect, php compiled with and without --with-iodbc
> switch results in "Fatal error: Call to unsupported or undefined
> function odbc_connect() "). I also had no luck compiling iODBC,
> which resulted in syntax errors and ultimately stoppage.
>
> Wondering if anybody has a gem out there. |:) Ever pull something
> like this off? Got any ideas?
>
> Thanks Alot!
>
> -Paul
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
