Question posted 2012 · +7 upvotes
I’m using DSN-less connections to my SQL Server in an Access database. However, whenever I try to write a “Pass-Through” query and run it, a dialog box pops up asking for the DSN.
Accepted answer +14 upvotes
In SQL view, choose properties after you have selected passthrough query and insert an ODBC connect string. For example:
ODBC;DRIVER=SQL Server;SERVER=ServerInstance;Trusted_Connection=Yes;DATABASE=Test
Top ms-access Q&A (6)
- How can I modify a saved Microsoft Access 2007 or 2010 Import Specification? +31 (2008)
- OleDbCommand parameters order and priority +28 (2009)
- Is there an equivalent to the SUBSTRING function in MS Access SQL? +26 (2009)
- What do I need to read Microsoft Access databases using Python? +25 (2009)
- MS Access library for python +24 (2009)
- is there any replacement of Access? +21 (2009)
ms-access solutions on this site
— top 20%.