Posted by Hugo Kornelis on 01/24/06 23:31

On Tue, 24 Jan 2006 20:13:49 +0200, Max <rabkin@mweb[DOT]co[DOT]za>
wrote:

>I know this is not an Access group, but there doesn't seem to be one,

Hi Max,

There's comp.databases.ms-access. And over 20 groups in the
microsoft.public.access hierarchy. There are also access groups in many
international hierarchies, or in international sub-hierarchies of the
microsoft.public hierarchy.

>and I'm guessing MS SQLs are all quite similar - at least in relatively
>simple cases like this one.

Don't count on it - there are many major differences between Jet SQL
(used in Access) and Trasact SQL (used in SQL Server). T-SQL tends to be
a lot closer to the ANSI-defined SQL standards.

>
>I'm using this SQL statement,
>
>"SELECT [Cape Town 25/04].IDNUMBER, [Cape Town 25/04].SURNAME,
> [Cape Town 25/04].NAMES, Misc.PHONE_NUMBER,
>Misc.VOTE FROM [Cape Town 25/04] LEFT JOIN Misc
>ON [Cape Town 25/04].IDNUMBER = Misc.IDNUMBER
>WHERE STREETNAME='FIRTH ROAD' AND STREETNO='3FI' AND BLDNGNAME IS NULL
>AND BLDNGNO IS NULL"
>
>and getting this error message: "[Microsoft][ODBC Microsoft Access
>Driver] Too few parameters. Expected 2. in EXEC"
>
>Where is the missing parameter? I think it's something to do with the
>LEFT JOIN, but I'm not sure - I'm a SQL newbie.

According to the error message, two parameters where expected in EXEC.
The code you posted does not contain the word "EXEC". Maybe you should
double-check if the error is not produced by another part of your code?

Anyway, the query you posted passes the syntax check of SQL Server 2000
without problems.

>
>I'm accessing an MS Access database from Python via the PythonWin obdc
>interface, if it makes a difference.
>
>--Max


--
Hugo Kornelis, SQL Server MVP

[Back to original message]