Re: [mdb-dev] Re: ODBC PHP DB2 Help!

[Jeff S. <why...@ya...>]

It appears that when compiling PHP, this time it compiled against iODBC rather
than DB2Connect or unixODBC.

This page should help out in compiling PHP to use unixODBC.  It is a little
out of date, but steps 2, 3, and 4 should be essentially correct.

  http://www.unixodbc.org/doc/php3.html


If unixODBC is installed in the default place, you can put odbc.ini and
odbcinst.ini in /etc or perhaps /usr/local/etc.

odbcinst.ini contains *driver* configurations (e.g. mdbtools, MySQL, DB2)
odbc.ini contains configuration for System DSN's.
$HOME/.odbc.ini contains configuration for User DSN's.

If I used any terminology you are still unsure about, I would be glad to
go into more detail.

 -- Jeff Smith


--- Shannon Sumner <SS...@co...> wrote:
> Hello all,
> 
> I still could use your help.  I tried compiling PHP with UnixODBC instead of
> DB2 and then use UnixODBC to talk to DB2, but I received an "iODBC" error
> instead of my "[IBM][CLI Driver]" error.  I realize that I do not understand
> ODBC at all.  I'm not sure where to put my "odbc.ini" file (or should it be
> ".odbc.ini") and I'm not sure what's the difference between this file and
> the "odbcinst.ini" file.  Can someone direct me to a tutorial regarding this
> or perhaps explain it to me.  I'm sure this is a large part of my problem.
> Also, is there a way to test my connection to databases without having to
> recompile PHP?  I hate to take down my sites even for a half an hour if I
> don't have too.
> 
> Thanks,
> 
> Shannon D. Sumner 
> Webmaster
> Country Curtains Inc. 
> 413-243-1474
> www.countrycurtains.com

__________________________________
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html