![](https://docs.oracle.com/cd/A87860_01/doc/win.817/a73029/database.gif)
Oracle Services For Microsoft Transaction Server 12c
Size: 22.0 KB License: Freeware Keywords: - - - - - - - - - Data Added 1: February 22, 2010 Devicescape enables your smartphone to automatically connect to Wi-Fi hotspots and home networks without having to start your browser, enter usernames and passwords, or configure security settings. S60 3rd edition freeware. This is convenient in situations when your BOSS is always on your head and you dont want to answer his call at certain moments during the day, it takes a few clicks.
As per standard procedure we've been using for years for previous versions of both Oracle and SQL Server, I have installed Oracle's latest ODAC package, which includes the Oracle OLE driver onto our new SQL Server 2008 R2 x64 nodes. I have done the recommended system reboot, but OraOLEDB.Oracle does not show in the Linked Servers Providers node in SSMS. The only difference between this installation and previous SQL Server installations is that I am now using SQL Server x64 (on Windows 2008 R2). Should this make any difference?
Open File >> Save As >> Put some descriptive name and click Save It will take some time to save, sit back and relax! Meanwhile you may have interested to check out the following. Return back the new ‘cups_product.conf’ file to the same location (Cisco >> install >> conf) Now everything is good to go. Cucm 8.6 iso.
Enlists the RM (database server) in the component’s Microsoft Transaction Server transaction Starts an Oracle global transaction corresponding to the Microsoft Transaction Server transaction of which the component is a part Acts as a resource dispenser to perform client-side connection pooling Recovers Microsoft Transaction Server-related, in. As per standard procedure we've been using for years for previous versions of both Oracle and SQL Server, I have installed Oracle's latest ODAC package, which includes the Oracle OLE driver onto our new SQL Server 2008 R2 x64 nodes.
Note that I am able to connect to Oracle servers using SQL*Plus from the SQL Server nodes directly. The only thing I am missing is that Provider. Anyone know what I am missing? There are many posts around the web, but there seems to be a lot of confusion and outdated links to Oracle's download page. The ONLY thing I need to be able to do is create a linked server to Oracle, and run select queries against it. I don't need to do anything through Visual Studio. After hours of research, I managed to cobble together some working instructions for Oracle 11g R2.
As it turns out, you will likely need both the 32 and 64 bit clients installed to have things working in BIDS/Visual Studio/SSMS. I may have installed more Oracle components than I needed, but here's what worked for me: • Download 32 and 64-bit clients from (click 'see all' to see different versions, otherwise, you'll be downloading the complete Oracle program. Your downloads should be about 600 meg each) • Run 32-Bit install on the SQL Server. Select 'Custom' • For Oracle Base, enter 'C: Oracle' • For 'Software Location', change to C: Oracle product 11.2.0 client_ 32 • Choose the following components: • SQL*Plus • Oracle Call Interface (OCI) • Oracle Net • Oracle Services for Microsoft Transaction Server • Oracle Administration Assistant for Windows • Oracle Provider for OLE DB • Oracle Data Provider for.NET • Oracle Providers for ASP.NET • Repeat above steps with the 64-bit installer.
HOWEVER, change the 'Software Location' to C: Oracle product 11.2.0 client_ 64 • I got a memory error at this point, but chose to ignore it since I know there is enough • Ignore the error 'OracleMTSRecoveryService already exists' Now that the install is done, just need to tweak a few things. • Make registry changes to HKEY_LOCAL_MACHINE SOFTWARE Microsoft MSDTC MTxOCI • OracleOciLib should be oci.dll • OracleSqlLib should be orasql11.dll • OracleXaLib should be oraclient11.dll • Make same registry changes to HKEY_LOCAL_MACHINE SOFTWARE Wow6432Node Microsoft MSDTC MTxOCI • Create or copy a new tnsnames.ora in C: Oracle product 11.2.0 client_ 32 network admin • Create or copy a new tnsnames.ora in C: Oracle product 11.2.0 client_ 64 network admin • Reboot! • You should now see OraOLEDB.Oracle as a provider under Linked Servers Providers in SSMS • Right-click this provider, then Properties, then tick the box for 'Allow Inprocess' • You can now create linked server through the GUI or T-SQL Good luck!
![Microsoft Microsoft](http://i.stack.imgur.com/s2R3S.png)
Attention, Internet Explorer User Announcement: Oracle Community has discontinued support for Internet Explorer 7 and below. In order to provide the best platform for continued innovation, Oracle Community no longer supports Internet Explorer 7. Oracle Community will not function with this version of Internet Explorer.
Please consider upgrading to a more recent version of Internet Explorer, or trying another browser such as Firefox, Safari, or Google Chrome. (Please remember to honor your company's IT policies before installing new software!) • • • •.