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]