Errors in Generic Connectivity using ODBC

[Nisch]

Dear All,

I am using Generic connectivity to link to a kerridge database
(proprietary database in unix), that takes care of our automotive
application. This is done to extract data to our data marts running on
Oracle 9.0.1.

I have created the database link. When I query a table having
rows in it, I get the following error:

SQL> select * from mk_00_companypositions@krdge;

select * from mk_00_companypositions@krdge

ORA-28500: connection from ORACLE to a non-Oracle system returned this
message:
[Generic Connectivity Using ODBC][Kerridge][KISAM ODBC
Driver][KISAM]internal : expr unknown fn (SQL State: S1000; SQL Code:
2175)
ORA-02063: preceding 2 lines from KRDGE

But when I use the same ODBC driver and connect to kerridge using MS
Access, I am able to do it without any errors.

Whereas when I query table with no records in it I am able to do it.

SQL> select * from mk_00_hobbycodes@krdge;

CODE DESC_
----- ------------------------------

Also I am able to create a table for the table having no records in
it:

SQL> create table hobbycodes as select * From mk_00_hobbycodes@krdge;

Table created

SQL> desc hobbycodes
Name Type Nullable Default Comments
----- ------------ -------- ------- --------
CODE VARCHAR2(5) Y
DESC_ VARCHAR2(30) Y

SQL>

What I fail to understand is that, if this was the limitation of the
ODBC driver, this works fine with MS Access. Also the link is active
as I am able to create table with no rows in it. I am using KISAM 32
bit Driver ver. 6.00.32.8190

Kindly Help, please provide your views on this. Every input will be
valuable. Please mark a copy to my email id.

TIA,
Regards,
Nischal

[Tim]

Hi sorry this is not a answer to your question but a question of my
own,

I am also thinking about using the KISAM ODBC Driver to connect to my
unix based kerridge, I have installed everything but I do not think I
have the nescasarry sources file, I have looked on the KCML home page
but I am unable to find out how to create one (if I dont already have
one).

Any help/examples would be much appreciated.

Thanks Tim.

oran...@rediffmail.com (Nisch) wrote in message news:<7e463783.02071...@posting.google.com>...