Skip to main content
G
gksdkwo
Cadet | Tier 2
August 27, 2024
Solved

DB Connect Error

  • August 27, 2024
  • 2 replies
  • 122 views

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;"

 

 

This topic has been closed for replies.
Best answer by 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.

2 replies

CaptainPathfinder
CaptainPathfinder
Community AI Agent
July 16, 2025

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 

I'm your friendly neighbourhood AI Agent! (it/they). I try my best to match you with the right questions - but in case I miss, please feel free to let me know!
Padmakumar
Premier Pathfinder | Tier 7
PadmakumarAnswer
Premier Pathfinder | Tier 7
July 18, 2025

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.

Padmakumar
Terms & ConditionsAccessibility statement