Thanks Martin,
After setting up the ODBC, I am trying to connect to the database, with a
script as below
-------------------
#!/usr/bin/perl
use strict;
use warnings;
use DBI;
my $dbh; # the database handle
my $dsn = "DBI:ODBC:orcl" ;
my $user = "dbuser";
my $pass = "dbpass";
#connect to the database
$dbh = DBI->connect ( $dsn, $user, $pass ) or die "Unable to connect:
$DBI::errstr\n";
-------------------
When I execute this logging in as a general user or user "oracle" I get error
like this -
--------
DBI connect('orcl','dbuser',...) failed: [unixODBC][Driver Manager]Can't open
lib '/u01/app/oracle/lib/hsdb_odbc.so' : libhsbase.so: cannot open shared
object file: No such file or directory (SQL-01000) at ./dbconnect.pl line 16
Unable to connect: [unixODBC][Driver Manager]Can't open lib
'/u01/app/oracle/lib/hsdb_odbc.so' : libhsbase.so: cannot open shared object
file: No such file or directory (SQL-01000)
--------
Something to do with permissions, because When I execute the script with root
login, the error is different -
------
DBI connect('orcl','dbuser',...) failed: [unixODBC][Driver Manager]Driver's
SQLAllocHandle on SQL_HANDLE_HENV failed (SQL-IM004)
------
I googled for the errors, and have confirmed that $PATH, $ORACLE_HOME and
$ORACLE_SID etc are set correctly for these users.
Any help appreciated!
Thanks!
-----Original Message-----
From: Martin Evans [mailto:[email protected]]
Sent: Monday, June 29, 2009 4:15 PM
To: Dhanashri Bhate
Cc: [email protected]
Subject: Re: Setting up ODBC connection on Linux for using DBD::ODBC
Dhanashri Bhate wrote:
> Hi All,
> I have been working on Windows with Oracle DB and Active Perl and done some
> DBI coding with DBD::ODBC.
> Now I need to move things over to Linux machine ( Red Hat Linux 4 and Oracle
> 10g.)
> I know this is not really a DBI question, but I thought I can get good help
> here,
> Can someone please tell me how I set up ODBC on Linux or point me to websites
> explaining this.
> Thanks a lot,
> DB
>
> DISCLAIMER
> ==========
> This e-mail may contain privileged and confidential information which is the
> property of Persistent Systems Ltd. It is intended only for the use of the
> individual or entity to which it is addressed. If you are not the intended
> recipient, you are not authorized to read, retain, copy, print, distribute or
> use this message. If you have received this communication in error, please
> notify the sender and delete all copies of this message. Persistent Systems
> Ltd. does not accept any liability for virus infected mails.
>
Linux/UNIX ODBC at
http://www.easysoft.com/developer/interfaces/odbc/linux.html
is a pretty good start at the background then
http://www.easysoft.com/developer/languages/perl/index.html has specific
DBD::ODBC stuff.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
DISCLAIMER
==========
This e-mail may contain privileged and confidential information which is the
property of Persistent Systems Ltd. It is intended only for the use of the
individual or entity to which it is addressed. If you are not the intended
recipient, you are not authorized to read, retain, copy, print, distribute or
use this message. If you have received this communication in error, please
notify the sender and delete all copies of this message. Persistent Systems
Ltd. does not accept any liability for virus infected mails.
