Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

db link between oracle erp db (11.1.0.7 ) and sqlsever 2008 db

Mohammed Abdul MuqeetJan 24 2013 — edited Feb 15 2013
Dear Experts,

Kindy note that I am stuck in the below scenario.

We are trying to create a db link between oracle db - R12.1.1 + 11.1.0.7(SUN SPARC 64-bit). and SQL Server 2008 Installed on

Windows Server 2008 R2.

We are planning to integrate 3rd party application along with oracle erp.


Please advise.


Regards
Mohammed. Abdul Muqeet

Comments

Jan
Not experienced with the windows implementation, only on linux ... but maybe it may help ...
cx_Oracle is only the bridge between python and the oci interfaces of Oracle, an exposure of the c-api's towards python.
On linux you must set the LD_LIBRARY_PATH variable to the location where the oracle client libraries can be found. (typically something linke libclntsh.so.*). So ... I guess that on a windows environment the client dll's should be in the path (%PATH%) ... Hope somebody can confirm or correct this. Maybe it may help ...
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 15 2013
Added on Jan 24 2013
#oracle-provider-for-ole-db, #windows-and-net
3 comments
2,236 views