topic Re: Connect to Oracle Server in QlikView

Connect to Oracle Server

Wed, 26 Sep 2012 13:57:05 GMT

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.

Re: Connect to Oracle Server

Wed, 26 Sep 2012 14:13:45 GMT

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.

Re: Connect to Oracle Server

Thu, 27 Sep 2012 06:12:43 GMT

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

Re: Connect to Oracle Server

Thu, 27 Sep 2012 06:14:35 GMT

Please show me where to make the changes you mentioned.

Re: Connect to Oracle Server

Thu, 27 Sep 2012 12:21:54 GMT

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.

Re: Connect to Oracle Server

kamalqlik — Thu, 27 Sep 2012 12:28:43 GMT

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

Re: Connect to Oracle Server

Thu, 27 Sep 2012 12:59:44 GMT

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

Re: Connect to Oracle Server

Thu, 27 Sep 2012 12:59:57 GMT

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

Re: Connect to Oracle Server

Thu, 27 Sep 2012 13:00:17 GMT

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

Re: Connect to Oracle Server

Thu, 27 Sep 2012 13:00:32 GMT

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