Forum Discussion
buzz43uk
Feb 14, 2019Copper Contributor
MS Access Passthrough Query keeps asking for DNS but others don't
Hi May have found the issue but not the solution. The query below is a passthrough to Intersystems Cache database via ODBC "SELECT * FROM wmhISTORYdETAIL" runs as a passthrough without askin...
Philipp Stiefel
Mar 02, 2019Copper Contributor
This has nothing to do with the SQL of the query. Open both queries in design and compare the connection strings in the Connect-Property of the queries. Copy the one from the working query to the other.