|
|
|
Old Hand
      
Group: General Forum Members
Last Login: Yesterday @ 8:08 AM
Points: 358,
Visits: 1,482
|
|
| we have a requirement to configure Linked server by using oracle provider . when we tried to configure linked server by selecting the oracle provider SSMS is hanging , we checked in logs but we did not find any related information . how to do it ?
|
|
|
|
|
Mr or Mrs. 500
      
Group: General Forum Members
Last Login: Monday, May 06, 2013 5:58 AM
Points: 535,
Visits: 1,010
|
|
What exact steps did you take to make the linked server?
Joie Andrew "Since 1982"
|
|
|
|
|
Old Hand
      
Group: General Forum Members
Last Login: Yesterday @ 8:08 AM
Points: 358,
Visits: 1,482
|
|
| SQL is locked when we tried to configure Linked server by using oracle provider , sql version is 2008 R2 64 -bit .
|
|
|
|
|
Mr or Mrs. 500
      
Group: General Forum Members
Last Login: Monday, May 06, 2013 5:58 AM
Points: 535,
Visits: 1,010
|
|
Did you install the 64-bit Oracle client? What provider are you using, the MS one or the Oracle one?
Joie Andrew "Since 1982"
|
|
|
|