DSN used by a pass-through query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am using a pass-through query to run a stored procedure directly on a SQL
Server 7.0 database, from Access 2000.

I have several of these defined and have been using them without trouble.

Now, I defined a new one and, every time I run it, I get the "Select Data
Source" dialog open and have to select the DSN. After doing so, the query
runs OK.

Any idea about why would this be happening would be appreciated.

Thanks in advance.
 
Are you sure you set the new query's ODBCConnectStr property correctly?
 
Douglas,

Thank you very much for your reply. Your question led me directly to the
problem.

I had a misconfigured "ODBC Connect Str" property for the query.

Thanks again.
 
You must log in or register to reply here.

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

ODBC DSN query issue 1
Other users can't execute my pass through queries 2
Pass-Through Query / Multiple ODBC Connections 1
Connection string for pass-through query 2
Pass-Through, Default DSN? 4
How to execute a pass-through query from a remote computer 0
DSN-LESS Connection Strings in Pass Thru QueryDef 1
Pass thru query with DSN info. 2

Back
Top