Subject RE: [firebird-support] unixODBC driver - newbie tearing his hair out!
Author Nick Critten
> >>> Why not use the native interbase functions of PHP ?
> >> Long Story, but Recompiling PHP on this box is more
> trouble than its
> >> worth.
> >
> > You don't have to recompile PHP, you can simply compile the needed
> > interbase.so file and add it to your "extensions"
> directory. You can
> > even do the compilation on another computer.
>
> I can confirm it's easy, I did the same for Red Hat 9.
>
> Just download or install the sources of the RH php package,
> configure && make, find the interbase.so file in the
> ext/interbase directory and copy it over to the right place
> and include it in php.ini
>
> >> There don't seem to be any PHP RPMs with Interbase support
> compiled
> >> in for Fedora Core 4 so that leaves me with the ODBC route.
> >>
> >> Plus the Database I need to connect to is likely to change
> to Oracle
> >> or MS-SQL in the near future, and I'd rather write the
> code so it'll
> >> work with them all. If and when it happens.
> >
> > You should use ADOdb or ezSQL then. Those are wrappers
> around native
> > interfaces, so you can switch between DBMSes easily.
> >
> > I suggest you join firebird-php group if you wish to get more info
> > about all this.
>

Thankyou both, I'll look into it.
I'm still a semi-newbie to Linux so some aspects of compiling etc are a
little bewildering..
I now have the connection working fine using unixODBC, but I'll look
into what you both have suggested for future projects.

Many Thanks,

Nick

"Any of the statements or comments made above should be regarded as personal and not necessarily those of Velindre NHS Trust, any constituent part or connected body

Dylai'r datganiadau neu'r sylwadau uchod gael eu trin fel rhai personol ac nid o reidrwydd fel datganiadau neu sylwadau gan Ymddiriedolaeth GIG Felindre, unrhyw ran ohono neu unrhyw gorff sy'n gysylltiedig a'r Ymddiriedolaeth".