Skip to Content.
Sympa Menu

freetds - RE: [freetds] client support for Yukon (MSSQL 2005)

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Lowden, James K" <LowdenJK AT bernstein.com>
  • To: <ml AT freetds.org>
  • Cc:
  • Subject: RE: [freetds] client support for Yukon (MSSQL 2005)
  • Date: Mon, 14 Feb 2005 15:02:01 -0500

> From: Brian Bruns
> Sent: Friday, February 11, 2005 1:16 PM
>
> Given Microsoft's track record on this (6.5 -> TDS 4.2, 7.0 -> 7.0,
> 2000 -> 8.0) it's not at all surprising that they would bump the
> protocol version. Indeed the only reason they wouldn't is if they
> made no protocol level changes, which is a bit hard to imagine.
>
> The best thing is to dig out ethereal or similar tool, and post the
> trace of a 2005 client -> server session so we can take a look at it.

Interesting reading:

http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx
http://www.microsoft.com/downloads/details.aspx?FamilyID=2adbc1a8-ae5c-4
97d-b584-eab6719300cd&displaylang=en

It might be something *extremely* small, you know, depending on what
"downlevel" means.

Our db-lib masks off the "I'm an ODBC driver bit" in the login packet.
If you delete that line and rebuild, your db-lib connections will
magically gain ODBC treatment. Then maybe maybe the server won't
complain? I'd be interested to hear.

>From what I see in the docs about refactoring the listener service and
combining ODBC and OleDB ("Native Client") and especially this:

"SqlClient Namespace and SQL Native Client: Multiple Active Result Sets
(MARS)

The SQL Server 2005 Database Engine introduces the ability for multiple
statements to return result sets at the same time on the same
connection. Only one statement at a time could actively return result
sets for each connection, no new statements could be executed until all
of the result sets were retrieved."

it sounds like we'll be faced with TDS 9.0.

--jkl

>
>
> On Fri, 11 Feb 2005 12:31:39 -0500, Christos Zoulas
<christos AT zoulas.com> wrote:
> >
> > Hello,
> >
> > Is anyone working on this yet? I tried a bulk-copy to a partitioned
table
> > and got:
> >
> > Msg 4814, Level 16, State 1
> > Server 'XXXXX', Line 1
> > Bulk Copy into a partitioned table is not supported for
downlevel clients.
> >
> > So we are a downlevel client, do you know where to get docs on how
to
> > become an uplevel client? :-)

-----------------------------------------
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.
If you, as the intended recipient of this message, the purpose of which is to
inform and update our clients, prospects and consultants of developments
relating to our services and products, would not like to receive further
e-mail correspondence from the sender, please "reply" to the sender
indicating your wishes. In the U.S.: 1345 Avenue of the Americas, New York,
NY 10105.






Archive powered by MHonArc 2.6.24.

Top of Page