Re: FreeTDS & Oracle11g
- From: Mark D Powell <Mark.Powell@xxxxxxx>
- Date: Wed, 3 Jun 2009 12:27:02 -0700 (PDT)
On Jun 3, 12:33 pm, joel garry <joel-ga...@xxxxxxxx> wrote:
On Jun 3, 5:51 am, Mladen Gogala <gogala.mla...@xxxxxxxxxxxxxxx>
wrote:
I have properly configured UnixODBC which used to work with Oracle10.2.0.4
and hsodbc:
mgogala@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@mstest;
select * from systables@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
--
@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 --
.
- Follow-Ups:
- Re: FreeTDS & Oracle11g
- From: Mladen Gogala
- Re: FreeTDS & Oracle11g
- References:
- FreeTDS & Oracle11g
- From: Mladen Gogala
- Re: FreeTDS & Oracle11g
- From: joel garry
- FreeTDS & Oracle11g
- Prev by Date: Re: Refresh Materialized view manually
- Next by Date: Re: Refresh Materialized view manually
- Previous by thread: Re: FreeTDS & Oracle11g
- Next by thread: Re: FreeTDS & Oracle11g
- Index(es):
Relevant Pages
|
