PC Review


Reply
Thread Tools Rate Thread

Total parameter query and ODBC-call failed

 
 
Ivan
Guest
Posts: n/a
 
      18th Feb 2010
Hello,

I use Access 2007 as a front-end to a Microsoft SQL 2008 database via an
ODBC connection using SQL Server Native Client 10.0 driver.

If I want to run a total parameter query like this one:

PARAMETERS [Parameter1] Text ( 255 );
SELECT TABLE1.FIELD1, [Parameter1] AS FIELD2, Sum(TABLE1.FIELD3) AS FIELD3
FROM TABLE1
WHERE <some filters>
GROUP BY TABLE1.FIELD1, [Parameter1];

then I get the error message: "ODBC-call failed". TABLE1 is a table from
SQL server.

I don't have any problem using simple select query:

PARAMETERS [Parameter1] Text ( 255 );
SELECT TABLE1.FIELD1, [Parameter1] AS FIELD2, TABLE1.FIELD3
FROM TABLE1
WHERE <some filters>

I get but the same error "ODBC-call failed" if I save first the second query
(for example qrySaved) and run then a new total query:

SELECT qrySaved.FIELD1, qrySaved.FIELD2, Sum(qrySaved.FIELD3) AS FIELD3
FROM qrySaved
GROUP BY qrySaved.FIELD1, qrySaved.FIELD2;

Why? It seems to me that in earlier versions of connections between access
and SQL I didn't have any such difficulty:

Thank you for any assistance and help

Ivan




 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Http Post Error: A connection attempt failed because the connectedparty did not properly respond after a period of time, or establishedconnection failed because connected host has failed to respond. Deepu Microsoft Dot NET Framework 1 9th Jul 2009 05:09 PM
TO FIND TOTAL ORDERS SHIPPED AND NOT SHIPPED AND TOTAL OF AMOUNT WHICH WERE SHIPPED AND WHICH WERE NOT SHIPPED Ashley Microsoft Access Queries 2 3rd Oct 2006 09:18 PM
TO FIND TOTAL ORDERS SHIPPED AND NOT SHIPPED AND TOTAL OF AMOUNT WHICH WERE SHIPPED AND WHICH WERE NOT SHIPPED Ashley Microsoft Access 1 2nd Oct 2006 08:01 PM
error STOP:0x0000007B (parameter, parameter, parameter, parameter) robert35 Microsoft Access Getting Started 1 15th Dec 2004 04:28 PM
Report showing current total, previous total and average total? Richard Black Microsoft Access Reports 3 20th Jul 2004 01:22 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:43 AM.