[dba-SQLServer] Access SQL pass through query problem

Stephen Bond stephen at bondsoftware.co.nz
Mon May 13 23:40:01 CDT 2013


CROSS POSTED 

Neophyte question ... 

Windows 7.  Access 2010.  SQL Server2008R2.

In my ODBC Data Source I have set up a UserDSN and a SystemDSN, pointing
to the SQL back-end I'm reporting from (copy of customer's SQL back-end,
on my PC).

When I send the Access 2010 front end to the customer to test, the
LinkedTable Manager re-links to the SQL tables OK but the
PassThroughQueries fail.  I checked the PassThroughQuery Properties, and
the ODBC Connect String includes "ODBC;DSN=myName; ..." etc.  The PTQ is
coughing at the lack of resolution of 'myName'.

I checked at the customer site and they don't have any UserDSN or
SystemDSN set.  They are relying on a DSN file.  When they use the
LinkedTable manager it strips my 'DSN=' from the table re-connection ...
how do I cope with the same on PassThrough Queries?


Stephen Bond



More information about the dba-SQLServer mailing list