Paul, Sure, email away. I'd hazard a guess that your syntax errors were due to not matching the threading of your OS.
And I recommend the OpenLink Multi-Tier ODBC drivers, from your architecture needs. They are available for a free download at http://www.openlinksw.com/main/softdld.htm. 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 6:08 PM > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] FreeBSD 4.2 and ODBC > > > 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] > > > -- 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]