Similar to another problem, different application.
Query works in 5, chokes in MX7

Error Message:
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver]Optional feature not implemented

The error occurred in C:\Inetpub\wwwroot\srd\forests\psp\LLDListing.cfm: line
33
Called from C:\Inetpub\wwwroot\srd\forests\psp\SearchResult.cf m: line 45
Called from C:\Inetpub\wwwroot\srd\forests\psp\LLDListing.cfm: line 33
Called from C:\Inetpub\wwwroot\srd\forests\psp\SearchResult.cf m: line 45

31 : <CFProcParam value="#Sect_Min#" cfsqltype="CF_SQL_BIGINT" type="In">
32 : <CFProcParam value="#fMemberID#" cfsqltype="CF_SQL_VARCHAR" type="In">
33 : <CFProcResult Name="LLDSearch">
34 : </CFStoredProc>
35 :



SQL {call qWebLegalLandTwp( (param 1) , (param 2) , (param 3) , (param 4) ,
(param 5) , (param 6) )}
DATASOURCE srd_PSPProdData
VENDORERRORCODE 106
SQLSTATE HYC00

Please try the following:
Check the ColdFusion documentation to verify that you are using the correct
syntax.
Search the Knowledge Base to find a solution to your problem.


Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR
1.1.4322)
Remote Address 142.94.5.96
Referrer [url]http://d-c-240186/srd/forests/psp/[/url]
Date/Time 18-Apr-05 02:01 PM

Access Querys:
first:
SELECT qWebLegalLand2.*
FROM qWebLegalLand3 INNER JOIN qWebLegalLand2 ON
(qWebLegalLand3.MemberUserName = qWebLegalLand2.MemberUserName) AND
(qWebLegalLand3.PSPId = qWebLegalLand2.PSPId)
WITH OWNERACCESS OPTION;

Calls:

SELECT PSPs.MemberUserName, PSPs.PSPId, PSPs.Plot, PSPTypes.PSPType,
PSPs.PlotAreaM2, PSPStatus.PSPStatus, PSPReserveTypes.PSPReserveTypes,
PSPs.PSPReserveNumber, PSPReserveStatus.PSPReserveStatus,
PSPReserveSizes.PSPReserveSize, PSPs.PSPReserveArea, PSPMeridians.PSPMeridian,
PSPs.Notes
FROM PSPTypes RIGHT JOIN (PSPStatus RIGHT JOIN (PSPReserveTypes RIGHT JOIN
(PSPReserveStatus RIGHT JOIN (PSPReserveSizes RIGHT JOIN (PSPMeridians RIGHT
JOIN PSPs ON PSPMeridians.PSPMeridianId = PSPs.PSPMeridianId) ON
PSPReserveSizes.PSPReserveSizesId = PSPs.PSPReserveSizeId) ON
PSPReserveStatus.PSPReserveStatusId = PSPs.PSPReserveStatusId) ON
PSPReserveTypes.PSPReserveTypesId = PSPs.PSPReserveTypesId) ON
PSPStatus.PSPStatusId = PSPs.PSPStatusId) ON PSPTypes.PSPTypeId = PSPs.PSPTypeId
WHERE PSPTypes.PSPType <> "Closed"
WITH OWNERACCESS OPTION;

and:

PARAMETERS pMer Long, pRge Long, pTwp Long, pSectionMin Long, pSectionMax
Long, pMemberUserName Text ( 255 );
SELECT DISTINCT L.MemberUserName, L.PSPId
FROM PSPLlds AS L
WHERE ( ((L.Mer) = [pMer] AND (L.Rge) = [pRge] AND (L.Twp) = [pTwp]) AND
(L.[Section] Between [pSectionMin] And [pSectionMax]) AND (L.MemberUserName
LIKE pMemberUserName))
WITH OWNERACCESS OPTION;

I inherited this, please HELP!