Howdy:
I want to move my perl script from Linux to Windows NT.
The Linux script connects to Oracle via the DBI modules I
have installed. I want to do the same on NT, but I'm not
sure if the connection strings / values are the same.
In the linux script:
[snip]
use strict;
use diagnostics;
use DBI;
use POSIX 'strftime';
my $host='192.168.1.100';
my $sid='testdb';
my $username='scott';
my $password='tiger';
my $datestr=strftime '%d%m%Y',localtime;
# connection option
my $dbh = DBI->connect("dbi:Oracle:host=$host;sid=$sid", $username,
$password, { RaiseError => 1 }) or die "Can not connect: $!";
[/snip]
Win:32 errors:
[errors]
D:\test\tmo_connect>test.pl
Use of uninitialized value in concatenation (.) or string at
D:/Perl/site/lib/DBI.pm line 584.
DBI connect('host=192.168.1.100;sid=testdb','scott',...) failed: at
D:\test\tmo_connect\test.pl line 19
Can not connect: at D:\test\tmo_connect\test.pl line 19.
[/errors]
Should this be the same? I had installed DBI 1.37 via
the ppm install DBI.ppd method. Looking at the 'query'
option, it says that DBI is installed and 'verify' says
it's up to date.
Question: Is there an example of how to connect to Oracle
(version 9.2.0.1) via Win:32?
Basically, what am I doing wrong?
Thanks in advance!
-X
