Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
This is the screen I have when I setup ODBC, where do I make the changes you mentioned
Please show me where to make the changes you mentioned.
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.
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
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
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
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
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