Re: Troubles in ODBC Land

Okay, I uninstalled unixODBC and tried iODBC ( I actually began to try it before, but then thought of something that might work on unixODBC, so I went back to it ). Now iODBC's odbctest application works with myODBC installed. However, after I recompile PHP with iodbc parameters, I try to run the odbc_connect function. If I misspell the DSN or use a non-existent one, I will get the following message: Warning: SQL error: [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded, SQL state IM002 in SQLConnect Now, if I spell the defined DSN correctly and reload the page, the application just hangs. If I look at my error logs I see this: /usr/libexec/ld-elf.so.1: /usr/local/lib/libmyodbc.so: Undefined symbol "pthread_mutex_init" Once for every time I reload the page. This is odd, because this was a problem message I was receiving when testing unixODBC on the command line. After I installed iODBC, the command-line application was able to connect and query perfectly! So what gives? Why does one application work and another does not? I set the following environment vars - some may not make sense, but I've been trying everything: $EnvVars["LD_LIBRARY_PATH"] = "/usr/local/lib:/usr/include"; $EnvVars["LD_RUN_PATH"] = "/usr/local/lib:/usr/include"; $EnvVars["ODBCINI"] = "/usr/local/src/odbcsdk/doc/odbc.ini"; $EnvVars["PATH"] = "/sbin:/bin:/usr/sbin:/usr/bin:/usr/games:/usr/local/bin:/usr/X11R6/bin:/hom e/suroot/bin:/usr/libexec:/usr/include"; foreach($EnvVars as $Key => $Val) { putenv("$Key=$Val"); $HTTP_ENV_VARS["$Key"] = $Val; } I can see via phpinfo() that they are getting set. Any more ideas? - Jonathan "Jonathan Hilgeman" <jhilgeman@ecx.com> wrote in message news:20010827203215.44345.qmail@pb1.pair.com... > I'm on a FreeBSD 4.2 box running Apache 1.3.14+OpenSSL with mod_php4 > (4.0.3). I am attempting to set up ODBC for this box, and it's giving me > problems. > > First, I installed unixODBC (www.unixodbc.org), which went fairly smooth. > Second, I installed myODBC for UNIX via the ports directory, which also > seemed to install fine. > Third, I modified the mod_php4 Makefile to include --with-unixODBC and > compiled it. Everything seemed to go through fine, and Apache restarted at > the end. > > When I went to test the function, I got a "Page Cannot be Displayed" error > (IE 5.5). If I try removing the line that uses odbc_connect(...), it will > print out the request variables. Only when odbc_connect is present in the > code, will it break. > > $conn_id=odbc_connect(); > > I have tried this with a DSN name and a username and password, but it does > not work. Any ideas, anyone? > > - Jonathan > >