FreeTDS & Oracle11g

From: Mladen Gogala <gogala.mladen_at_bogus.email.com>
Date: Wed, 3 Jun 2009 12:51:23 +0000 (UTC)
Message-ID: <h05rka$qr4$1_at_solani.org>

I have properly configured UnixODBC which used to work with Oracle10.2.0.4 and hsodbc:

mgogala_at_centos ~]$ isql -v mstest ccmview ccmview

+---------------------------------------+


| Connected!                            |

|                                       |

| sql-statement                         |

| help [tablename]                      |

| quit                                  |

|                                       |

+---------------------------------------+

SQL> select table_name from information_schema.tables;

+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

+
|

table_name
|

+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

+
|

CallDetailRecord
|
|

calldetailrecordbackup
|
|

CallDetailRecordDiagnostic
|
|

calldetailrecorddiagnosticbackup .....

Now, I am trying to do the same thing with Oracle 11.1.0.7 on CentOS 5.3 (proof of concept):

SQL> select * from systables_at_mstest;
select * from systables_at_mstest

                        *

ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ORA-02063: preceding line from MSTEST

Unfortunately, the trace file doesn't contain any useful information:

Trace file /oracle/diag/clients/user_oracle/host_649917657_11/trace/ ora_5040_308
5899456.trc
OCI-21500: internal error code, arguments: [17183], [0x934454C], [], [], [], [],
 [], []
********** Internal heap ERROR 17183 addr=0x934454c *********

That's about it. This is a test machine, with an unsupported OS. It's not very important but I would still like to get this thing under control. Does anybody here know anything about that? Did anybody manage to get this working?

-- 
http://mgogala.freehostia.com

Received on Wed Jun 03 2009 - 07:51:23 CDT