in reply to Re^3: DBI connect to Oracle
in thread DBI connect to Oracle

Thanks a lot for the help. Now I solved the first problem that was the message that said that "no execution mode was defined".

To solve this, i just put in the first line of my script: #!/usr/bin/perl unixy

And than i saved it as a ".PL" archive.

Keeping trying to connect my database, now I have the following Script: 

#!/usr/bin/perl unixy 
use DBI
my $dbh = DBI->connect('dbi:ODBC:host=172.16.90.220;sid=WEBDB;port=152
+1', 'CEP', 'a423pa');

[download]

But when i run the script, i got the following error:

DBI connect('host=172.16.90.220;sid=WEBDB;port=1521','CEP',...) failed: [Microsoft][ODBC Driver Manager] Nome da fonte de dados não encontrado e nenhum driver padrão especificado (SQL-IM002) at C:\Documents and Settings\administrator\Meus documentos\connectionOracle.PL line 3"" is not exported by the DBI module

Replies are listed 'Best First'.
Re^5: DBI connect to Oracle
by Corion (Patriarch) on Feb 23, 2015 at 12:02 UTC

    You are missing a semicolon in the first line of your program:

    use DBI
my $dbh= ...

    [download]

    This should be:

    use DBI;
my $dbh= ...

    [download]
[reply]
[d/l]
[select]
      Thanks a lot. This was one error. But it still didn't work, showing me the same message error.
[reply]

        I don't believe you. Please show the actual (minimal) code you're running that exhibits the problem. The relevant code should be no longer than 10 lines.

[reply]

In Section Seekers of Perl Wisdom