RE: [PHP-DB] FreeBSD 4.2 and ODBC
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]
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]
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]
