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
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]
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-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
