Skip to Content.
Sympa Menu

freetds - RE: [freetds] ODBC RPC

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Rogers, Tom" <tom.rogers AT ccur.com>
  • To: 'FreeTDS Development Group' <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] ODBC RPC
  • Date: Thu, 24 Jul 2003 10:16:38 -0400

Can you tell me exactly the flag and where to put it to build a version of
TDS with the enable-developing flag set?

THANKS.

Thomas Rogers
System Engineer
Concurrent Computer Corporation
phone: 215.712.7422 x7261
mailto:tomr AT ccur.com

-----Original Message-----
From: ZIGLIO Frediano [mailto:Frediano.Ziglio AT vodafone.com]
Sent: Thursday, July 24, 2003 8:38 AM
To: FreeTDS Development Group
Subject: RE: [freetds] ODBC RPC

>
> Attached is a sample CPP file that has a main that uses
> UnixODBC and FreeTDS. In the comments of the CPP file you
> will find a stored procedure declaration. I created the
> stored procedure in the Northwinds database of a MS SQL 7.0
> server and tested from there.
>
....
>
> <<tdstest.cpp>>
> I hope this is enough to reproduce the problem. Also if
> interest is that if the @OutString varchar input parameter
> isn't set to some non-blank string, the SQLExecute call
> returns SQL_ERROR. This is not the behavior I would expect
> when dealing with an OUTPUT only parameter (or an in/out or
> even in parameter for that matter). I have had other
> problems with empty strings with TDS. Comments on that would
> be helpful as well.
>
> Thomas Rogers

I added your program (modified) to ODBC unittests.
First time I tried it it succeed (I tested also returned values).
After a while I realize that I was using --enable-developing configure
flag.
This flag mainly enable a new version of SQLExecute that improve
performance but have still some problem. I fixed some of them but others
remain:
- Sybase isn't unable to use dynamic statement using text/image fields
(you have to build language text or use TDS_LANGUAGE with parameters,
still not implemented)
- SQLPutData do not work (SQLExecute return SQL_ERROR instead of
SQL_NEED_DATA)
- TDS 4.2 is not supported (well, this is not a big problem, I hope
nobody use this version..)

There are already unittests for both cases (bynary_test and putdata) so
I hope to fix them ASAP.

freddy77
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds




Archive powered by MHonArc 2.6.24.

Top of Page