topic Re: ORA-12170: TNS:Connect timeout occurred ODBC CONNECT in QlikView

ORA-12170: TNS:Connect timeout occurred ODBC CONNECT

thankuever — Wed, 25 Nov 2020 16:16:04 GMT

Hello all,

When I reload my script

i get the following error message

___________________________________________________________________________________________________

SQL##f - SqlState: S1000, ErrorCode: 12170, ErrorMsg: [Oracle][ODBC][Ora]ORA-12170: TNS:Connect timeout occurred

ODBC CONNECT TO [cs1m;DBQ=PDINK] (XUserId is IGJSSLZAXXJOUDOB, XPassword is ZXPXfYZOSXXJOULUCDZMGcA)

_______________________________________________________________________________________________________

My goal is connect to Oracle database using ODBC ,and sql select some table from it and create some .qvd.

i make sure the database is no problem that i can connect it using sql developer successfully.

it is very stranger that i using other two computers which can reload successfully in same setting such tnsnames.ora and environment variables and the firewall is closed.

and now . how can i do ?

Best Regards,

Amy

Re: ORA-12170: TNS:Connect timeout occurred ODBC CONNECT

ramasaisaksoft — Tue, 27 Dec 2016 13:56:07 GMT

Hi Amy,

there are so many causes like N/W issue ,Firewall issue..etc

can u create a new qvw file and try to use same connection.if there also you got same issue then some thing problem in TNS

else

there was no issue

for more information just go through the below link

ORA-12170: TNS: connect timeout occurred - TekStream

ORA-12170: TNS:Connect timeout occurred tips

Re: ORA-12170: TNS:Connect timeout occurred ODBC CONNECT

thankuever — Tue, 27 Dec 2016 14:55:48 GMT

HI Rama

I create a new qvw file and try to use same connection. there also got same issue

but i dont think my tnsames.ora setting go wrong because i use it then can connent DB at different computer.

Amy

Re: ORA-12170: TNS:Connect timeout occurred ODBC CONNECT

Tue, 27 Dec 2016 15:22:37 GMT

If its working with other computers, then it could be some problem with the account permissions. Try to connect to the database server from the qlikview server( affected computer). Also make sure that the tnsnames settings is the same on the server and the client side. (If you are accessing the database through Oracle client).

Also refer to this link: ORA-12170: TNS:Connect timeout occurred tips

Regards,

Karan

Re: ORA-12170: TNS:Connect timeout occurred ODBC CONNECT

thankuever — Tue, 27 Dec 2016 16:19:18 GMT

Dear Karan,

all computer is QlikView Server .When i test successfully on a computer.

I copy the tnsnames.ora from this computer to a new computer.

And I also set the relative environment path for it.

But i cant connect successfully.

i also close every computer's firewall to test.

I don't think it will be a network issue because two computers can connect the Oracle DB.

Regards,

Amy

Re: ORA-12170: TNS:Connect timeout occurred ODBC CONNECT

Chip_Matejowsky — Tue, 27 Dec 2016 20:24:57 GMT

Per the error message, the issue isn't on QlikView side of things. Suggest you reach out to DBA who manages the database and provide the error to them.

Re: ORA-12170: TNS:Connect timeout occurred ODBC CONNECT

sankartalluru — Wed, 28 Dec 2016 06:28:22 GMT

Hi,

Please check data base is accessible from your machine

you are trying to connect to SQL then check below :

Open CMD and type : telnet data base IP port no ( blank CMD screen appears means OK)

You are connecting with Oracle then check TNS entry details for that DB.

2). Check query for ORACLE

SELECT * FROM "SCHEMA NAME" . "TABLE NAME";

For SQL : SELECT * FROM dbo . TABLE NAME;(You should select DB name while creating connection string in Qlikview script)