Home » RDBMS Server » Server Administration » How to set ODBC of Oracle in Windows 2000 Server?
How to set ODBC of Oracle in Windows 2000 Server? [message #235101] Fri, 04 May 2007 01:30 Go to next message
rushing
Messages: 135
Registered: January 2004
Location: Beijing,China
Senior Member
There is a notebook which has installed Windows 2000 Server and Oracle 9i Server.
The ODBC to the service name of Oracle could not be visited by any software. I am sure the setting of ODBC is correct.
However, software using oracle driver or Microsoft MDAC could visit the same service name directly.
Please tell me how to config the system.
Thanks!
Re: How to set ODBC of Oracle in Windows 2000 Server? [message #235133 is a reply to message #235101] Fri, 04 May 2007 02:50 Go to previous messageGo to next message
orasupport
Messages: 11
Registered: May 2007
Junior Member
Check whether you have the necessary TNS entries in the tnsnames.ora file

try doing a tnsping with the service nanme and check whether you are able to connect or not.


If you have multiple Oracle home. Configure the TNS_ADMIN env
variable to correct network path.

EG:
TNS_ADMIN=D:\oracle\ora920\network\admin
Re: How to set ODBC of Oracle in Windows 2000 Server? [message #235314 is a reply to message #235101] Fri, 04 May 2007 22:02 Go to previous message
pravednik
Messages: 2
Registered: May 2007
Location: Ukraine
Junior Member

Maybe try install ODBC driver from www.oracle.com
Previous Topic: DBA Studio & Enterprise Manager
Next Topic: columns appeared with WHERE
Goto Forum:
  


Current Time: Sun Dec 11 04:01:30 CST 2016

Total time taken to generate the page: 0.09386 seconds