Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
kev6brown
Partner - Creator
Partner - Creator

OLE DB SQL Test Failed

Hi,

 

I have an app that's been creating on the desktop version but now needs to be on our server. However, when I try to connect using OLE DB to SQL it keeps failing, why?

 

Kev

2 Replies
Brett_Bleess
Former Employee
Former Employee

You need to be sure you have installed/configured the OLE DB driver on the server, that would be my best hunch as to where things are going wrong, the only other thing that comes to mind is ensuring the service account running the Qlik services is allowed access to things in the DB too.  Hopefully one of those two may be the underlying issue.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
kev6brown
Partner - Creator
Partner - Creator
Author

Ah yes, of course, that makes sense, thanks