[QODBC-Desktop] Troubleshooting : MS Access as middleware is not working with MS SQL Server
Posted by Jack - QODBC Support on 10 November 2014 02:51 PM
|
|
Troubleshooting: MS Access as middleware is not working with MS SQL ServerProblem Description: I am trying to use MS Access as a middleware with MS SQL Server. I have created MS Access database & linked all QODBC tables through QRemote DSN, After that, I have created MS Access DSN which is pointing to newly created database. After that, I have created the linked server which pointing MS Access DSN. Linked Server is created but when I run the query on the linked server, I am getting below error: Please help me to resolve this error.
Solutions:This error is not related to QODBC. You are facing this issue because MS SQL Server is log on as "Network Service". | |
|