topic Re: Qlik DataTransfer - not able to create a data connection "could not create connection" in Connectivity & Data Prep

Qlik DataTransfer - not able to create a data connection "could not create connection"

Carl_Hunter — Fri, 10 Dec 2021 21:06:16 GMT

Hi, getting an error below when trying to connect to an ODBC driver. I've also tried other connection types i.e. SQL Server, with the same error

I've checked the logs (C:\ProgramData\Qlik\DataTransfer\Log\DataUploadService), and the following is reported:

24 20210706T202138.755+0100 localhost 4.0.0 Global INFO Data Upload Service listening on: https://127.0.0.1:5505
25 20210706T202200.074+0100 localhost 4.0.0 Global ERROR Error: Connection ID 0 couldn't be found.
26 20210706T202200.074+0100 localhost 4.0.0 Global ERROR Error: Connection ID 0 couldn't be found.
at Object.getConnection (C:\Program Files\Qlik\DataTransfer\DataUploadService\index.js:214:146212)
at async getDatasetById (C:\Program Files\Qlik\DataTransfer\DataUploadService\index.js:471:94376)
at async createConnection (C:\Program Files\Qlik\DataTransfer\DataUploadService\index.js:471:90781)

I've tried rebooting the server, stop/starting services to no avail

Any ideas Qlik guys and gals?

Re: Qlik DataTransfer - not able to create a data connection "could not create connection"

Qlikstu — Tue, 13 Jul 2021 09:59:01 GMT

Thanks for raising this Carl. I have the same issue 😉

I tested the ODBC connection on Qlik Sense Desktop (I am using SQLite) and it works fine so not sure where to go on this next....

Stu

Re: Qlik DataTransfer - not able to create a data connection "could not create connection"

Carl_Hunter — Tue, 13 Jul 2021 11:59:53 GMT

I've reported it as a fault to support but not heard anything back yet @Qlikstu

The workaround was to type something in the username/password box. For some reason, QDT wants credentials even though the driver takes care of the authentication. Not sure why as it works fine in Desktop...

Re: Qlik DataTransfer - not able to create a data connection "could not create connection"

Qlikstu — Tue, 13 Jul 2021 12:21:45 GMT

Thanks for raising this with support Carl. I tried the workaround you suggested and typing "some text" in the U/P fields, but alas I still got the same error.

Re: Qlik DataTransfer - not able to create a data connection "could not create connection"

inge12 — Tue, 28 Sep 2021 13:05:03 GMT

Did you already find a solution?

I have the same problem

Re: Qlik DataTransfer - not able to create a data connection "could not create connection"

JolaQ — Mon, 14 Mar 2022 13:36:30 GMT

I have the same issue.

No solution?

Re: Qlik DataTransfer - not able to create a data connection "could not create connection"

inge12 — Mon, 14 Mar 2022 13:41:14 GMT

I had that the password needed to be ODBC.

Re: Qlik DataTransfer - not able to create a data connection "could not create connection"

JolaQ — Mon, 14 Mar 2022 14:10:20 GMT

You used the same username as in the ODBC connection but switched out the password to "ODBC"?

Did not work for me.

Re: Qlik DataTransfer - not able to create a data connection "could not create connection"

JordyWegman — Thu, 19 May 2022 11:55:21 GMT

Thanks for this one @Carl_Hunter! It actually helped and for me you can mark this solution as solved.

A bit more about my specific case:

I wanted to access a Microsoft Access Database (accdb) with Qlik Data Transfer. While setting up a 32bit and 64bit User and System DSN, it all didn't work.

I entered a fake name and password and with that, the connection succeeded. At the end we used the 64bit, System DSN.

Jordy

Climber

Re: Qlik DataTransfer - not able to create a data connection "could not create connection"

mattias — Mon, 27 Mar 2023 16:42:55 GMT

I have the same issus as well. Running Data Transfer November 2022. Got it to work randomly 1 time but never since. Any ideas?

Solved it with blank space for user and password

Re: Qlik DataTransfer - not able to create a data connection "could not create connection"

Tamarah — Thu, 01 Aug 2024 11:25:35 GMT

Thank you for sharing this sollution. Worked for me as well.