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

Ok, that's one thing that you'll need - Oracle libraries on the Mysql machine to make DBD::Oracle work (unless the Windows installation comes with its own Oracle libraries). How did you install DBD::Oracle and what did the test results say?

Sorry - I don't have the experience with Windows and Oracle, so I'm guessing.

Another possibility would be to put the script on the Oracle machine and write to the Mysql machine, if it's easier to get DBD::mysql running on that machine.

Sometimes I can think of 6 impossible LDAP attributes before breakfast.

Replies are listed 'Best First'.
Re^4: DBI connect to Oracle
by Anonymous Monk on Feb 23, 2015 at 11:56 UTC

    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
[reply]
[d/l]
[select]

      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]

In Section Seekers of Perl Wisdom