|Keep It Simple, Stupid|
Re: perl DBI errorby RazorbladeBidet (Friar)
|on Apr 05, 2005 at 16:13 UTC ( #445026=note: print w/replies, xml )||Need Help??|
Can you run the statement directly in SQL Server?
It looks to be more of a DB issue (SQL Server) than DBI, but that's not 100% certain.
Post formatted :)
I see that you already checked w/ analyzer (I missed that) -
In other words - try without using placeholders - if that ends up working, the DBD might be trying to bind to the wrong SQL type (integer or varchar)
Wow, this is getting messy... as gellyfish mentions, SQL-42000 is a general-purpose error message. However, I still would try it without the bind params in the SQL.
"But what of all those sweet words you spoke in private?"
"Oh that's just what we call pillow talk, baby, that's all."
In Section Seekers of Perl Wisdom