ODBC Firebird
10690May 26 2009 — edited May 28 2009Hi
I got this error when I try to connect to a firebird database:
ORA-28500 [ODBC Firebird Driver]Unavalilable database
ORA-02063
When I use the odbc with microsoft office access work fine.
This is my initnomina.odbc:
HS_FDS_CONNECT_INFO = nomina
HS_FDS_TRACE_LEVEL = on
HS_FDS_TRANSACTION_ISOLATION = NONE
HS_FDS_SUPPORT_STATISTICS=FALSE
My Tnsnames.ora:
NOMINA =
(DESCRIPTION =
(ADDRESS =(PROTOCOL = tcp)(HOST = 192.168.21.222)(PORT=1521))
(CONNECT_DATA = (SID = NOMINA))
(HS=OK)
)
My Listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = NOMINA)
(ORACLE_HOME = D:\app\arico\product\11.1.0\db_1)
(PROGRAM = DG4ODBC)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.21.222)(PORT = 1521))
)
)
My System DSN work fine (Office Access)
The trace is:
Oracle Corporation --- MARTES MAY 26 2009 17:05:29.848
Heterogeneous Agent Release
11.1.0.6.0
Oracle Corporation --- MARTES MAY 26 2009 17:05:29.848
Version 11.1.0.6.0
HOSGIP for "HS_FDS_TRACE_LEVEL" returned "on"
HOSGIP for "HS_OPEN_CURSORS" returned "50"
HOSGIP for "HS_FDS_FETCH_ROWS" returned "100"
HOSGIP for "HS_LONG_PIECE_TRANSFER_SIZE" returned "65536"
HOSGIP for "HS_NLS_NUMERIC_CHARACTER" returned ".,"
HOSGIP for "HS_FDS_RECOVERY_ACCOUNT" returned "RECOVER"
HOSGIP for "HS_FDS_TRANSACTION_LOG" returned ""HS_TRANSACTION_LOG""
HOSGIP for "HS_FDS_TIMESTAMP_AS_DATE" returned "TRUE"
HOSGIP for "HS_FDS_CHARACTER_SEMANTICS" returned "FALSE"
HOSGIP for "HS_FDS_MAP_NCHAR" returned "TRUE"
HOSGIP for "HS_FDS_RESULT_SET_SUPPORT" returned "FALSE"
HOSGIP for "HS_FDS_PROC_IS_FUNC" returned "FALSE"
HOSGIP for "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE"
using SYSDBA as default value for "HS_FDS_DEFAULT_OWNER"
HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
##>Connect Parameters (len=35)<##
## DSN=nomina;
#! UID=SYSDBA;
#! PWD=*
hgocont, line 1890: calling SqlDriverConnect got sqlstate 08004
What is the problem?