![]() ![]() ![]() Wednesday, Decem4:50:53 PM - Charles Spenceĭo you have an update for recent SQL Mgmt studio and later versions of Oracle Simply go ahead and select the InstantClient option from the openingĬan we add Oracle server using sp_addlinkedserver in sql server 2012? Site or media available via any licensing agreements you may have with Oracle. I will leave it up to you to secure the software by either download from their The complete process is presented below: Step One: Installation of the Oracle 10g Release 2 64-bit client software ![]() Install Oracle 10g Release 2 64-bit ODAC software (available from Oracle.Install Oracle 10g Release 2 64-bit client software (available from Oracle.Process Creating Oracle Linked Server on a 64-bit SQL Instance: and in the case of one critical step it impacts any existing users on the instance! In the 64-bit world the process is slightly more difficult Oracle client software, create the linked server, add remote logins and move on In 32-bit environments we simply install the Take for example linked servers - more specifically linked In most cases, our installation andĬonfiguration processes do not change from 32-bit to 64-bit: setting up logins,Ĭreating SQL Agent jobs nothing inherently different there. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |