Oracle Database Discussions

Hi, I'm having problems getting ODBC connections to work properly under Oracle 11g. I keep getting the following error message when trying to run a query:

ORA-28500: connection from ORACLE to a non-Oracle system returned this message: More than one active statements is not yet supported on the same connection
ORA-02063: preceding 2 lines from EMPC

I'm sure this is some type of configuration problem, because it happens on every single statement I enter (and there is not more than one connection). I'm posting the various configuration settings below.

Please also note that I've tried all varieties of the SQL to run, i.e.
select count(*) from st_date@empc;
select count(*) from "ST_DATE"@empc;
select count(*) from sysdba.st_date@empc;
select count(*) from "SYSDBA"."ST_DATE"@empc
-- all of these return the same error message.

Thanks in advance for any help / advice!
Scott

=====> LISTENER.ORA:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = EMPC)
(PROGRAM = DG4ODBC)
(SID_NAME = EMPC)
(ORACLE_HOME = c:\oracle\product\11.1.0\db_1)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxx)(PORT = 1521))
)
)


=====> TNSNAMES.ORA

EMPC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = EMPC)
)
(HS = OK)
)

DW =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DW)
)
)

=====> initEMPC.ora

HS_FDS_CONNECT_INFO = xxxxx (name of ODBC driver)
HS_FDS_TRACE_LEVEL = ON


=====> link creation statement
create public database link empc connect to xxxxx identified by yyyyy using 'EMPC';

=====> query I'm trying to run
select count(*) from st_date@empc

=====> output of trace file:
Oracle Corporation --- WEDNESDAY NOV 07 2007 12:45:21.479
Heterogeneous Agent Release
11.1.0.6.0
Oracle Corporation --- WEDNESDAY NOV 07 2007 12:45:21.479
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 XXXXX as default value for "HS_FDS_DEFAULT_OWNER"
HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
##>Connect Parameters (len=52)<##
## DSN=XXXXX;
#! UID=XXXXX;
#! PWD=*
SQL text from hgopars, id=1, len=23 ...
00: 454C4553 2A205443 4F524620 5322204D [SELECT * FROM "S]
10: 41445F54 544522 [T_DATE"]
hgotcis, line 384: calling SQLStatistics got sqlstate HY000