Oracle Database Discussions

Hi all,

I'm using Gateways for ODBC 11g and the latest Pervasive ODBC driver, with unixODBC as the manager. I can hit the database just fine through the command line (EL 5.2 32 bit), but can't get anything through the gateway. All I get is

SQL> Select count(*) from "emp"@pervasive;
Select count(*) from "emp"@pervasive
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]Driver
not capable.
ORA-02063: preceding 2 lines from PERVASIVE

I've also tried DataDirect ODBC as the manager, same same. The interesting thing is that I can see from the trace file generated by dg4odbc that it's definitely connecting to the database, because it shows the structure of the table I'm querying. If anyone has any ideas, I sure would appreciate them! Thanks :)

-Adam vonNieda

Version info..

Oracle Gateways: 11.1.0.6 Linux x86
Oracle Database: 11.0.6 Linux x86
Pervasive ODBC client: 10.12.022
Pervasive SQL Server: 10.13.012


Example trace file..

Entered hgopcda at 2009/01/06-00:29:55
Column:1(EMP_ID): dtype:1 (CHAR), prc/scl:15/0, nullbl:1, octet:15, sign:1, radix:0
Exiting hgopcda, rc=0 at 2009/01/06-00:29:55
Entered hgopcda at 2009/01/06-00:29:55
Column:2(FIRST_NAME): dtype:1 (CHAR), prc/scl:15/0, nullbl:1, octet:15, sign:1, radix:0
Exiting hgopcda, rc=0 at 2009/01/06-00:29:55
Entered hgopcda at 2009/01/06-00:29:55
Column:3(LAST_NAME): dtype:1 (CHAR), prc/scl:15/0, nullbl:1, octet:15, sign:1, radix:0
Exiting hgopcda, rc=0 at 2009/01/06-00:29:55
Entered hgopcda at 2009/01/06-00:29:55
Column:4(HIRE_DATE): dtype:1 (CHAR), prc/scl:30/0, nullbl:1, octet:30, sign:1, radix:0
Exiting hgopcda, rc=0 at 2009/01/06-00:29:55
Entered hgopcda at 2009/01/06-00:29:55
Column:5(SALARY): dtype:1 (CHAR), prc/scl:15/0, nullbl:1, octet:15, sign:1, radix:0
Exiting hgopcda, rc=0 at 2009/01/06-00:29:55
Entered hgopcda at 2009/01/06-00:29:55
Column:6(DEPT): dtype:1 (CHAR), prc/scl:15/0, nullbl:1, octet:15, sign:1, radix:0
Exiting hgopcda, rc=0 at 2009/01/06-00:29:55
hgodscr, line 521: Printing hoada @ 0x9310438
MAX:6, ACTUAL:6, BRC:100, WHT=5
DTY NULL-OK LEN MAXBUFLEN PR/SC CST IND MOD NAME
1 CHAR Y 15 15 0/ 0 0 0 0 EMP_ID
1 CHAR Y 15 15 0/ 0 0 0 0 FIRST_NAME
1 CHAR Y 15 15 0/ 0 0 0 0 LAST_NAME
1 CHAR Y 30 30 0/ 0 0 0 0 HIRE_DATE
1 CHAR Y 15 15 0/ 0 0 0 0 SALARY
1 CHAR Y 15 15 0/ 0 0 0 0 DEPT
Exiting hgodscr, rc=0 at 2009/01/06-00:29:55
Entered hgotcis at 2009/01/06-00:29:55
Calling SQLStatistics for emp
Entered hgopoer at 2009/01/06-00:29:55
hgopoer, line 159: got native error 0 and sqlstate HYC00; message follows...
[Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]Driver not capable.
Exiting hgopoer, rc=0 at 2009/01/06-00:29:55