Tema: reporte/almacén con datos de postgresql+mysql
Ver Mensaje Individual
  #10 (permalink)  
Antiguo 30/11/2007, 08:37
cacr
 
Fecha de Ingreso: agosto-2005
Ubicación: Mérida, Venezuela
Mensajes: 732
Antigüedad: 18 años, 8 meses
Puntos: 7
Re: reporte/almacén con datos de postgresql+mysql
y me devolvió:

Código: 
CONTEXT:  sentencia SQL: «SELECT dbi_link.dbi_link_init()»
NOTICE:  Setting get_dbh in %_SHARED hash. at line 25.

CONTEXT:  sentencia SQL: «SELECT dbi_link.dbi_link_init()»
NOTICE:  Setting remote_exec_dbh in %_SHARED hash. at line 25.

CONTEXT:  sentencia SQL: «SELECT dbi_link.dbi_link_init()»
NOTICE:  SELECT dbi_link.set_up_connection(
    'dbi:mysql:database=sir;host=localhost',
    'root',
    '',
    '---
AutoCommit: 1
RaiseError: 1
',
    NULL,
    NULL,
    NULL,
    'sir'
)

NOTICE:  SELECT count(*) AS "driver_there"
FROM dbi_link.available_drivers()
WHERE available_drivers = 'dbi:mysql:database=sir;host=localhost'

CONTEXT:  sentencia SQL: «SELECT dbi_link.set_up_connection(
    'dbi:mysql:database=sir;host=localhost',
    'root',
    '',
    '---
AutoCommit: 1
RaiseError: 1
',
    NULL,
    NULL,
    NULL,
    'sir'
)
»
NOTICE:  Checking whether 'dbi:mysql:database=sir;host=localhost' has table_info... at line 59.

CONTEXT:  sentencia SQL: «SELECT dbi_link.set_up_connection(
    'dbi:mysql:database=sir;host=localhost',
    'root',

    '',
    '---
AutoCommit: 1
RaiseError: 1
',
    NULL,
    NULL,
    NULL,
    'sir'
)
»
NOTICE:  'dbi:mysql:database=sir;host=localhost' has table_info :) at line 61.

CONTEXT:  sentencia SQL: «SELECT dbi_link.set_up_connection(
    'dbi:mysql:database=sir;host=localhost',
    'root',
    '',
    '---
AutoCommit: 1
RaiseError: 1
',
    NULL,
    NULL,
    NULL,
    'sir'
)
»
NOTICE:  Checking whether 'dbi:mysql:database=sir;host=localhost' has column_info... at line 59.

CONTEXT:  sentencia SQL: «SELECT dbi_link.set_up_connection(
    'dbi:mysql:database=sir;host=localhost',
    'root',
    '',
    '---
AutoCommit: 1
RaiseError: 1
',
    NULL,
    NULL,
    NULL,
    'sir'
)
»
NOTICE:  'dbi:mysql:database=sir;host=localhost' has column_info :) at line 61.

CONTEXT:  sentencia SQL: «SELECT dbi_link.set_up_connection(
    'dbi:mysql:database=sir;host=localhost',
    'root',
    '',
    '---
AutoCommit: 1
RaiseError: 1
',
    NULL,
    NULL,
    NULL,
    'sir'
)
»
NOTICE:  Checking whether 'dbi:mysql:database=sir;host=localhost' has quote... at line 59.

CONTEXT:  sentencia SQL: «SELECT dbi_link.set_up_connection(
    'dbi:mysql:database=sir;host=localhost',
    'root',
    '',
    '---
AutoCommit: 1
RaiseError: 1
    '',
    '---
AutoCommit: 1
RaiseError: 1
',
    NULL,
    NULL,
    NULL,
    'sir'
)
»
NOTICE:  'dbi:mysql:database=sir;host=localhost' has table_info :) at line 61.

CONTEXT:  sentencia SQL: «SELECT dbi_link.set_up_connection(
    'dbi:mysql:database=sir;host=localhost',
    'root',
    '',
    '---
AutoCommit: 1
RaiseError: 1
',
    NULL,
    NULL,
    NULL,
    'sir'
)
»
NOTICE:  Checking whether 'dbi:mysql:database=sir;host=localhost' has column_info... at line 59.

