pedro said:
I'm trying to create a pass-through query to connect from Access to
an SQL server database. I need to set/connect the ODBC property and
specify the name of the SQL server database?
Can anyone assist by way of an example?
In the ODBC Connect String property box press the build button [...] to the
right. That will open the ODBC Manager applet normally accessed via Control
Panel.
In that dialog go to the Machine Data Source tab and press the [New] button.
User or System in the next choice only matters if multiple users use the PC.
Pick as appropriate then [Next].
Scroll to the bottom of the list of drivers and find the one for SQL Server. In
the next pane give the DSN a name and description and the name of the Server.
From memory I don't remember the remaining pages, but for the most part you can
select the name of the database you want as the default database and then most
other options can go with the defaults. The final page is a page that lets you
test the connection. If it comes up successful you should be good to go.
The above assumes that a DSN pointing at your server does not already exist.
You only have to create one DSN and then for subsequent passthrough queries and
table links you can just choose that one when from the Machine Data Source Tab.
