Other users can't execute my pass through queries

G

gt

Using Access 2003.

I have a Pass through query to a SQL server, using a File DSN - works fine
for me. However, other users on our local network cannot run the query - they
get an ODBC call failed error message. I tried copying the DSN to their
machines - still no luck.

However, if I create the same query in Excel, using the same DSN, those same
users can refresh it - so it would not appear to be a case of permissions ...
they don't even need the DSN on their box.

What's going on? The connection strings are identical. The query is identical.

Any help is greatly appreciated. Thanks, gt
 
G

gt

Hi again -

I tried your suggestion, but when the query is executed, a SQL Server Login
dialog box is displayed, and it prompts me to select the server from a list.
Here's the ODBC connection string exactly as I have it specified:

ODBC;Driver={SQL Server};ServerName=s13021-d;
DatabaseName=RPTData_Prod;TrustedConnection=Yes

Since I've specified the server name, why is it prompting me to enter one?

Thanks - and thanks for your suggestion.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pass-Through Query / Multiple ODBC Connections 1
Connection string for pass-through query 2
Pass-Through Queries and File DSNs 1
How do I solve ODBC-call error on pass-through query? 3
ODBC Pass-through query with parameter from table 5
SQL Pass Through 1
Pass Through Query Question 4
Pass Through Make Table 7

Top