porting to windows NT

[Shaunn Johnson]

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

[Jenda Krynicky]

From: "Johnson, Shaunn" <SJohnson6@bcbsm.com>

> 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.

They should be.

> 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.

Is also DBD::Oracle installed?

Jenda
===== [email]Jenda@Krynicky.cz[/email] === [url]http://Jenda.Krynicky.cz[/url] =====
When it comes to wine, women and song, wizards are allowed
to get drunk and croon as much as they like.
-- Terry Pratchett in Sourcery

[Tim]

Try running dbish or dbish.bat from the cmdline. It usually comes as part
of the dbi install and will tell you what drivers you've got and will let
you select, connect, and try out some SQL there. You can fine-tune your
params with it.



At 09:05 PM 1/26/04 +0100, you wrote:

>From: "Johnson, Shaunn" <SJohnson6@bcbsm.com>

> > 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.

>
>They should be.
>

> > 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.

>
>Is also DBD::Oracle installed?
>
>Jenda
>===== [email]Jenda@Krynicky.cz[/email] === [url]http://Jenda.Krynicky.cz[/url] =====
>When it comes to wine, women and song, wizards are allowed
>to get drunk and croon as much as they like.
> -- Terry Pratchett in Sourcery
>
>
>--
>To unsubscribe, e-mail: [email]beginners-unsubscribe@perl.org[/email]
>For additional commands, e-mail: [email]beginners-help@perl.org[/email]
><http://learn.perl.org/> <http://learn.perl.org/first-response>

[R. Joseph Newton]

"Johnson, Shaunn" wrote:

> 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]

It's way too early to be looking at system errors. You could waste a
lot of time casting about in the wrong direction.

First isolate which variables are undefined by taking the name-value
pairs in the connect line, assembling them and printing them one-by-one,
and see which one raises this unitinitialized variable warning. That
will give you a better idea of which part of the constructor call is
missing its intial value.

Joseph