Re: FreeTDS & Oracle11g

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Wed, 3 Jun 2009 12:27:02 -0700 (PDT)
Message-ID: <775a1d58-942b-4297-bf66-72b66f0f6142_at_f16g2000vbf.googlegroups.com>

On Jun 3, 12:33 pm, joel garry <joel-ga..._at_home.com> wrote:
> On Jun 3, 5:51 am, Mladen Gogala <gogala.mla..._at_bogus.email.com>
> wrote:
>
>
>
>
>
> > 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.fr
>
> Which version of unixodbc?  Seehttps://bugs.launchpad.net/ubuntu/+source/unixodbc/+bug/164473
> andhttp://www.unixodbc.org/(2.2.12 has unicode fixes for Oracle).
> Also see the change log for Changes in DBD::ODBC 1.15_1 November 6,
> 2007 - that specifies winblows fixes, but seems to say it could be
> using 2.2.12.
>
> Beyond that, see if it works on a supported OS, so you can ask support
> wtf 0x934454c means.  Looks like the 17183 is a pretty generic pointer
> towads odbc code.
>
> Sorry I don't have actual systems to try and see, but this is
> interesting.
>
> jg
> --
> _at_home.com is bogus.
> "you posted WHAT?"http://www3.signonsandiego.com/stories/2009/jun/03/1n3nukes234543-dat...- Hide quoted text -
>
> - Show quoted text -

Being unfamilar with the UNIX ODBC product mention I will take a chance and mention that "With Oracle 11g Generic Connectivity has been replaced by the Database Gateway for ODBC - DG4ODBC."

See if the following two documents are of any help.

Options for Connecting to Foreign Data Stores and Non-Oracle Databases #233876.1 (quote from this doc)

How to Setup DG4ODBC (Oracle Database Gateway for ODBC) on Windows 32bit #466225.1

HTH -- Mark D Powell -- Received on Wed Jun 03 2009 - 14:27:02 CDT