Create new connection (OLE DB) issue

[gianpaolo_31]

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.

[Chanty4u]

Hi

check 32 bit or 64 bit?

https://community.qlik.com/thread/252069

https://community.qlik.com/thread/284628

https://www.youtube.com/watch?v=GpXblF6WE4M

[rittermd]

Dumb question.  I assume that you selected a database after you did the Test Connection and that worked fine?

[gianpaolo_31]

Yes. Database was selected. The only issue was that when clicking Create button.

[Anil_Babu_Samineni]

I recently faced this error, That means you have not success the correct approach. Can you share the doc where and how you are following?

[gianpaolo_31]

These were the steps.

- Clicked Create new connection

- Selected Microsoft OLE DB Provider for SQL Server

- Put file path/server name

- Supplied specific username and password

- Did a test connection (Successful)

- Clicked Load database

- Clicked Create button

Also tried to use other OLE DB provider such as Microsoft Jet 4.0 OLE DB Provider but same error.

[Anil_Babu_Samineni]

IS that issue still persist? Really difficult to explain. But here are few

- I've tested with same error - The moment i am using ACCDB (But, Without username and password i got success)

- But, your case is SQL Server (I believe check with SQL server and let us know whether they have given credentials)

[gianpaolo_31]

Hi Anil,

Yes, issue still persists.

Also tried creating connection to accdb and mdb using MS Jet 4.0 OLE DB with or without pw. But no luck.

With regards to SQL Server, they have provided login credentials.

Attached screencaps when creating connection to SQL Server

[sumit_ranjan_pa]

Have you checked if the port is open for connection?

[gianpaolo_31]

Hello Sumit,

Would you be able to tell me how to check in QS Desktop?

Thanks.