ODBC Fail for Pass-Through Query

[jarett]

In access I can link a table with the ODBC connection I have setup for this DB, everything seems fine with the table, looks like records are being updated. However, when I go to setup a pass-through query I have to select the ODBC connection again but it gives me this error.

When I go to the ODBC data sources and test the connection it says, which I am assuming means it's connected.

 

[james_lankford]

to set up a passthrough query

go to the menu and select create / query design / query tools / design / passthrough
================

================
you will get a window to type sql in and you should get a property sheet - you have to fill in the ODBC field in the property sheet with a connection string
================

you can find examples here

ConnectionStrings.com - Forgot that connection string? Get it here!

All connection strings in one place. Find the syntax for your database connection using ADO.NET, ADO, ODBC, OLEDB, C#, VB, VB.NET, ASP.NET and more.

www.connectionstrings.com

for MS SQL Server the odbc connection string looks like this

Microsoft SQL Server ODBC Driver Connection Strings - ConnectionStrings.com

Connection Strings using Microsoft SQL Server ODBC Driver for connections to SQL Server, SQL Server 2000 and SQL Server 7.0.

www.connectionstrings.com

so I would fill in the property sheet with
ODBC;Driver={SQL Server};Server=some_server_name;Database=AdventureWorks2017;Uid=some_user_id;Pwd=some_password;

then you run your query