Connect to Oracle Server

[#1]

Hi I need assistance,

I am trying to connect to Oracle database and keep getting an error "ORA-12154: TNS could not resolve the connect identifier specified.

I am using the same credentials I use when logging on to Oracle through sql developer.

[#2]

Are you trying to use odbc or ole DB connection to Oracle. I'm using ole DB and I had this problem before then i replace the connection information from services name to complete connect details and its start working. For instance

Service Name = Flex_DB    ----- TNS Error

Connection Detail     -----        This should work

"DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = XYZ.COM)(PORT = ABC))

    (CONNECT_DATA = (SID = Test_DB)"

Tx.

[#3]

This is the screen I have when I setup ODBC, where do I make the changes you mentioned

[#4]

Please show me where to make the changes you mentioned.

[#5]

I had problem with ODBC, so i choose OLEDB connection type from Qliview Edit Window. Here are the steps from Q Edit Script Window, let me know if you still have any questions

Under Database:

          OLE DB

     and press Connect button

On Data Link Properties Window

     Select "Oracle Provider for OLE DB"

          press Next button

   Under Connection:

     1 Data Source:     -- provide your db connection string information -- this is what i was talking in my previous response above. 

      rest of the is stright forward.

[kamalqlik]

Hi Friend ,

Go to the Data Sources in Control pannel and check that whether there is driver for oracle installed or not.

Other case may be that it is not getting the path specified for the Datasource you have specified.

So you have to contact with your database administrator.

regards

Kamal

[#7]

Hi Guys,

Thanks for the responses. I have the oracle drivers installed, it turns out I had to edit my tnsnames file with the correct path of the server I'm connecting to.

Sorted Thanks

[#8]

Hi Guys,

Thanks for the responses. I have the oracle drivers installed, it turns out I had to edit my tnsnames file with the correct path of the server I'm connecting to.

Sorted Thanks

[#9]

Hi Guys,

Thanks for the responses. I have the oracle drivers installed, it turns out I had to edit my tnsnames file with the correct path of the server I'm connecting to.

Sorted Thanks

[#10 · Accepted solution]

Hi Guys,

Thanks for the responses. I have the oracle drivers installed, it turns out I had to edit my tnsnames file with the correct path of the server I'm connecting to.

Sorted Thanks