Good question. We were told by MS that ODBC is going away and Native
Client is what they want us to use.

They don't even make a 64bit ODBC driver which caused us many issues for
some of our linkservers(especially Sybase). Can't even find one that
works from a 3rd party vendor.



Thanks,
Ralph W. Davis
*********************************************************
*** CORPORATE DBA group - Houston ***
*********************************************************

-----Original Message-----
From: Sheldon Jeff
[mailto:mssqldba-ezmlmshield-x56108300.[Email address protected]
Sent: Monday, January 29, 2007 10:24 AM
To: LazyDBA Discussion
Subject: ODBC driver for 2005

Quick question, for those that installed SQL Client Tools for 2005 on a
workstation, when you do an ODBC connection (Control Panel/
Administration Tools) there are two for SQL server.



SQL Native Client which has a version of 2005-xxx

SQL Server which has a version of 2000-xxx



If you launch SQL Native Client its splash screen is SQL 2005 but the
connectivity doesn't appear the same as the SQL Server Driver.



1. What is Native Client used for?

2. Did SQL 2005 to anyone's knowledge update the SQLSRV32.DLL for
ODBC connectivity?



Thanks have an ERP migration problem and trying to narrow down if it is
the vendor or our connectivity.



Jeff





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
****************************************************************
Confidentiality Note: The information contained in this
message, and any attachments, may contain confidential
and/or privileged material. It is intended solely for the
person(s) or entity to which it is addressed. Any review,
retransmission, dissemination, or taking of any action in
reliance upon this information by persons or entities other
than the intended recipient(s) is prohibited. If you received
this in error, please contact the sender and delete the
material from any computer.
****************************************************************

MS Sql Server LazyDBA home page