From: <sinisa Date: March 13 1999 11:47pm Subject: connecting with myodbc List-Archive: http://lists.mysql.com/mysql/184 Message-Id: <14058.63779.381141.173542@monster.local.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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 > > 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 | +---------------------------------------------------------------------+