I have created a window service, and it runs to open a database and update values. The database resides on another server, and the local service has a system dsn setup. The account used to run the service is a domain user account that does have access to the database. Below is the error returned when using connection string:
myOdbcConnection = New OdbcConnection("dsn=finandb")
{"ERROR [HY024] [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
ERROR [HY024] [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides."} System.Exception
If I just create a windows forms application it is able to use the dsn, and no error is generated.
Is there something different required for a service? Any help would be appreciated.
myOdbcConnection = New OdbcConnection("dsn=finandb")
{"ERROR [HY024] [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
ERROR [HY024] [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides."} System.Exception
If I just create a windows forms application it is able to use the dsn, and no error is generated.
Is there something different required for a service? Any help would be appreciated.