[freetds] Problem with stored proc and varchar parameters
ZIGLIO, Frediano, VF-IT
Frediano.Ziglio at vodafone.com
Fri Jul 14 04:51:11 EDT 2006
> bflood at tethermedia.com wrote:
> > Hi,
> > I am new to freetds. I just downloaded stable version
> (0.64) yesterday and
> > have a simple ODBC app that I am trying to get working on linux
> > (connecting to SQL Server on a windows box). I have a
> stored proc that
> > takes a varchar (basically a string of up to 10 chars).
> However when I
> > execute it no character data gets sent across the wire. If
> I change the
> > proc to take an INTEGER then it works (and I see the parm
> value in the TDS
> > stream).
> Try version 0.63
> I had the same problem with 0.64, going back to 0.63 solved
> the problem.
> Perhaps also read this: http://kb.vankoperen.nl/freetds-problems.html
> Good luck.
please do not mix dblib with ODBC, mssql PHP extension use dblib which
is very different.
Some time ago I wrote this test
pc2.php that is very similar to your tests. Currently it works with both
CVS 0.64 (updated) and CVS HEAD. You can find a patch post 0.64 at
http://freetds.sourceforge.net/. I hope this will fix your problem.
More information about the FreeTDS