ODBC Problem on IIS4
M.-A. Lemburg
mal at lemburg.com
Fri Dec 10 12:03:13 EST 1999
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/
More information about the Python-list
mailing list