Mir S Islam writes:
> Hi, I am trying to use the ODBC functions of mysql on UNIX (Linux).
> Everything is installed fine. I have compiled the support in PHP3 and
> using that to query the database. It queries fine but only to localhost.
> It looks like that the driver is ignoring the "SERVER" entry in the
> iodbc.ini file. All the time the php script is connecting to "localhost"
> only, regardless of the entry in the DSN. ANy idea why and how it can be
> fixed ?
> Thanks much
>
> mysql=3.22.19b
> php=3.07
> iodbc=iodbc-2.50.22
> part of my iodbc.ini (yes it is the right file and being looked up
> during the script run)
>
> [psp]
> Trace = Off
> TraceFile= stderr
> Driver = /usr/local/lib/mysql/libmyodbc_mysql.so
> DSN = psp
> SERVER = host.net
> #UID = maruzz
> #PWD = maru_pwd
>
> <MIr>
Hi!
I do not understand why would anyone use ODBC for client / server on
the very same machine.
Furthermore, I do not think that PHP3 can be configured to use ODBC
protocol on *nix to access MySQL, I am not using PHP, but there is no
reason why anyone would waste time on that.
Furthermore, to access ODBC servers by apps on Linux, you should
install iODBC package.
Sinisa
+---------------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ == mysql@stripped |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sinisa@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Belgrade |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|_____ Serbia |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+---------------------------------------------------------------------+
