dblink from Oracle linux 11g to mssql 2k
11803Jul 31 2010 — edited Sep 30 2010Hi all,
I'm trying to make a connection to mySQL 2000 SP3 database from oracle 11g on a linux box w/ Centos 5.4 using dg4odbc, unixODBC and freebsd.
From the OS command prompt using isql I can connect mssql2000 and select tables BUT from within oracle the db link works only with DESC of mssql tables but NOT with SELECT.
Enabling trace on hs connection I had:
[....]
The hoada for table INFORMATION_SCHEMA.TABLES follows...
hgodtab, line 876: NO hoada to print
Exiting hgodtab, rc=0 at 2010/07/30-16:35:31
Entered hgopars, cursor id 1 at 2010/07/30-16:35:31
type:0
SQL text from hgopars, id=1, len=43 ...
00: 53454C45 4354202A 2046524F 4D202249 [SELECT * FROM "I]
10: 4E464F52 4D415449 4F4E5F53 4348454D [NFORMATION_SCHEM]
20: 41222E22 5441424C 455322 [A"."TABLES"]
Exiting hgopars, rc=28500 at 2010/07/30-16:35:31 with error ptr FILE:hgopars.c LINE:570 FUNCTION:hgopars() ID:SELECT list of size 0 is not valid
Entered hgocomm at 2010/07/30-18:54:05
keepinfo:0, tflag:1
[...]
I tryed both on Oracle 11g R2 on CentOS 5.4 x86_64 and on Oracle 11g R1 on Red Hat 5.3 x86 with same result
Any help?
Tanks in advance