Home » RDBMS Server » Networking and Gateways » Data Retrieval from SQL server to oracle client through ODBC (oracle 10.2.0.4 - Windows server 2003)
Data Retrieval from SQL server to oracle client through ODBC [message #614344] Wed, 21 May 2014 01:43 Go to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi All,

Having a peculiar issue.

1) Had successfully configured Heterogeneous and ODBC between oracle 10g and SQL Server DB.
2) Successfully rows were inserted from oracle to the table of SQL server DB.

But the problem is when we retrieve the data from that table in the oracle end, it shows the repeated data of the data which was inserted in the SQL server Terminal.

But the same table's record can be retrieved properly in the side of SQL server DB.

Why we are not able to retrieve them from Oracle client side, but in the SQL server side.

Note:
A view were made on the actual table, through that view only our insertion and retrieval are happening.

Thanks
Muktha
Re: Data Retrieval from SQL server to oracle client through ODBC [message #614345 is a reply to message #614344] Wed, 21 May 2014 01:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Given what you said it seems it is a bug and I advise you to open a SR (or to use the workaround you found using a view).

[Updated on: Wed, 21 May 2014 01:54]

Report message to a moderator

Re: Data Retrieval from SQL server to oracle client through ODBC [message #614555 is a reply to message #614345] Fri, 23 May 2014 05:41 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi,

Problem got solved,

The problem was actually the Data Type unsupported by oracle.

Thanks
Muktha
Re: Data Retrieval from SQL server to oracle client through ODBC [message #614597 is a reply to message #614555] Fri, 23 May 2014 10:51 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Thanks for the feedback;

Previous Topic: database connectivity over WAN
Next Topic: Problem with No TNS Listener error
Goto Forum:
  


Current Time: Thu Mar 28 11:22:03 CDT 2024