Re: pass through query
- From: "Rick Brandt" <rickbrandt2@xxxxxxxxxxx>
- Date: Tue, 21 Feb 2006 02:05:02 GMT
pedro wrote:
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 canselect 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.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
.
- Prev by Date: Best way to do this query
- Next by Date: Re: Eliminate spases in number
- Previous by thread: Best way to do this query
- Next by thread: Re: Copy Information Within a Table
- Index(es):
Relevant Pages
|
