It looks like you are mixing threaded and non-threaded libraries.
I assume PHP is non-threaded here, ensure you are using the non-threaded
version of iODBC and check with your MyODBC driver maintainer for a
libmyodbc.so that is non-threaded.
Also, you may wish to just post these question on the DB list - the cross
post to the general list isn't necessary.
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -----Original Message-----
> From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 28, 2001 11:26 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP] iODBC Troubles
> I first tried unixODBC in order to get ODBC functionality on my
> FreeBSD 4.2
> box with PHP 4.0.3 on Apache 1.3.14. It didn't work too well, and I kept
> getting an error about undefined symbols like pthread_mutex_init or
> something when trying to run command-line sample applications. So someone
> suggested I use iODBC instead and I responded:
> 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
> 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
> 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"] =
> foreach($EnvVars as $Key => $Val)
> $HTTP_ENV_VARS["$Key"] = $Val;
> I can see via phpinfo() that they are getting set. Any more ideas?
> - Jonathan
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]