One more issue:
When using this:
use DBI;
my $connect_string="DBI:Oracle:$SERVICE";
my $dbh = DBI->connect($connect_string,$oracle_user,$oracle_password,
{ AutoCommit=> 0, LongTruncOk=> 'TRUE', PrintError => 1,
ChopBlanks=> 'TRUE',LongTruncOk=> 'TRUE',LongReadLen=> 50000, RaiseError =>
1 }) or die "connecting: $DBI::errstr";
I and getting this annoying message:
You must install a Solaris patch to run this version of the Java runtime.
Please see the README and release notes for more information.
Exiting
I am jdk1.3. I have installed all the recommended patches in the
README.sparc file but no luck. Also this connect string works in other
scripts with in the application.
-----Original Message-----
From: John W. Krahn [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 06, 2002 4:55 PM
To: [EMAIL PROTECTED]
Subject: Re: connection error
Lance Prais wrote:
>
> I am getting a connection error. I used this same connection string all
> though out my scripts in this application without problems except in this
> case. Does anyone know why I could be getting this error?
>
> Connection String:
> use DBI;
>
> my $connect_string="DBI:Oracle:$SERVICE";
^^^^^^^^^^^^^^^^^^
You are creating a new variable $connect_string and assigning a value to
it.
> my $dbh = DBI->connect(my $connect_string,my $oracle_user,my
$oracle_password,
^^^^^^^^^^^^^^^^^^
The my() here is redeclaring the variable $connect_string, in other
words it is setting it's value to undef. The same is happening to
$oracle_user and $oracle_password.
> { AutoCommit=> 0, LongTruncOk=> 'TRUE', PrintError => 1,
> ChopBlanks=> 'TRUE',LongTruncOk=> 'TRUE',LongReadLen=> 50000, RaiseError
=>
> 1 }) or die "connecting: $DBI::errstr";
>
> Error Message:
> Can't connect( HASH(0xf696c)), no database driver specified and DBI_DSN
> env var not set at ./daily_sr.pl line 19
John
--
use Perl;
program
fulfillment
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
