Skip to Content.
Sympa Menu

freetds - RE: [freetds] ct-lib Documentation

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Thompson, Bill D (London)" <ThompBil AT exchange.uk.ml.com>
  • To: "'freetds AT lists.ibiblio.org'" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] ct-lib Documentation
  • Date: Fri, 13 Dec 2002 16:28:50 -0000

In the past, I've gotten bus errors in tds on Solaris, when compiled with
gcc .
I never got to the bottom of them...

using the SUN C compilers, I've gotten round the problem using "cc
-misalign"

Don't know if there's similar option with HP-UX C compilers

Bill

> -----Original Message-----
> From: Lowden, James K [SMTP:LowdenJK AT bernstein.com]
> Sent: 13 December 2002 16:13
> To: 'freetds AT lists.ibiblio.org'
> Subject: RE: [freetds] ct-lib Documentation
>
> > From: Harrison, Bruce (CXO) [mailto:Bruce.Harrison AT hp.com]
> > Sent: December 13, 2002 10:53 AM
> >
> > >You would not have liked doing this in tds. Also, particularly for
> > >something simple like this, I think you'll find db-lib easy to grasp.
> >
> > Actually I had it working on Linux (using the tds library), with the
> > build (non-snapshot) that I pulled on Nov. 22. The SQL query
> > that I was sending (and its output) is as follows:
> >
> > declare @case_id varchar(15)
> > declare @case_status varchar(7)
> > exec test_feeder 'Cleared','LEG','test_node','CIM:test','Add. Text
> > Here','harrison',@case_id output,@case_status out
> > select @case_id AS 'Case Id', @case_status AS 'Case Status'
> > Case Id Case Status
> > 036361-120402 Updated
>
> Bruce,
>
> I see. I took you literally when you said, "getting a single row
> (actually
> two output variables)". Your example above is really 2 queries: "exec
> test_feeder..." and "select @case_id...". The latter returns an ordinary
> result set. Nothing tricky about that, all the APIs can do it.
>
> > It sounds as if db-lib is the API that I should be using
> > rather than the ct-lib API????
>
> No. db-lib has the rpc functions that let you read the output parameters
> without a subseqent select statement, but you don't need that feature.
> (Although you use it, if you wanted to.) ct-lib will do you fine. As you
> like. You might want to look in src/ctlib/unittests for examples.
>
> Any luck on the bus error? I live in New York, where there's talk of a
> transit strike. That would be a bus error of another order.
>
> Regards,
>
> --jkl
>
>
>
>
> The information contained in this transmission may contain privileged and
> confidential information and is intended only for the use of the person(s)
> named above. If you are not the intended recipient, or an employee or
> agent
> responsible for delivering this message to the intended recipient, any
> review, dissemination, distribution or duplication of this communication
> is
> strictly prohibited. If you are not the intended recipient, please contact
> the sender immediately by reply e-mail and destroy all copies of the
> original message. Please note that we do not accept account orders and/or
> instructions by e-mail, and therefore will not be responsible for carrying
> out such orders and/or instructions.
>
>
> _______________________________________________
> 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