Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Generally scheduled scripts run as a service. That service would not have access to a User DSN. You need to make sure you create a System DSN if you want that service to be able to access ODBC.
A user DSN is just that, a DSN for a specific user. If I create a user DSN under my user account, no other user can see it or use it. The DSN is for me and me alone. If you need a connection to a data source that only you should use, choose a user DSN.
A system DSN is a DSN that is seen by the entire system. Any user can see it, as well as any process or service. If you need a data source connection that should be seen more than just your user account, choose to use a system DSN. This is especially true if you are trying to establish a connection through a service.
Article ID: W17584
Filename: ODBC and Services.txt
File Created: 2017:07:28:12:58:32
Last Updated: 2008:11:25:12:55:34