topic Re: Qlik connection to oracle database in QlikView

Qlik connection to oracle database

Wed, 25 Nov 2020 16:16:04 GMT

Hello

I am trying to connect to oracle database with my qlikview 11 desktop version.

The odbc was tested with SQL plus and I am able to access the database.

But when i try to reload the script in Qlikview, i get " null password given, logon denied" error.

The odbc connection statement is in a separate txt file and is loaded to the script.

What could possibley be the reason when the odbc connection is succesful through odbc administrator and SQl developer, but fails in Qlikview 11?

Thanks

Aravind

Re: Qlik connection to oracle database

krishnacbe — Thu, 21 Sep 2017 19:10:49 GMT

Did you Key in the User ID and Password when you try to connect in Qlikview.

Data Tab -> ODBC -> Connect -> Connect to Data Source, Select the Data Source and provide the details.

Re: Qlik connection to oracle database

Mon, 25 Sep 2017 13:49:20 GMT

Hello

The issue was with the ciphered user name and password.

The connection string had original username and password value, but had the X symbol before " Username" and "Password", which i guess means the credentials are ciphered.