Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODBC Firebird

10690May 26 2009 — edited May 28 2009
Hi

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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 25 2009
Added on May 26 2009
3 comments
4,158 views