Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gianpaolo_31
New 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
Chanty4u
Esteemed Contributor III

Re: Create new connection (OLE DB) issue

rittermd
Honored Contributor

Re: Create new connection (OLE DB) issue

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

gianpaolo_31
New Contributor III

Re: Create new connection (OLE DB) issue

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

Re: Create new connection (OLE DB) issue

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?

Life is so rich, and we need to respect to the life !!!
gianpaolo_31
New Contributor III

Re: Create new connection (OLE DB) issue

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.

Re: Create new connection (OLE DB) issue

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)

Life is so rich, and we need to respect to the life !!!
gianpaolo_31
New Contributor III

Re: Create new connection (OLE DB) issue

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 ServerCapture.PNG

Capture1.PNG

sumit_ranjan_pa
Contributor

Re: Create new connection (OLE DB) issue

Have you checked if the port is open for connection?

gianpaolo_31
New Contributor III

Re: Create new connection (OLE DB) issue

Hello Sumit,

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

Thanks.

Community Browser