Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid

Re: perl DBI error

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

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!


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?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://445026]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (4)
As of 2023-03-24 19:01 GMT
Find Nodes?
    Voting Booth?
    Which type of climate do you prefer to live in?

    Results (61 votes). Check out past polls.