Skip to Content.
Sympa Menu

freetds - RE: 2000 && 4.2?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Daniel Morgan" <danmorg AT sc.rr.com>
  • To: "'TDS Development Group'" <freetds AT franklin.metalab.unc.edu>
  • Subject: RE: 2000 && 4.2?
  • Date: Tue, 21 May 2002 17:29:25 -0400


What is "bcp"?

As for transaction support, executing SQL commands "BEGIN" and then
"ROLLBACK" or "COMMIT" isn't enough?

What about using XML? The SQLXML stuff in MS SQL Server 2000 follows
the W3C recommendations, so it should be no problem to generate it from
Unix.
However, you did say high-volume, so this may not be good idea since the
XML would make the data even more huge.

-----Original Message-----
From: bounce-freetds-143938 AT franklin.metalab.unc.edu
[mailto:bounce-freetds-143938 AT franklin.metalab.unc.edu] On Behalf Of
Lowden, James K
Sent: Tuesday, May 21, 2002 4:46 PM
To: TDS Development Group
Subject: [freetds] 2000 && 4.2?

I just left a meeting where I was told that there was "no way" to
connect
our Solaris (or might be Digital Unix) box to MS SQL Server 2000. It
was
news to me. ;)

After some questioning, I think the speaker meant that Sybase's ct-lib
can't
connect to 2000. The assertion is that MS SQL Server 2000 has no
support
for 4.2 (or, of course 5.0) connections. Is that in fact true? Can
Sybase's Solaris ct-lib client connect to MS SQL Server 2000, or not?

We currently use Sybperl, DBD::Sybase, and some home-grown C programs,
all
linked to Sybase ct-lib, to connect to our Sybase and SQL Server 7.0
servers. It works OK if we avoid some things, like decimal/numeric
datatypes.

We are testing something called DirectConnect, which by rights should be
called IndirectConnect. It's an OpenServer gateway that runs on NT, I'm
told. It lacks bcp support, without which it's about as useful to me as
day-old bread.

If you were trying to do high-volume robust bcp loads from a Unix host
to a
MS 2000 database, what would you use? (Anyone who says "Oracle" is
asking
for trouble!)

FreeTDS is a possibility, but its bcp logic would have to be amplified
to
include host variable and transaction support. If you think it's
really
the best answer, though, that's information, too.






Archive powered by MHonArc 2.6.24.

Top of Page