Stephen Bond
stephen at bondsoftware.co.nz
Tue May 14 16:26:48 CDT 2013
Thanks Doug, The tables at the client site re-link OK using Linked Table Manager but the Pass Through Query still has the Connection String from my development PC. I'll work my way through your document and get back if there's further questions ... Stephen Bond -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Doug Steele Sent: Wednesday, 15 May 2013 2:30 a.m. To: Stephen Subject: Re: [dba-SQLServer] Access SQL pass through query problem You can control the connection string if you make the connection in code: http://www.accessmvp.com/DJSteele/DSNLessLinks.html Doug On Tue, May 14, 2013 at 12:49 AM, Mark Breen <marklbreen at gmail.com> wrote: > Hello Stephen, > > this only way I build my ODBC connections it from within Access. I think I > usually use machine DSN. > > I simply click the builder in the connection string section of the pst and > choose or create a ODBC from within Access. If I create it for the linked > tables, I can simply select it from the pst, or vice versa but I always > seem to have to create the odbc from within access. This method works well > for me for years. > > Mark > > > > On 14 May 2013 05:40, Stephen Bond <stephen at bondsoftware.co.nz> wrote: > > > 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 > > > > _______________________________________________ > > dba-SQLServer mailing list > > dba-SQLServer at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > > http://www.databaseadvisors.com > > > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com