Re^3: DBI connect to Oracle

[Ea]

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.

[Anonymous Monk]

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');

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

[Corion]

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

use DBI
my $dbh= ...

This should be:

use DBI;
my $dbh= ...

[Anonymous Monk]

Thanks a lot. This was one error. But it still didn't work, showing me the same message error.