Beefy Boxes and Bandwidth Generously Provided by pair Networks RobOMonk
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: perl DBI error

by RazorbladeBidet (Friar)
on Apr 05, 2005 at 12:13 UTC ( [id://445026]=note: print w/replies, xml ) Need Help??

This is an archived low-energy page for bots and other anonmyous visitors. Please sign up if you are a human and want to interact.


in reply to perl DBI error

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.

P.S. please use some formatting in your post - thanks!

Update:

Post formatted :)

I see that you already checked w/ analyzer (I missed that) - but a quick search turned up this - which mentions the use of SQL_INTEGER vs. SQL_VARCHAR hints... might apply to your situation?

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)

Update II:

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."

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://445026]
help
Sections?
Information?
Find Nodes?
Leftovers?
    Notices?
    hippoepoptai's answer Re: how do I set a cookie and redirect was blessed by hippo!
    erzuuliAnonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.