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.
 
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.
 
Back
Top