Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Paradox ODBC Error: Too few parameters.

Status
Not open for further replies.

Josh6273

Programmer
Nov 13, 2001
17
US
I have been banging my head against the desk on this for a week and am
coming up empty handed.

I have several reports in Crystal Reports 8.5 that are giving me troubles in
the Paradox ODBC layer. I keep getting errors stating "ODBC
error:[Microsoft][ODBC Paradox Driver] Too few parameters. Expected 2"
I think that the problem is related to the Crystal-generated SQL, but I'm
not sure. For example one SQL statement looks like this:
Code:
SELECT
    Customer_Co0.`Contact ID`, Customer_Co0.`Person First Name`, <...snip>
FROM
    (((((`Customer` Customer_Co0 INNER JOIN `Homeelev` Home_Elevat2 ON
        Customer_Co0.`Community ID` = Home_Elevat2.`Community ID`)
     INNER JOIN `Lotglobl` Divisional_3 ON
        Customer_Co0.`Community ID` = Divisional_3.`Community ID`)
     INNER JOIN `Dsew14` dsew14 ON
        Customer_Co0.`Contact ID` = dsew14.`Contact ID`)
     INNER JOIN `Changeor` Change_Orde5 ON
        Customer_Co0.`Contact ID` = Change_Orde5.`Contact ID`)
     INNER JOIN `comminfo` Community_P1 ON
        Customer_Co0.`Community ID` = Community_P1.`Community ID`)
     INNER JOIN `CHORAPPR` Change_Orde6 ON
        Change_Orde5.`Contact ID` = Change_Orde6.`Contact ID`
WHERE
    Customer_Contacts.`Contact ID` = ''
ORDER BY
    Change_Orders.`Change Order ID` ASC

When I change the WHERE clause to be Customer_Co0, I get the same error
excpet it is &quot;Expected 1&quot; instead of 2.

I am getting desperate to get a fix for this, so any advice you can pass my
way would be appreciated.

Thanks!
Josh
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top