in reply to Database access

You forgot to specify the user and password to access the DB. The connect call took the anonymous hash specifying the options as the username, hence the rather funky error. Try this: 
my $dbh = DBI->connect("dbi:ODBC:test", $user, $pass,
{ 'AutoCommit' =>1, 'RaiseError' =>1}) || die "Error connecting: '$DBI
+::errstr'";
# Assuming the username and password to connect to the DB are in $user
+ and $pass, respectively.

[download]

CU
Robartes-

Replies are listed 'Best First'.
Re: Re: Database access
by Ananda (Pilgrim) on Nov 19, 2002 at 11:36 UTC
    Hey Robertes,

    Thanks for the quick response. I tried what you suggested and the result is 

    Global symbol "%pass" requires explicit package name at test_database.
+pl line 8.

Execution of test_database.pl aborted due to compilation errors.

    [download]
    Ananda
[reply]
[d/l]
      Good, it looks like you are using strict judging from the error message. I'm thinking you probably wanted to use $pass and not %pass and you also probably forgot to declare the variable with my. Please post the code so we can take a peek.

      -- vek --
[reply]
[d/l]
[select]
      hi,
      would you be so kind and post your new script.
      May be we can help you.
[reply]

In Section Seekers of Perl Wisdom