Sir, I already added the datasource as file(datasource type) succesfully but it couldn't be shown in the dataset list.
When I trying that option(Add to Gateway) and submit the form I get the following error :
can you explain me How I connect ms access file using On Premises Gateway and which type of authentication method I used for Oledb datasource type (Currently I use Basic ).
I would suggest you create a new post in this forum for us to investigate more. According to my experience, the username of the Windows could be like below. "ComputerName\Username" or "DomainName\Username". Please give it a try.