Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sergio0592
Specialist III
Specialist III

DB connection issue

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

8 Replies
krishnacbe
Partner - Specialist III
Partner - Specialist III

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?

sergio0592
Specialist III
Specialist III
Author

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

krishnacbe
Partner - Specialist III
Partner - Specialist III

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?

krishnacbe
Partner - Specialist III
Partner - Specialist III

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

sergio0592
Specialist III
Specialist III
Author

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

krishnacbe
Partner - Specialist III
Partner - Specialist III

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

hari8088
Creator
Creator

Hi,

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

anilnaidu13
Creator
Creator

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