RE: [PHP] newbie question about odbc_connect

[Andrew Hill]

Johannnes,

To enable ODBC support in PHP on Linux, configure --with-iodbc per the HOWTO
at www.iodbc.org.
This will link PHP against an ODBC Driver Manager, but you will still
require an ODBC Driver.

If you cannot obtain an ODBC driver for FMPro for Linux, you can use the
OpenLink Multi-Tier ODBC Driver and piggyback it on the FMPro DSN on the
server. eg:

1. create a DSN on the FMPro server (I assume either Windows or Mac OS X?)
that we'll call foo for this example.
2. install the OpenLink Multi-Tier driver with Linux as your client, and
FMPro box as server.  Ensure that you install the ODBC agent on your server
platform (this is a non-database specific database agent).
3. create a DSN on your Linux box, specifying ServerType = ODBC, Hostname =
[FMPro server IP address], Database = foo
All other parameters should be self-explanatory.

Note - you may also use the above method to piggyback a Linux ODBC DSN onto
a local or remote JDBC Driver instead of an ODBC driver; let me know if you
require assistance.

Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software  http://www.openlinksw.com
Universal Data Access  Data Integration Technology Providers

 -Original Message-
 From: Johannes Ambrose [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, November 13, 2001 7:22 PM
 To: [EMAIL PROTECTED]
 Subject: [PHP] newbie question about odbc_connect


 Hi,
 I've been happily using mysql_connect() for various scripts on a linux
 box. Now I'd like to connect to a filemaker pro database using
 odbc_connect(). However, the response I get is Call to undefined
 function.

 Do I need to compile odbc support? (I thought it was built in.)

 Is there an include file somewhere that I need to specifiy?

 regards


 --
 Johannes Ambrose
 Computer Systems Manager
 School of Life Sciences
 University of Queensland, Brisbane Australia
 ph: 07 3365 4826 fax:3365 1655 mob: 0401 714 835



 --
 PHP General 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 General 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] newbie question about odbc_connect

[David Robley]

On Wed, 14 Nov 2001 10:51, Johannes Ambrose wrote:
 Hi,
 I've been happily using mysql_connect() for various scripts on a linux
 box. Now I'd like to connect to a filemaker pro database using
 odbc_connect(). However, the response I get is Call to undefined
 function.

 Do I need to compile odbc support? (I thought it was built in.)

 Is there an include file somewhere that I need to specifiy?

 regards


 --
 Johannes Ambrose
 Computer Systems Manager
 School of Life Sciences
 University of Queensland, Brisbane Australia
 ph: 07 3365 4826 fax:3365 1655 mob: 0401 714 835

You'll need to recompile and specify odbc support in your configure 
flags. You'll also need to get hold of some odbc software - check the 
manual for some sources at this link
 http://au2.php.net/manual/en/install.configure.php#install.configure.data
bases

There are several odbc options - I don't know which is better or worse 
but a search through the mail archives will probably turn up some recent 
discussion.


-- 
David Robley  Techno-JoaT, Web Maintainer, Mail List Admin, etc
CENTRE FOR INJURY STUDIES  Flinders University, SOUTH AUSTRALIA  

   I won't rise to the occasion, but I'll slide over to it.

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