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
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.
Regards
Gokul
@Tapan_Behera1 , The File path may vary from dev to Prod. so pass the file path as a dynamic
For Example
Assign
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.