Menu
Sep 22, 2016 Seems the issue is related to the version of the JVM that is in use. The ColdFusion generic Oracle drive does not seem to be able to persistently connect to Oracle 10g with JVM 1.6. To fix this issue I found some documentation about how to replace/add a new JDBC driver.
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 ODAC only seems to go up to 10g. July 15, at 6: I had the same problem Sql Server R2 64x connecting to an Oracle 8 , and solved it following your instructions. September 30, at When trying to create using sql server authentication mode, getting an error. When i am trying to create a linked using windows authentication, Linked server is getting created successfully.
Uploader: | Shakabei |
Date Added: | 14 April 2015 |
File Size: | 16.4 Mb |
Operating Systems: | Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X |
Downloads: | 19088 |
Price: | Free* [*Free Regsitration Required] |
Fortunately, I just had to install the 64 bit client. You must register online before using Oracle MetaLink. The ODAC only seems to go up to 10g. Edited by Hanuman D Friday, December 9, Email Required, but never shown. Please let me know if it works.
Now the oracle DB is upgraded to 12C after that, I’m facing this issue. Is there a specific DLL that needs to reside?
Sign up using Facebook.
How to use the tnsnames. You can’t post JavaScript.
It actually turned out to be this file: Oracle’N’AllowInProcess’1 oraoledb.oracle master. November 17, at These files are available at the Microsoft Web site: You can’t send emails.
Hi, Oracle is 12C and it is 64bit.
Creating a Linked Server for Oracle in 64bit SQL Server
I may have installed more Oracle components than I needed, but here’s what worked for me: Without this you might still get entries in the registry and files in the right places if you accept regedit prompts during install — but the provider will not be registrered with SQL. March 20, at 8: The consumer represents the traditional client. They are available here:. Post reply Like 79 Add to Briefcase.
How to install Oracle OLE drivers for use in SQL Server R2 x64 – Server Fault
I tried lots of things still the same, Enabled to allow in process. This worked very well for me and I was able to skip several steps. I am little bit confuse over it.
Provider is unable to function until these components are installed. As the author noted, be sure that you are using the correct driver for your version of Oracle and SQL. July 15, at 6: Massimo 52k 42 Access to an Oracle Database Oracle 9.
Everything works for first time.
SomeGuy 1 3 I thought a full client installation was required and didn’t want to do this for a single component piece, but based on the information you’ve provided this isn’t the case. You can’t post or upload images. Does anyone know where I can get the driver or where I can get explicit instructions for installing the driver on SQL Server???