Hello everybody, I'm using DBI v1.51 and DBD::ODBC v1.13. I'm connecting to MSSQL2000/MSSQL2005. Statements are executed in prepare-execute-fetch order.
Everything works fine, since I found something suspicious: if a string ":00" occurs in a comment, then DBD::ODBC tries to bind this "placeholder" and break with error "Can't rebind placeholder 00 at ..." (line 1971 in dbdimp.c). The Microsoft ODBC driver produces error "[Microsoft][ODBC Driver Manager] Invalid parameter number" (described as error number S1093 on http://www.microsoft.com/technet/prodtechnol/sql/70/proddocs/diag/part3/75528c16.mspx?mfr=true) Example 1: <start of sql> -- :00 SELECT 'FOO' <end of sql> Example 1 produces the error above. Example 2: <start of sql> -- :01 SELECT 'FOO' <end of sql> Example 2 works fine... Can anybody else reproduce this error? Is this a bug? Thanks! Andon --------------------------------- Ahhh...imagining that irresistible "new car" smell? Check outnew cars at Yahoo! Autos.