DSN used by a pass-through query

[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 J. Steele]

Are you sure you set the new query's ODBCConnectStr property correctly?

 

[Guest]

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.