[unixODBC-support] Issue with PHP4.3.5 on RH

Barry Steele barry at hpfm.com.au
Mon Oct 25 15:48:33 BST 2004


Hi,
I recently install unixodbc on a RH9.0 server.  I have managed to set it
and use the DataManager and isql apps to get a connect to an MSSQL server.

I do however hit the error  below whenever I try to run the following code

<?php
require "PEAR.php";
 $msconnect = odbc_connect ("name", "user", "passwd") or die ("Could not
connect to database: ".odbc_errormsg());
 if ($sql)
 	echo "We got in<br>";

$msdb=odbc_select_db("nemesys",$msconnect) or die ("Could not use
SLSV_Members database");
$msquery = "select count(*) from  Members";

$rowsQry= 'select count(*) from dbo.Members';
$Countresults= odbc_exec($rowsQry);
$rows = odbc_fetch_array($Countresults);
echo "We have ".$rows[0]. " Records<br>";
?>


<output>

Warning: odbc_connect(): SQL error: [unixODBC][Driver Manager]Can't open
lib '/usr/local/lib/libtdsodbc.so' : libodbcinst.so.1: cannot open shared
object file: No such file or directory, SQL state 01000 in SQLConnect in
/www/sites/slsa/SLSA_Members/tests/mssqlquery.php on line 3
Could not connect to database: [unixODBC][Driver Manager]Can't open lib
'/usr/local/lib/libtdsodbc.so' : libodbcinst.so.1: cannot open shared
object file: No such file or directory

</output>

Any thoughts?

Thanks
-- 
Stay happy, stay well ... get involved
Barry Steele
www.hpfm.com.au
mob: +61 413 947980
off: +61 2 99816520
fax: +61 2 9981 7806




More information about the unixODBC-support mailing list