2000 && 4.2?
Lowden, James K
LowdenJK at bernstein.com
Tue May 21 18:22:24 EDT 2002
> From: Michael Peppler [mailto:mpeppler at peppler.org]
> Sent: May 21, 2002 4:59 PM
>
> On Tue, 2002-05-21 at 13:45, Lowden, James K wrote:
> > 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?
>
> AFAIK this is correct. However, DBlib apps may still work.
Why would db-lib apps work? I thought it was a TDS issue. Possibly having
to do with dropping ascii support at the protocol level (in favor of UCS-2).
> > 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.
>
> Well - bcp is not transactional (or at least not really), and doesn't
> support host variables (at least not if I understand what you mean by
> that).
I see. You're saying bcp is "not transactional" because the data don't hit
the tranlog, so there's no rollback/rollforward and such for recovery and
backup. I should have said "bcp has to support batches".
Right now, FreeTDS writes the whole file as one batch. If there's a glitch
in the data, the batch is not committed, and in fact "sp_who" will show the
spid's status as "rollback". In such a case, process will remained blocked
for an inordinately long time, much longer than it took to upload the rows.
So, we need bcp batch support. :)
By "host variables", I mean feeding the bcp API with bound memory variables,
rather than from a file. You know, bcp_bind, bcp_sendrow, and friends.
Thanks for the reply, Michael. Your name came up, you won't be surprised to
hear.
--jkl
More information about the FreeTDS
mailing list