[AccessD] Access SQL pass through query problem

Darren darren at activebilling.com.au
Tue May 14 22:13:36 CDT 2013


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



More information about the AccessD mailing list