ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Hello Community,

Can you please guide me for this error. I am using excel as database and also able to run it on my dev machine but getting the above error while running it on prod.

Hi @Tapan_Behera1 ,

Have you performed the same setup of configuration in the ODBC Data sources in Prod Environment as you have done in the Dev Environment ?

Hello @Tapan_Behera1
Refer to this link and follow the steps, you may get some idea

1 Like

Hi @Tapan_Behera1

This error message usually occurs when the ODBC driver is not installed or configured correctly[^]. You can try to resolve this issue by checking if the ODBC driver is installed and configured correctly. If it’s not, you can install or configure it and try again.


@Tapan_Behera1 , The File path may vary from dev to Prod. so pass the file path as a dynamic
For Example

FilePath="YourPath\Filenamre.xlsx"  ----- Change the file path as your requirement

Provider=Microsoft.ACE.OLEDB.12.0; Data Source="+FilePath+"; Extended Properties='Excel 12.0 XML;HDR=YES;ReadOnly=False'

Please check if ODBC driver is installed or not. If installed check for version which is supported by sytem that whether its 64bit or 32bit

Hi @supermanPunch thanks for your reply. Yes in prod I have installed the ODBC driver and add the datasource name that I have done in Dev , but still getting same error.

Yes @Gaurav_Malhotra I have installed the ODBC driver in prod and also version are same.

Hi @Gokul001 yes I have installed the odbc driver in prod and configured same that I have done in dev.

May be installed odbc version is not supported. Try to install another version and try

Thank you @Gokul001 @Gokul_Jayakumar @supermanPunch @Gaurav_Malhotra for our response. The issue was resolved. Actually everything was good but due to permission issue I was getting that error.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.