Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
gianpaolo_31
Contributor III
Contributor III

Create new connection (OLE DB) issue

Hi All,

I tried to create a new OLE DB connection in Qlik Sense Desktop but having Connector connect error: {0}.

All credentials have been supplied correctly.

Test Connection, it was successful.

I only encountered the error when clicking Create button.

Thanks.

25 Replies
sumit_ranjan_pa
Partner
Partner

Hi Gian, If you are using a corporate PC, then the port is must likely be closed. I cannot tell you the port for it. Depends on the DB. Please google it.

However, as you can connect the DB and have a successful test, the port issue might not be pertinent.
Can you try running the desktop in admin mode? That might help.

The error is really vague, might be anything. Driver to access issues. May be mto‌ would be able to give us any insights.

Thanks and regards,

Sumit

gianpaolo_31
Contributor III
Contributor III
Author

Hello Sumit,

Have created new connections just now. But I find it weird because earlier, I was not able to create new connections (OLE DB). Will keep you posted tomorrow if the issue will occur.

Thanks.

sumit_ranjan_pa
Partner
Partner

Hi Gian,

That's great.

Did you try with Admin access?

Thanks!

gianpaolo_31
Contributor III
Contributor III
Author

Hi Sumit,

No. not yet.

Michael_Tarallo
Employee
Employee

Thanks guys - for the great communication - let us know what you find - typically something like this is network, port, firewall related. - Keep in mind that Qlik Sense Desktop is a web application with a Chromium wrapper - so it is possible that an executable was blocked our port was denied access at one point.

Chromium Embedded Framework - Wikipedia

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Regards,

Michael Tarallo

Qlik

Regards,
Mike Tarallo
Qlik
gianpaolo_31
Contributor III
Contributor III
Author

Hello Guys,

Update:

Successfully created new OLE DB connections.

Thank you for your help and inputs.

bwisealiahmad
Partner
Partner

Would be great if you could point out what you did to make this work

gianpaolo_31
Contributor III
Contributor III
Author

Actually the issue still persists.

We somehow managed to create new connection few weeks ago.

bwisealiahmad
Partner
Partner

After getting access to Management Studio I checked that it set to SQL Auth and it wasn't. After changing that it worked for me!

gianpaolo_31
Contributor III
Contributor III
Author

I tried to create new connection again earlier to test but the same error. But after a few minutes, was able to create new connection.