> Hello,
>  I am really struggling to connect to database, I am not sure how to
> ensure that I HAVE DBI sintalled and if not then how to make it
> activate
> it on my machine, I have perl installed but when I give the following
> command on my command prompt then
>
> perl -e 'use DBI; print $DBI::VERSION,"\n";'   it gives following
> errorcd c\
> Can't find string terminator "'" anywhere before EOF at -e line 1.

It works for me!
owen@owen-desktop:~$ perl -e 'use DBI; print $DBI::VERSION,"\n";'
1.607
owen@owen-desktop:~$

But you are on Windows, and there is always some problem with single
and double quotes.

I think windows does not allow single quotes, so try that with double
quotes, eg # perl -e "use DBI; print $DBI::VERSION,"\n";"







> Also when I am exccuting a database program it gives the following
> highlighted  error, any help on this will be higly appreciated...
> #!/usr/bin/perl -w
> use strict;
> use dbi();
> use lib;
>
>
> my $dbh = dbi->connect('dbi:Oracle:****',
>                         '****',
>                         '****',
>                       {
>                           RaiseError => 1,
>                           AutoCommit => 0
>                         }
>                       )|| die "Database connection not made:
> $dbi::errstr";
> my $sql = qq{ SELECT * FROM tab where rownum<3 };
> my $sth = $dbh->prepare( $sql );
> $sth->execute();
> $dbh->disconnect();
> Name "dbi::errstr" used only once: possible typo at C:\seven.pl line
> 14.
> Can't locate object method "connect" via package "dbi" at C:\seven.pl
> line 7.


Again, my lack of windows knowledge fails me, and maybe capitalization
doesn't matter, but the package is DBI, so I would have written,

use DBI;
...
my $dbh = DBI->connect('dbi:Oracle:****', ...

Again, perhaps the single quotes may cause a problem, try double
quotes if need be



Owen




Reply via email to