Re^4: DBI connect to Oracle

[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.

[Corion]

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.