Thanks Andrew,
I will attempt this in the morning. Is it okay with you if I email you on
the iODBC stuff? PHP was compiled like so:
Configure command: ./configure '--with-apxs=/usr/local/apache/1.3/bin/apxs'
'--with-config-file-path=/usr/local/lib' '--with-system-regex'
'--enable-track-vars' '--enable-trans-sid' '--enable-versioning'
'--with-ttf' '--with-ftp' '--with-gd=/usr/local' '--enable-memory-limit'
'--enable-fast-install' 'with-iodbc=/usr/local/src/odbcsdk'
php3.ini file path is set to: /usr/local/lib
(iODBC resulted in syntax errors last time I tried. I am new to this I
should emphasize!) Also, any ODBC driver you would recommend?
-Paul
----- Original Message -----
From: "Andrew Hill" <[EMAIL PROTECTED]>
To: "Paul G" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, January 15, 2002 2:37 PM
Subject: RE: [PHP-DB] FreeBSD 4.2 and ODBC
> 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]
>
>
--
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]
