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

Using this code:
create table CEP (ID varchar(100) not null, MATRICULA varchar(200)) engine = federated connection = 'mysql://CEP:a423pa@172.16.90.220:1521/CEP/USUARIOS';
I created the table normally. The problem occurs when I try to select rows from table that I create. The error:
Error Code: 1429. Unable to connect to foreign data source: Lost connection to MySQL ser +ver at 'waiting for initial communic

Replies are listed 'Best First'.
Re^18: DBI connect to Oracle
by Corion (Patriarch) on Feb 24, 2015 at 17:29 UTC
      Yes, i think that the problems I had with Perl over. Now I have the following situation: - In the tutorial that I´m following, the author create a sample_proxy for SQLite and Postgres. But I need my proxy to Oracle.
      $ sample_proxy 'dbi:SQLite:test.db' 10306 > sqlite.log 2>&1 $ sample_proxy 'dbi:Pg:dbname=mydb' 11306 > pg.log 2>&1 &