CONTEXT:  sentencia SQL: «SELECT dbi_link.set_up_connection(
    'dbi:mysql:database=sir;host=localhost',
    'root',
    '',
    '---
AutoCommit: 1
RaiseError: 1
',
    NULL,
    NULL,
    NULL,
    'sir'
)
»
NOTICE:  'dbi:mysql:database=sir;host=localhost' has column_info :) at line 61.

CONTEXT:  sentencia SQL: «SELECT dbi_link.set_up_connection(
    'dbi:mysql:database=sir;host=localhost',
    'root',
    '',
    '---
AutoCommit: 1
RaiseError: 1
',
    NULL,
    NULL,
    NULL,
    'sir'
)
»
NOTICE:  Checking whether 'dbi:mysql:database=sir;host=localhost' has quote... at line 59.

CONTEXT:  sentencia SQL: «SELECT dbi_link.set_up_connection(
    'dbi:mysql:database=sir;host=localhost',
    'root',
    '',
    '---
AutoCommit: 1
RaiseError: 1
',
    NULL,
    NULL,
    NULL,
    'sir'
)
»
NOTICE:  'dbi:mysql:database=sir;host=localhost' has quote :) at line 61.

CONTEXT:  sentencia SQL: «SELECT dbi_link.set_up_connection(
    'dbi:mysql:database=sir;host=localhost',
    'root',
    '',
    '---
AutoCommit: 1
RaiseError: 1
',
    NULL,
    NULL,
    NULL,
    'sir'
)
»
NOTICE:  INSERT INTO dbi_link.dbi_all_connection_info (
    data_source,
    user_name,
    auth,
    dbh_attributes,
    dbi_connection_environment,
    remote_schema,
    remote_catalog,
    local_schema
) VALUES (
    'dbi:mysql:database=sir;host=localhost',
    'root',
    '',
    '---
AutoCommit: 1
RaiseError: 1
',
    NULL,
    NULL,
    NULL,
    'sir'
)

CONTEXT:  sentencia SQL: «SELECT dbi_link.set_up_connection(
    'dbi:mysql:database=sir;host=localhost',
    'root',
    '',
    '---
AutoCommit: 1
RaiseError: 1
',
    NULL,
    NULL,
    NULL,
    'sir'
)
»

ERROR:  error from Perl function: error from Perl function: llave duplicada viola restricción unique «dbi_connection_data_source_key» at line 94. at line 35.



',
    NULL,
    NULL,
    NULL,
    'sir'
)
»
NOTICE:  'dbi:mysql:database=sir;host=localhost' has quote :) at line 61.

CONTEXT:  sentencia SQL: «SELECT dbi_link.set_up_connection(
    'dbi:mysql:database=sir;host=localhost',
    'root',
    '',
    '---
AutoCommit: 1
RaiseError: 1
',
    NULL,
    NULL,
    NULL,
    'sir'
)
»
NOTICE:  INSERT INTO dbi_link.dbi_all_connection_info (
    data_source,
    user_name,
    auth,
    dbh_attributes,
    dbi_connection_environment,
    remote_schema,
    remote_catalog,
    local_schema
) VALUES (
    'dbi:mysql:database=sir;host=localhost',
    'root',
    '',
    '---
AutoCommit: 1
RaiseError: 1
',
    NULL,
    NULL,
    NULL,
    'sir'
)

CONTEXT:  sentencia SQL: «SELECT dbi_link.set_up_connection(
    'dbi:mysql:database=sir;host=localhost',
    'root',
    '',
    '---
AutoCommit: 1
RaiseError: 1
',
    NULL,
    NULL,
    NULL,
    'sir'
)
»

ERROR:  error from Perl function: error from Perl function: llave duplicada viola restricción unique «dbi_connection_data_source_key» at line 94. at line 35.
__________________
Gracias de todas todas
-----
Linux!