>
> >Have you tried without proxy server?
>
> It works if I don't use the proxy server as long as I bind
> the param and then pass all three variables in $sth->execute().
That's probably because you are binding with SQL_VARCHAR and DBD::ODBC tries
to detect which type the column is and handle the right binding for you.
You may get some better results by setting $dbh->{odbc_default_bind_type} =
12; # SQL_VARCHAR. Then, you shouldn't have to setup the bind ahead...
>
> >Do you have output of what value is actually being bound, on
> both the
> >server side and the client side?
>
> I'm not sure how to get this for the server side. I've tried
> changing the debug level in my config file, but it doesn't
> seem to affect the output when I run dbiproxy with the --debug flag.
At the very least, it may be possible to fix dbiproxy to add a trace of
level 9.
>
> >It looks like the value SQL*Server ends up with is not the
> converting
> >to the number you would expect it to (given the code and the bind).
>
> >Regards,
>
> >Jeff
>
>