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

Thanks a lot for the help. My code:

#!/usr/bin/perl unixy
use DBI;
my $dbh = DBI->connect('dbi:ODBC:DSN=conexao220', 'CEP', 'a423pa');

[download]

The error message:

DBI connect('DSN=conexao220','CEP',...) failed: [Microsoft][ODBC Drive
+r Manager]
 Nome da fonte de dados nŅo encontrado e nenhum driver padrŅo especifi
+cado (SQL-
IM002) at C:\Documents and Settings\administrator\Meus documentos\conn
+ectionOrac
le.PL line 3

[download]

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

    So ODBC doesn't think that a data source does not exist under that name conexao220.

    If you are really, really sure that the name should exist, then my next guess is that you created the DSN under Windows 32bit ODBC (C:\Windows\System32\odbcad32.exe) but are using a 64bit Perl, or you created the DSN under Windows 64bit ODBC (C:\Windows\SysWOW64\odbcad32.exe), but are using a 32bit Perl.

    I would create two DSNs, conexao220-32 and <c>conexao220-64, using the two different programs and then check using the different Perl versions to find out which one can connect.

[reply]
[d/l]
[select]
      Great. Got my mistake: I was creating "archive data source". The correct is create a "user" or "system data source".

      Now, I have to create a table on mySQL, and I think that I have to use a Federated table, but I don“t know how. Maybe something like: 

      create table CEP3 
(ID varchar(100) not null, MATRICULA varchar(200)) 
engine = federated 
connection = '????';

      [download]
[reply]
[d/l]

        I think this is more an Oracle problem than a Perl problem.

[reply]

In Section Seekers of Perl Wisdom