FreeTDS Development Group

["Nguyen, Thi X." <tnguyen AT powertv.com>]

Thank you John for the quick respone. I tried the easy way but still
have the same issue. Can you suggest another. TIA

-----Original Message-----
From: Jeff Jirsa [mailto:JJirsa AT officite.com] 
Sent: Friday, November 03, 2006 8:21 AM
To: freetds AT lists.ibiblio.org
Subject: [freetds] Version 0.64 and PHP

hi

Nguyen, Thi X. wrote:
> install_driver(ODBC) failed: Can't load
>
'/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/ODBC/OD
> BC.so' for module DBD::ODBC: libodbc.so.1: cannot open shared object
> file: No such file or directory at
> /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
>  at (eval 10) line 3

i think the problem is that the cron script can't find libodbc.so.1

there are several way to fix this.

a relatively easy way is to add the directory that this file 
[libodbc.so.1] sits in to the environment variable LD_LIBRARY_PATH. you 
might even be able to do this in your script before calling
DBI->connect()

$ENV{LD_LIBRARY_PATH} = '/path/to/library';

good luck!

-- 
\js
 



     - - - - - Appended by Scientific Atlanta, a Cisco company - - - - - 
This e-mail and any attachments may contain information which is 
confidential, proprietary, privileged or otherwise protected by law. The 
information is solely intended for the named addressee (or a person 
responsible for delivering it to the addressee). If you are not the intended 
recipient of this message, you are not authorized to read, print, retain, 
copy or disseminate this message or any part of it. If you have received this 
e-mail in error, please notify the sender immediately by return e-mail and 
delete it from your computer.