Skip to Content.
Sympa Menu

freetds - RE: [freetds] Function sequence error from Linux => SQL Server 2000

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Charles Bearden" <Charles.F.Bearden AT uth.tmc.edu>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Function sequence error from Linux => SQL Server 2000
  • Date: Wed, 28 Apr 2004 16:26:08 -0500

> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org [mailto:freetds-
> bounces AT lists.ibiblio.org] On Behalf Of Charles Bearden
>
> > -----Original Message-----
> > From: freetds-bounces AT lists.ibiblio.org [mailto:freetds-
> > bounces AT lists.ibiblio.org] On Behalf Of Lowden, James K
> >
> > > From: Charles Bearden [mailto:Charles.F.Bearden AT uth.tmc.edu]
> > > Sent: April 28, 2004 12:41 PM
> > >
> > > When I try to
> > > load a chunk of Unicode into an ntext field in some records,
> > > the program
> > > raises an exception due to a "function sequence error".
> > >
> > > I have built and installed the following:
> > >
> > > mxBase-2.0.5
> > > mxCommercial-2.0.6
> > > libiodbc-3.51.2
> > > freetds-0.62.3
> >
> > Hi Charles,
> >
> > I'm unfamiliar with mxBase and know Python only from a distance. I
> offer
> > mere speculation.
>
> Many thanks for your response. I am interested in getting this setup
to
> work, and if in the process an issue with FreeTDS is discovered and
> documented or a bug found and squashed, and I learn something, so much
> the better!

Two final clues:
(1) If I use the Python interpreter to instantiate my DB connection and
call the stored procedure with the same XML data, it loads the data into
the target table with no complaint.
(2) In my script I create six or seven different connections to the
database, each with its own cursor, so that each cursor executes only
one thing on the SQL server. My hope was to reduce overhead by
permitting each cursor to prepare just one statement. Now that the
cursors are executing stored procedures rather than SQL statements,
perhaps I should use only one connection and cursor.

Chuck

Chuck Bearden
Systems Analyst III
School of Health Information Sciences
University of Texas at Houston
713.500.3954 (voice)
713.500.3907 (fax)
Charles.F.Bearden AT uth.tmc.edu





Archive powered by MHonArc 2.6.24.

Top of Page