| Data Retrieval from SQL server to oracle client through ODBC [message #614344] |
Wed, 21 May 2014 01:43  |
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
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
