Data source name not found and no default driver specified

dhananjaya · March 30, 2021, 10:51am

Does anyone help me on solving below error, “Data source name not found and no default driver specified”

andrew.rybka · March 30, 2021, 12:45pm

Hi @dhananjaya and welcome to the Community!

Can you please share more details on that error? When does it appear? Maybe you post a screenshot of that error and the corresponding action or connector?

RJO · April 2, 2021, 1:48pm

I would check 3 things :

Names of ODBC must match exactly
ODBC is 64 bits
ODBC was added in the system tab rather than the user tab in the ODBC administration tool

Maheshwar · September 14, 2022, 10:25am

Hi @RJO

I have a odbc bundle with both 32/64 bits still I am facing the same error.

RJO · September 19, 2022, 11:20am

Is it possible to share here the morph project ? It would be easier to understand the issue.

andrew.rybka · September 19, 2022, 2:30pm

Hi @Maheshwar,

Please ensure that the DSN is created in the 64-bit version of ODBC Administrator.

Maheshwar · September 20, 2022, 7:56pm

Hi @andrew.rybka

Can you please elaborate how to create?

andrew.rybka · September 21, 2022, 2:25pm

Hi @Maheshwar,

Open the Windows start menu
Type in ODBC
Choose ODBC Administrator 64-bit
Recreate the existing DSN or create a new one.

If that won’t help, please post screenshots of your ODBC connector settings and of the corresponding error message.

Maheshwar · September 21, 2022, 2:51pm

Hi @andrew.rybka

Thanks for the reply after following the above process still facing the below issue:

andrew.rybka · September 21, 2022, 3:25pm

Your task is executed with a worker that is configured to work under the LOCAL SERVICE Windows account. That account only has access to System DSNs.

Please make sure that you created a System DSNs (and not a User DSN) on the computer that runs EasyMorph Server. And that you EasyMorph ODBC connector references that system DSN and not a User DSN with the same name.

As an alternative, if you really have to use User DSN, you can make the task to be executed under a user Windows account (by creating a new Worker and assigning that Worker to task’s space). The user account, specified in the new worker, should be that same account that was used to create the User DSN.

Maheshwar · September 21, 2022, 7:05pm

Hi @andrew.rybka

Can you share me any screenshots step by step how to do that or help me with any alternative as I never did these stuff previously.

Maheshwar · September 21, 2022, 7:18pm

Hi @andrew.rybka

I have created a system DSNs as you mentioned but the same error as below attached.

andrew.rybka · September 23, 2022, 5:46pm

Hi @Maheshwar,

I sent an email to the address specified in your Community profile. Please check your inbox.

Maheshwar · October 13, 2022, 9:58am

Hi @andrew.rybka

We are facing the same issue can you please look into it, Also trying to reply back to the mail but its not getting delivered

andrew.rybka · October 13, 2022, 12:53pm

Hi @Maheshwar,

I sent you a personal message. Please check the Messages section in your Community profile.

jcaseyadams · October 19, 2022, 9:21pm

Hi @Maheshwar,

If you are creating the ODBC 64 bit DSN on your desktop and then publishing the project to the EasyMorph server, the server must have the same DSN or the task will fail. Did you set up a duplicate DSN on the EasyMorph server?

ljayasuriya · November 20, 2024, 9:27pm

I have same issue " ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Location: action "Import from database", table "XX_XXXXXX_SALES_"

1- I created ODBC connector in server as well.

andrew.rybka · November 20, 2024, 9:49pm

Which type of DSN you are using - System DSN or User DSN?

ljayasuriya · November 20, 2024, 9:56pm

System DSN.

ljayasuriya · November 21, 2024, 5:43pm

I am still have snowflake connection issue with ODBC. Any help appreciated.