freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] Problem with stored proc and varchar parameters

From: Ellert van Koperen <ellert AT vankoperen.nl>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] Problem with stored proc and varchar parameters
Date: Thu, 13 Jul 2006 19:28:15 +0200

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.

--
+-----------------------------------------+
| Ellert van Koperen, Concepts developer |
+-----------------------------------------+
| AIR: +31 (0)6 55131866 |
| POST: Gerardsweg 70, 6525RT, Nijmegen |
+-----------------------------------------+

[freetds] Problem with stored proc and varchar parameters, bflood, 07/13/2006
- Re: [freetds] Problem with stored proc and varchar parameters, Ellert van Koperen, 07/13/2006
  - Re: [freetds] Problem with stored proc and varchar parameters, bflood, 07/13/2006
- <Possible follow-up(s)>
- Re: [freetds] Problem with stored proc and varchar parameters, Lowden, James K, 07/13/2006
  - Re: [freetds] Problem with stored proc and varchar parameters, bflood, 07/13/2006
- Re: [freetds] Problem with stored proc and varchar parameters, ZIGLIO, Frediano, VF-IT, 07/14/2006
  - [freetds] [Store Procedure Names] roll-over problem, Wolfgang Gruen, 07/14/2006
  - Re: [freetds] Problem with stored proc and varchar parameters, Ellert van Koperen, 07/17/2006
- Re: [freetds] Problem with stored proc and varchar parameters, ZIGLIO, Frediano, VF-IT, 07/17/2006