Re^12: DBI connect to Oracle

[Corion]

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.

[Anonymous Monk]

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 = '????';

[Corion]

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

[Anonymous Monk]

Maybe. But do you know how to create the script to MySQL?