I'm new to Oracle...working on it for a client. So I appoligize in advance if this question is silly..but rest assured, I've GOOGLED the heck out of it with no results
I'm just trying to create an ODBC DSN for this oracle database I created.
I created a database (named EM) thru SVRMGR23.
I can log into and view the tables by saying:
CONNECT EM/changeit (the username/password I set up)
From here I can do SELECT statements and whatnot to view my data, so it seems my database is set up correctly, at least this far.
Now, I want to set up an ODBC connection to it.
Looks like I've got these choices:
Microsoft ODBC for Oracle 2.573.7326
Oracle ODBC Driver 8.01.61.00
Oracle73 Ver 2.5 2.05.03.01
I've tried them all, and the crux of my problem seems to be in the SQL*NET Connect_String. From what I've read (from Googling) this Connect String should be the Database name, as it's defined in the TNSNAMES.ORA file?!?
Here is a listing of that file:
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = AMTULW2K110777.bp1.ad.bp.com) #<--that is my local machine name
(Port = 1521)
(CONNECT_DATA = (SID = EM)
Does anyone see any obvious errors in the above 2 files. I know this must be a rediculous NEWB question..but again...I have researched the heck out of it.. I just want an ODBC connection so I can run a program that has already been written to transfer data between this database and another via ODBC.
First,confirm your oracle database instance has been created and running
Second,you should better to use the same sql*net client's version the server.(I see u use oracle7.x,and I can not confirm which your oracle database version.)
Then,before create odbc dsn,you must use oracle client utitily(Easy Net configuration) to create a local network service(it will write tnames.ora autmaticly),same as edit your tnames.ora file by yourself.After did it,u can use tnsping test it.
Last,configure the odbc setting correctly.