Stephen Bond
stephen at bondsoftware.co.nz
Tue May 14 23:13:17 CDT 2013
For sure, all help gratefully accepted. I've been trying to break in to real SQL Server stuff, not easy in a town of 45K at the bottom end of nowhere. Finally got the opportunity and I want to make it a good 'un. Government pension here don't make you rich so ya jes keep boxin' on. TIA Stephen -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren Sent: Wednesday, 15 May 2013 3:16 p.m. To: Stephen Subject: Re: [AccessD] Access SQL pass through query problem Hi Stephen Have you tried using DNSless connection routines? I have a sample dB if you'd like to see it. And some cool code for creating grids on the fly based on the query result set fields To get it to run you need SQLServer IP address or SQLServerName SQL dB name: Uname: Pwd: Lemme know if you like to see it Darren -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stephen Bond Sent: Tuesday, 14 May 2013 2:38 PM To: Access Developers discussion and problem solving Subject: [AccessD] Access SQL pass through query problem 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com