Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 707
  • Last Modified:

Connecting to Oracle with ODBC info

Not sure if this is possible or not,
but I'm trying to connect to an Oracle Database
using 3rd party software (Navicat).

I've been given instructions on how to get access to the
database through Access using an OBDC connection, but
would rather use Navicat to perform queries. I've tested the connection
in the ODBC manager, and it appears to work.

Thanks,
-JW
0
JustinW
Asked:
JustinW
  • 6
  • 4
1 Solution
 
JustinWAuthor Commented:
Oh,
and in the ODBC Data Source Administrator,
the Driver is listed as "Oracle in OraClient 11g_home1"
0
 
Devinder Singh VirdiLead Oracle DBA TeamCommented:
What is the question?

Thanks
0
 
JustinWAuthor Commented:
How do I connect to the database?
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
Devinder Singh VirdiLead Oracle DBA TeamCommented:
As per Navicat website, it will use TNS files, so you dont need ODBC.
TNS is the entry in  <ORACLE_HOME>/network/admin location.

Please read the following link
http://www.navicat.com/en/products/navicat_oracle/oracle_detail_win.html

0
 
JustinWAuthor Commented:
Thanks,

The Default Settings for Navicat's ORACLE - NEW CONNECTION are:

Connection Name: BLANK
Connection Type: Basic
Host Name/IP Address: BLANK
Port: 1521
Service Name/SID: ORCL
User Name: BLANK
Password: BLANK

Other than the Username and Password (which I have), What do I need to put in the blanks?
Is the rest of this configuration correct for what I want?
0
 
Devinder Singh VirdiLead Oracle DBA TeamCommented:
You can type anything in connection name,
However you can select TNS in Connection Type.
Then provide SCOTT as username and TIGER as password OR you can test with other users as well.
In host name you can enter your computer name or assign your computer some IP address and use that one.
0
 
JustinWAuthor Commented:
When I change the connection type From BASIC to TNS,
the form changes; giving me these options to complete:

Net Service Name: BLANK (dropdown)
User Name: BLANK
Password: BLANK

The Net Service Name Field doesn't have any prepopulated options
to chose from.

If I type in the DataBase I want to connect to (CPSPROD),
and click Test Connection, it throws
ORA-12154: TNS:could not resolve the connect identifier specified

Open in new window


The Oracle ODBC Driver Configuration form,
There's a Dropdown called **TNS Service Name**
that is prepopulated, and has the Database I want to connect to (CPSPROD).

When I test the connection on that; it says that the test was successful


0
 
JustinWAuthor Commented:
I've never installed anything oracle on my computer before,
could I be missing a driver?

0
 
Devinder Singh VirdiLead Oracle DBA TeamCommented:
You can search for TNSNAMES.ORA file under c:\oracle...\network\admin directory

Add the following (Change YourMachineName and TypeDatabaseName accordingly)

CPSPROD=
  (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = YourMachineName)(PORT = 1512))
    (CONNECT_DATA =
     (SERVICE_NAME = TypeDatabaseName)
        (INSTANCE_NAME= CPSPROD)
    )
  )
0
 
JustinWAuthor Commented:
Just copied the info from the ORA File into Navicat.
Lit right up!
Thx!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now