CODEWITHSUNDEEP
oracle11godbc
Glory
Glory

Reputation: 45

oracle odbc driver configuration

I'm having a problem with configuring oracle odbc

the dialog page is blank

when I enter TNS name as : XE

I get the following error:

unable to connect SQLState=08004

my tnsnames file is:

KPI_SERVER= 
  (DESCRIPTION = 
    (ADDRESS = (PROTOCOL = TCP)(HOST =localhost)(PORT =1521)) 
    (CONNECT_DATA = 
      (SERVER = DEDICATED) 
      (SERVICE_NAME = XE) 
    ) 
  )

the connection is successful in SQL developer by the following data:

hostname: localhost port number: 1521 service: XE

and the trns_admin variable is set to: C:\oracle_odbc\tnsnames

Path is set to: C:\oracle_odbc

what did I do wrong?

thank you for your time

Upvotes: 1

Views: 2662

Answers (1)

bdn02
bdn02

Reputation: 1500

We try to make order: open a command prompt,

launch echo %TNS_ADMIN% the result is C:\oracle_odbc\?

launch dir C:\oracle_odbc\, the result is tnsnames.ora?

launch type C:\oracle_odbc\tnsnames.ora the result is the content of "my tnsnames file is" section of your initial post?

If all the response are yes, can you retry to lauch 'sqlplus.exe dbuser/dbpassword@KPI_SERVER

Upvotes: 1

Related Questions