14

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.

Brett G
  • 349
  • 2
  • 4
  • 20

1 Answers1

23

In SQL view, choose properties after you have selected passthrough query and insert an ODBC connect string. For example:

ODBC;DRIVER=SQL Server;SERVER=Server\Instance;Trusted_Connection=Yes;DATABASE=Test

See also: http://www.connectionstrings.com/sql-server-2008

Fionnuala
  • 90,370
  • 7
  • 114
  • 152
  • 3
    Ahhh, under "ODBC Connect Str". How easy, but so hard to find. Thanks! – Brett G May 24 '12 at 20:07
  • Will someone explain why this is the case? Shouldn't the Query pass through easily with the DSN-less connection? – namko Dec 13 '18 at 02:47