It is quite possible that the MSDASQL is not adequate. Have you tried the other options for authentication? I recently compared MSDASQL with Microsoft Jet 4.0 for MS Access and found that MSDASQL is not as good. I don't have a SAGE Line 100 DB, otherwise I would have given a more useful advice. Can you try to set up a linked server in MS ...