Re: SQL Code that is submitted to server changes when run on different clients
- From: Philipp Stiefel <phil@xxxxxxxxxxxxxxx>
- Date: Thu, 12 May 2005 16:55:00 +0200
"Dale" <DaleDeWitt@xxxxxxxxx> wrote:
> I have an application that works fine when I run it on my own
> client, but when it is run on a different client the SQL code
> that is generated is different.... Let me explain...
>
> I have an access ADP that in one of the reports, it uses a
> User-defined function(UDF) as its recordsource. By watching it
> run using SQL Profiler, I can see that when I run it on my PC,
> the SQL code that is sent to the SQL Server is correct, in that
> it selects all of the columns I was expecting it to. When I run
> it on another machine, the SQL that is generated is.....
> "Select 1 from "dbo"."udf_Author_Mailing"() and not all the
> columns.
Have you verified that the same version of MDAC is installed
on both clients?
Did you try to use "SELECT * FROM dbo.yourUDF()" as Recordsource
for the report?
cheers
Phil
--
Access FAQs: http://www.mvps.org/faq/mvp_faq_links.htm#Access
.
- Follow-Ups:
- References:
- Prev by Date: SQL Code that is submitted to server changes when run on different clients
- Next by Date: kirkmont001@bytefocus.com
- Previous by thread: SQL Code that is submitted to server changes when run on different clients
- Next by thread: Re: SQL Code that is submitted to server changes when run on different clients
- Index(es):
Relevant Pages
|
