Connect to Oracle 10g using Odbc

How I can connect Oracle 10g through Odbc ?

I'm using Oracle in OraDb10g_home1 driver

What exatly I can write in TNS Service Name in Oracle ODBC Driver Configuration ?
interbusAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

NotLogicalCommented:
For me, the most useful site for doing a "live" connection string configuration is:

http://www.connectionstrings.com/
0
interbusAuthor Commented:
I want to using Data Sources (ODBC) to connect Oracle Database.

The Data Sources (ODBC) is available in administrative tools in Control Panel

There was new driver is called Oracle in OraDb10g_home1

my question here about TNS Service Name what I write inside this combobox


test.bmp
0
NotLogicalCommented:
The TNS name is something you need to configure through the Oracle Net Configurator. In the configurator, you will need to specify the following information:
- the service name
- the server's name you are connecting to
- the protocol (in the case of a network connection, select TCP/IP)
- the port (usually 1521)

The Configurator will then allow you to test this connection, and then save it using a service name you choose. This service name is what you will need to type into the "TNS Service Name" in the ODBC configuration screen.

Please remember: the DSN (Data Source Name) is what your applications will use for a connection, rather than the TNS Service Name!

The only thing which I am a little unclear about is where you got the "OraDb10g_home1" name from? Was that already in the TNS Name drop-down? That is not a standard driver name that I recognize...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.