Success -- MySQL / MyODBC replication

[michael d hoskins]

Yeah, you're right, the terminology in my last email wasn't technically
correct.  Yes, of course, ODBC is basically a standard API that needs
drivers to talk each database.

But, "PHP-compatible" was technically correct.  Just because there is
ODBC support in PHP does not mean that every ODBC product (even
Linux/Unix compatible ones) out there works with it.  You have to have
compatible include files and libraries for php/mod_php to hook into them
-- they still need the ability to compile on Linux/UNIX.  PHP needs to
support the particular product.

I just found that there are two that PHP hook into, OpenLink and iODBC.
(iODBC is an LGPL'ed product now maintained by OpenLink.)

There are also Linux/UNIX-compatible ODBC drivers for Postgres, MySQL,
etc., at the FreeODBC site, below (find "Drivers").  They both hook into
iODBC.

Commercial:
http://www.openlinksw.com

Free:
http://www.iodbc.org/ (Product)
http://www.iodbc.org/odbc-phpHOWTO.html (PHP HOWTO)
http://www.iodbc.org/odbc-phpHOWTO.html (Perl HOWTO)

Drivers, and other info:
http://users.ids.net/~bjepson/FreeODBC/

-----Original Message-----
From: watts [mailto:watts at jayhawks.net]
Sent: Monday, April 10, 2000 2:24 PM
To: kclug
Cc: watts
Subject: RE: kclug - Re: Success -- MySQL / MyODBC replication

On Mon, 10 Apr 2000, michael d hoskins wrote:

> This is true for Windoze, but what free, Open Source, PHP compatible
> ODBC product exists for Linux, other Unices?

"PHP compatible ODBC product" is incorrect.  ODBC is a database
abstraction interface.  That is, client apps like PHP can talk to it
without knowing anything about the backend database.  So PHP can talk to
a
MS SQL server, an Oracle server, and a PostgreSQL server without
changing
its code (other than to change where it's connecting to).  PHP has an
ODBC
interface, so it will (should) work with all database backends with ODBC
drivers.

ODBC drivers are clearly not in a web frontend's space.  That's in
database space.  Remember, ODBC drivers are database-specific...

The question is:  does PostgreSQL have an ODBC driver?  Does MySQL?  I'm
pretty sure PostgreSQL does, not sure about MySQL.

J.

o-----------------------------------o
| Jeffrey Watts                     |
| watts at jayhawks.net            o-------------------------------------o
| Systems Programmer            | "I entered the office and tossed my |
| Sprint - Systems Management   |  hat at the coat rack. It missed,   |
o-------------------------------|  hit the heater, and instantly      |
|  burst into flames. That reminded   |
|  me: I had some work to do in       |
|  Windows."                          |
|  -- Lincoln Spector                 |
|  "The Maltese Penguin"              |
o-------------------------------------o