Skip to Content.
Sympa Menu

freetds - RE: 2000 && 4.2?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: chrisp AT hthk.com
  • To: freetds AT franklin.oit.unc.edu, LowdenJK AT bernstein.com
  • Subject: RE: 2000 && 4.2?
  • Date: Mon, 27 May 2002 12:28:39 +0800


Dear All,

I think you may send the mail to me wrongly. Please check!

Thanks.

Regards,

Chris. Pang
E-mail : chrisp AT hthk.com <mailto:chrisp AT hthk.com>


----------
From: Lowden, James K [SMTP:LowdenJK AT bernstein.com]
Sent: Wednesday, May 22, 2002 4:46 AM
To: TDS Development Group
Subject: [freetds] 2000 && 4.2?

Hi everyone,

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.

Many thanks,

--jkl

---
You are currently subscribed to freetds as: [chrisp AT hthk.com]
To unsubscribe, forward this message to
$subst('Email.Unsub')




Archive powered by MHonArc 2.6.24.

Top of Page