RE: [PHP-DB] FreeBSD 4.2 and ODBC

2002-01-16 Thread Andrew Hill

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]




[PHP-DB] FreeBSD 4.2 and ODBC

2002-01-15 Thread Paul G

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



RE: [PHP-DB] FreeBSD 4.2 and ODBC

2002-01-15 Thread Andrew Hill

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

2002-01-15 Thread Paul G

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]