topic Re: DB connection issue in QlikView

DB connection issue

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

Hi all,

I have changed my laptop this morning with reinstatement of QlikView. So, i'am unable to reload apps because i can't connect to the Oracle DB. As usual, i have the connection string in my script with OLEDB CONNECT32 TO XXXX

See below the dialog box i get when i launch reload.

Thanks

Re: DB connection issue

krishnacbe — Mon, 09 Oct 2017 14:30:05 GMT

Hi,

While creating the OLEDB connection string provide the Username and Password and test the Data Source Connection is successful or not.

If you provide the Correct password it is reloading or providing any error?

Re: DB connection issue

sergio0592 — Mon, 09 Oct 2017 14:35:48 GMT

No, it changes nothing, contunue to ask with dialog box.

Re: DB connection issue

krishnacbe — Mon, 09 Oct 2017 14:43:06 GMT

Try to create a ODBC connection with the User Name and Password or do you able to connect to the DB using SQL developer/Toad?

Re: DB connection issue

krishnacbe — Mon, 09 Oct 2017 14:43:28 GMT

Just to check the user Name and password is not changed in DB

Re: DB connection issue

sergio0592 — Mon, 09 Oct 2017 14:45:24 GMT

Yes, i forgot to specify that my connection on SQL developper works.

Re: DB connection issue

krishnacbe — Mon, 09 Oct 2017 14:49:01 GMT

Ok. Try to create ODBC Connection or Delete the existing OLEDB connection string and generate a new.

Re: DB connection issue

hari8088 — Mon, 09 Oct 2017 14:55:00 GMT

Hi,

check with your database team that any changes in data base pwd or username or server name.

Re: DB connection issue

Anonymous — Mon, 09 Oct 2017 15:04:41 GMT

Drop the Existing Connection from ODBCAD32 and comment the same in your script.

Click on Windows R and Type ODBCAD32 and Create a System DSN if you have Admin access else go with User DSN.Check the connection is test first then add the ODBC connection in Qlikview then reload