Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Linked server for Oracle Expand / Collapse
Author
Message
Posted Friday, January 13, 2012 7:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, January 13, 2012 7:19 AM
Points: 1, Visits: 0
Absolutely golden! Thanks for the tip; you have rescued me from hours of frustration.
Post #1235629
Posted Wednesday, March 14, 2012 8:33 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, November 14, 2013 1:06 PM
Points: 31, Visits: 237
John Morrelles-204026 (7/1/2008)
Existing linked servers will not pick up the provider setting, so new linked server objects will have to be created. But the new ones work.


Ah, that was my issue; I added the option after creating the linked server...after deleting it and re-adding it, my problem went away.

thanks for the great catch.
Post #1266776
Posted Friday, April 13, 2012 9:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 1:38 PM
Points: 5, Visits: 80
Thanks. It addressed my problem
Post #1283233
Posted Thursday, January 03, 2013 1:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, March 15, 2014 11:07 AM
Points: 1, Visits: 39
Thanks, worked like a charm !
Post #1402216
Posted Wednesday, May 01, 2013 12:13 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 4:32 AM
Points: 4, Visits: 249
Thanks John, I was stuck with the same issue, your recommendation got me through.
Post #1448555
Posted Wednesday, February 12, 2014 1:34 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 10:17 AM
Points: 1, Visits: 8
Thanks! this was the fix that worked for me as well!
Post #1540965
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse