Skip to main content

An error occurred in the DB connection process in the process of transferring the previously used task to a new PC.
Please help me with what kind of preparation process I need.

 

Code:

Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DSN=ExcelDB;DBQ=$vOcrExcelFile$;DefaultDir=C:;DriverId=790;FIL=excel 8.0;MaxBufferSize=2048;PageTimeout=5;"

 

 

That’s an interesting question, gksdkwo !

I think the following community members may be able to help 

@Zaid Chougle 

@Tamil Arasu10 

@Sridhar Yadlapalli 

@Ashwin A.K 

@Padmakumar 

Hi ​@gksdkwo ,

 

Are using Excel As DB? If so, please try to use the ODBC driver and change the connection string accordingly.

 

Also, check the value you have given to the $vOcrExcelFile$. Since the error also says that the Datasource is unable to find, which indicates that the file path is not correct.

Terms & ConditionsCookie settings