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

I guess that you can find the answer in the MySQL documentation. Or maybe you can pay an Oracle consultant to answer your question.

What error message did you get, or how else did MySQL fail to do what you want?

Replies are listed 'Best First'.
Re^17: DBI connect to Oracle
by Anonymous Monk on Feb 24, 2015 at 17:19 UTC
    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
        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 &