Help wanted: Program manager for Microsoft SQL Server Native Client team

The SQL Server Native Client team at Microsoft is accepting applications for the position of program manager. For more information about this position, see: http://members.microsoft.com/careers/search/details.aspx?JobID=F9C9E835-AB77-449C-9E6B-732AFD1A7EAB  If you are passionate about ODBC and native data providers, please contact Raghu Ram (raghu.ram@microsoft.com) or Zlatko Michailov (zlatko.michailov@microsoft.com).

1

Accessing SQL Server from open source software

Earlier this week Microsoft release a PHP driver for SQL Server. You can download it from http://www.microsoft.com/downloads/details.aspx?FamilyId=61BF87E0-D031-466B-B09A-6597C21A2E2A&displaylang=en  Documentation is available online at http://msdn.microsoft.com/en-us/library/cc296221.aspx. There is a team blog at http://blogs.msdn.com/sqlphp/ and a community forum at http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=2108&SiteID=1 The SQL Server Driver for PHP represents a new way for Microsoft to help developers access SQL Server from non-Microsoft…

1

Tips for improving application robustness and minimizing upgrade upheaval

In general we recommend against configuring a deployed application to use a new version of SQL Native Client (SNAC) unless the application developer has certified that the application has been tested with the version of SNAC in question. This is because we don’t know how well applications will behave when they encounter differences between a…

1

SQL Server 2008 Native Client now available for download

Microsoft SQL Server 2008 Feature Pack RC0, June 2008 is now available for download from  http://go.microsoft.com/fwlink/?LinkId=110393  This includes the standalone installer for SQL Server 2008 Native Client (SNAC10). The Feature Pack also includes a Command Line Utilities installer which enables installation of sqlcmd and bcp on client systems.

7

sqlncli.msi for SQL Server 2008

In SQL Server 2008, the x64 and Itanium versions of sqlncli.msi will install the 64-bit and 32-bit versions of SQL Server Native Client.  The x86 version of sqlncli.msi will only work on 32-bit Windows operating systems and will install the 32-bit version of SQL Server Native Client.  You will not be able to run the 32-bit…


ADO: Deriving parameter information for user-defined, table-valued functions

(The content of this entry was developed by Anton Klimov, a software engineer on the SQL Server Native Client team.)  Table-valued, user-defined functions (TVF) can be used as an alternative to views or stored procedures. (http://technet.microsoft.com/en-us/library/ms191165.aspx) There is a problem, however, with the existing support for obtaining parameter information from classic (VB script) ADO code — if…


Getting SQL Server 2005 hot fixes

The SQL Server Customer Service and Support (CSS) group developed a new a more efficient way for you to get SQL Server 2005 hot fixes.  For more information on hot fixes and cumulative updates, see http://blogs.msdn.com/psssql/archive/2008/04/25/sql-server-2005-sp3-and-self-service-hotfixes.aspx.

0

SQL Server Native Client header file (sqlncli.h) does not install by default in CTP6

The setup for CTP6 of SQL Server 2008 does not install sqlncli.h in the SDK\Include directory.  This is a bug in the CTP6 setup.  To get sqlncli.h in the SDK\Include directory, you need to invoke Setup\sqlncli.msi from the directory where you ran setup.exe and when prompted, select Modify.  Then, specify that you want the sqlncli.h and…

0

Microsoft SQL Server Native Client and Microsoft SQL Server 2008 Native Client

Microsoft SQL Server Native Client (referred to hereafter as SNAC) was introduced in SQL Server 2005 and combines an ODBC driver and OLE DB provider in a single DLL. The SQL Server ODBC driver and SQL Server OLE DB provider for earlier versions of SQL Server was delivered via Microsoft Data Access Components (MDAC), recently…

3

Sending BLOB Data to SQL SERVER Using IROWSETFASTLOAD and ISEQUENTIALSTREAM

Steve Hale SQL Server Native Client Development Team Microsoft Corporation Recently there have been several requests for samples showing how to use IRowsetFastLoad to send varying BLOB data per row or how to stream data to SQL Server via SQLOLEDB or SQLNCLI.  Most of the available samples are too simplistic and don’t demonstrate varying data…

3