[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1228
  • Last Modified:

Oracle Gateway connection to Sybase not working after 11g Database upgrade

Hi

I have a dg4odbc setup through oracle gateway services which allows a connection to a sybase database.

On our Oracle 10.2.0.5 database this works fine, eg:

2991      23-JAN-12       04-APR-11

on the 11.2.0.2.0 Oracle database i get this:

2991      ¿

The date field doesn't work just comes up with the squares.

when i try and run a query on this database link I get this error:

ORA-28528: Heterogeneous Services datatype conversion error
ORA-02063: preceding line from 8888
28528. 00000 -  "Heterogeneous Services datatype conversion error"
*Cause:    Either an Oracle datatype could not be converted to a non-Oracle
           datatype, or a non-Oracle datatype could not be converted
           to an Oracle datatype. The following are possible reasons for
           for the conversion failure:
           --  overflow problems (in the case of numbers)
           --  length limitations (in the case of character strings)
           --  invalid values passed into the conversion routines
*Action:   Contact customer support of the agent vendor. If the problem is
           due to size discrepancies between Oracle and the non-Oracle system,
           it may not be possible to convert the value.

The ODBC connection is onthe same windows 2003 server as the Oracle 11.2.0.2.0 database

I've searched for hours on the net and can't find any resolutions so please help

Cheers
Paul
0
WPHIT
Asked:
WPHIT
  • 3
1 Solution
 
WPHITAuthor Commented:
something that I've just noticed on the table through odbc, throught the database link on our 10.2.0.5 database, the database sees the columns in the table as dates:


SQL*Plus: Release 10.2.0.5.0 - Production on Wed Aug 22 09:04:34 2012

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>
SQL> desc dba.View_Asset_ServiceStats@promaster
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 Lo_Code                                            NUMBER(10)
 Maintenance_Contract_Ref                           VARCHAR2(10)
 Maintenance_Contract                               VARCHAR2(60)
 Last_Service_Date                                  DATE
 Previous_Service_Date                              DATE
 Last_Service_Over_12_Months                        NUMBER(5)

And in the test database which is 11.2.0.2.0 it shows them as varchar:

SQL*Plus: Release 11.2.0.2.0 Production on Wed Aug 22 08:44:46 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

SQL> desc dba.View_Asset_ServiceStats@promaster
 Name                                      Null?    Type
 ----------------------------------------- -------- ---------------------------
 Lo_Code                                            NUMBER(10)
 Maintenance_Contract_Ref                           VARCHAR2(10)
 Maintenance_Contract                               VARCHAR2(60)
 Last_Service_Date                                  VARCHAR2(16)
 Previous_Service_Date                              VARCHAR2(16)
 Last_Service_Over_12_Months                        NUMBER(5)
0
 
WPHITAuthor Commented:
0
 
WPHITAuthor Commented:
sorted on other forum
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now