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 22.214.171.124.0 Oracle database i get this:
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 126.96.36.199.0 database
I've searched for hours on the net and can't find any resolutions so please help