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.
CIT Hosting recommends customers use the OID connection string and the Oracle JDBC drivers with Coldfusion 10. This differs from Coldfusion 9 due to the fact that Adobe does not officially support Oracle 12g database connections with their delivered Oracle drivers. Jul 14, 2010 We're in the process of upgrading from ColdFusion 8 to ColdFusion 9, and we're starting by testing out the newest thin Oracle JDBC drivers (both driver versions 10 and 11) against ColdFusion 8. We've been using the same Oracle thin JDBC driver since.
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???
Last Drivers
ColdFusion Enterprise and J2EE Editions include DataDirect Technologies JDBC type IV driver for Oracle. This high-performance database connectivity component from the leading Oracle JDBC driver vendor supports the latest Oracle database enhancements and the full JDBC 3.0 specification, including pooling enhancements, BLOB/CLOB updates including read/write support, support for Multiple Open Results Sets, and savepoints. No special ColdFusion Server configuration is required to use this driver.Note: Oracle Ref Cursors are only supported with the DataDirect Technologies Oracle JDBC Driver.
Customers may, however, choose instead to use the Oracle JDBC Type IV thin driver to connect to Oracle databases. This driver is distributed by Oracle and is included with the Oracle client software.
Note: For JDK versions 1.2 or 1.3, classes12.jar should be used. For JDK 1.4, ojdbc14.jar should be used.
This TechNote describes how to configure ColdFusion MX to use the Oracle JDBC Type IV thin driver. NOTE: The Oracle thin driver does not comply to the JDBC 3.0 specification.
Configuring ColdFusion MX to use the Oracle JDBC thin driver
Enter the class path in the Class Path field on the ColdFusion MX Administrator's Java and JVM page. For example, C:Oracleora81jdbclibclasses12.zip, where the Oracle Client is installed in C:Oracle and the classes12.zip file is located in C:Oracleora81jdbclib. Note: Use a comma (,) to separate class paths when this field contains multiple values.
Click Submit Changes to update Java and JVM Settings for ColdFusion MX.
Restart the ColdFusion MX Application Server service. Note: On Unix platforms, from the cf_root/runtime/bin directory, run coldfusion restart
Use the ColdFusion MX Administrator Data Source page to add a new data source for the thin client: For example:
Name the data source ps_db when it will connect to the ps-db Oracle database.
Select Other in the driver field to tell ColdFusion you will describe another type of driver.
Click Add to add the data source and display the default driver window for this driver.
Enter the following in the JDBC URL field: jdbc:oracle:thin:@ps_db:1521:pubs Where ps_db is the name of the database server. Where 1521 is the port number for the data source connection (assuming the Oracle default port 1521). Where pubs is the Oracle System Identifier (SID). Note: The information in this field is case-sensitive.
Enter the following in the Driver Class field: oracle.jdbc.OracleDriver Note: The information in this field is case-sensitive.
Enter a valid username and password in the Username and Password fields. Where the username and password are defined as user account information on the database server.
(Optional) Enter the name of the driver in the Driver Name field.
Click submit to apply the changes to the data source.
Twitter™ and Facebook posts are not covered under the terms of Creative Commons.