Hello All,
I have Access Database in shared location but when I run the query it populates following error "ODBC--connection to 'C58DG001SQL' failed."
But when I run it by logging in to the remote desktop connection where the actual database is located, it runs fine. I am trying to automate this process, instead of logging everytime using remote desktop connection. I have placed this Access Database in a shared location and created a BAT file which is scheduled using Task scheduler and will run the Access Query. But unfortunately I encountering SQL connection error.
Can anyone provide me a solution for this.
Regards,
Yash20