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
Printable View
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
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.