How to create an Oracle DSN?

[ITTaz]

Hi,

I don't know whether or not I am posting this question at the right forum, but I was wondering if anyone can show me how to create a DSN to connect to Oracle DB? TIA

[irehman]

First configure tnsnames.ora, then go to odbc connections and create a entry for DB.

(e.g)

STEP 1)
using configuration wizard.

DB Alias = ORCL
Protocol = TCP/IP
Port = 1521
DB name = ORCL
test the service username/password (scott/tiger)

STEP 2)

Go to ODBC Driver

System DSN -->ADD--> Give it a same name as you have given in STEP1 --> give username and Password for Database (scott/tiger) you should be ready to go.