Home » RDBMS Server » Networking and Gateways » Free Version for connecting from SQL Server?
Free Version for connecting from SQL Server? [message #646232] Tue, 22 December 2015 13:02 Go to next message
Clintos
Messages: 1
Registered: December 2015
Junior Member
Hello. First time posting and limited Oracle user, so please help me if this should be posted elsewhere. We have a need to connect from a SQL Server (using SSIS specifically) on our domain across the internet to a client domain to pull back data. This is working in our QA environment. However, the person who set up the QA environment installed the Enterprise version of the Oracle DBMS to allow configuration of TNSNames. Now that it is time to move to production, we are concerned that installing the Enterprise version will incur costs. Is there a free version that will allow us to configure TNSNames and connect to the Oracle installation on the client domain? Keep in mind that we are not actually creating Oracle databases on our end.

Thanks in advance, and if this is not a good place, please point me int he right direction.

Regards,
Clint
Re: Free Version for connecting from SQL Server? [message #646233 is a reply to message #646232] Tue, 22 December 2015 13:09 Go to previous messageGo to next message
BlackSwan
Messages: 25720
Registered: January 2009
Location: SoCal
Senior Member
http://www.oracle.com/technetwork/indexes/downloads/index.html

Express Edition (XE) is free but has limitations that should meet your requirements
Re: Free Version for connecting from SQL Server? [message #646234 is a reply to message #646232] Tue, 22 December 2015 13:12 Go to previous messageGo to next message
John Watson
Messages: 7150
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

If I understand you correctly, all you need to install is the Oracle client which includes the networking libraries. It is distributed licence free, download from http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
Re: Free Version for connecting from SQL Server? [message #646242 is a reply to message #646232] Wed, 23 December 2015 03:25 Go to previous messageGo to next message
gazzag
Messages: 906
Registered: November 2010
Location: Bristol, UK
Senior Member
Quote:
The person who set up the QA environment installed the Enterprise version of the Oracle DBMS to allow configuration of TNSNames.

Then, as is so much the case these days, that person either didn't know what they were doing or was trying to rip you off. Anyway, Oracle XE should suit your requirements, as BlackSwan said.
Re: Free Version for connecting from SQL Server? [message #646355 is a reply to message #646242] Mon, 28 December 2015 10:17 Go to previous message
Flyby
Messages: 181
Registered: March 2011
Location: Belgium
Senior Member
As John Watson mentioned, all you need is the 64-bit client.
I usually install the following components:
SQL*Plus (testing and troubleshooting)
Oracle JDBC/Thin (if you plan to install sqldeveloper)
Oracle Call Interface
Oracle NET (for tnsnames)
Oracle ODBC Driver
SQL Developer (for testing)
Oracle Services For Micosoft Transaction Server (distributed transactions?)
Oracle Provider For OLEDB (Linked servers)
Previous Topic: Junifer Router basic commands
Next Topic: TNS-12541: Tns no listener
Goto Forum:
  


Current Time: Thu Nov 23 21:49:23 CST 2017

Total time taken to generate the page: 0.01526 seconds