Skip to main content
Solved

DB Connect Error

  • August 27, 2024
  • 2 replies
  • 67 views
G
Forum|alt.badge.img+2

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

 

 

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.

This topic has been closed for replies.

2 replies

CaptainPathfinder
Forum|alt.badge.img+3

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
Forum|alt.badge.img+15
  • Padmakumar
  • Premier Pathfinder | Tier 7
  • Answer
  • 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 & ConditionsCookie settingsAccessibility statement