You can simply download the binary at 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

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

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:
        (ODBCINSTINI is optional)

Windows Server
Server-side ODBC: OpenLink MT "ODBC Agent" (choose Access in the selection
"foo" - DSN configured with the Microsoft driver for Excel that can open the

All components are available as free downloads from OpenLink's website.
Free support is available at

Hope this helps!

Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software
Universal Data Access & Data Integration Technology Providers

> -----Original Message-----
> From: Paul G [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 15, 2002 5:29 PM
> 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 (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to