slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Architect Forums - ADO General
Forum to discuss ADO specific questions for use with SalesLogix. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to ADO General | New Thread

View: Search:

Author

Thread: Command Not Supported by This Provider Error

John Gundrum
Posts: 632

Command Not Supported by This Provider Error Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 31 Jan 07 2:06 PM

Nothing is simple. Is it? I am trying to create an Integration Services project in SQL Server 2005 and do it the right way by using the SLX OLE DB provider. I created my data source which went fine. Next I try to create an OLE DB Source using a SQL statement. This is the SQL Statement

SELECT
	YEAR(a.estimatedclose) AS closeyear, 
	MONTH(a.estimatedclose) AS closemonth, 
	ISNULL(a.closeprobability, 0) AS closeprobability, 
	a.estimatedclose, 
	a.salespotential,
	a.opportunityid, 
	a.status
FROM Opportunity a
WHERE
	YEAR(a.estimatedclose) = YEAR(DATEADD(dd, -1, GETDATE())) AND 
	MONTH(a.estimatedclose) = MONTH(DATEADD(dd, -1, GETDATE()))
ORDER BY
	YEAR(a.estimatedclose), 
	MONTH(a.estimatedclose), 
	a.closeprobability, 
	a.estimatedclose

When I Parse Query I get a really strange error. If I click Build Query and click Verify SQL I am informed "The command is not supported by this provider."

Which command?

Thanks,
John G.

[Reply][Quote]

Timmus Agersea
Posts: 328

Re: Command Not Supported by This Provider Error Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 31 Jan 07 2:49 PM

Try removing the AS statements. You can alias without them and SLX does not like them.

SELECT	YEAR(a.estimatedclose) closeyear, 	
MONTH(a.estimatedclose) closemonth, 	
ISNULL(a.closeprobability, 0) closeprobability,

Timmus

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/22/2024 10:36:49 AM