ODBC Problem on IIS4

[M.-A. Lemburg]

Jack Knight wrote:
> 
> I am getting the following error when trying to do a simple SQL lookup:
> 
> 
>      File "C:\InetPub\cgi-bin\loginMethod.py", line 54, in getCName
>          cursor.execute(query,params)
>      dbi.internal-error: [Microsoft][ODBC Microsoft Access 97 Driver] Invalid argument. in EXEC
> 
> Setup is:
> Windows NT4 SP5, IIS4, ODBC V3.5. Python 1.5.
> 
> Offending Code fragment:
> 
>  query="select CustomerID, Password, Status from CustomerDetails where CustomerID=:1 and Password=:2"
>  cursor.execute(query,params)

ODBC uses the question mark as parameter marker, ':n' is Oracle
style I think.

-- 
Marc-Andre Lemburg
______________________________________________________________________
Y2000:                                                    21 days left
Business:                                      http://www.lemburg.com/
Python Pages:                           http://www.lemburg.com/python/