Re: Errors in Generic Connectivity using ODBC

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.

oranisch_at_rediffmail.com (Nisch) wrote in message news:<7e463783.0207162223.294d888d_at_posting.google.com>...
> 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_at_krdge;
>
> select * from mk_00_companypositions_at_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_at_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_at_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
Received on Thu Jul 18 2002 - 17:10:59 CEST