SQL Server Client 11.0 (upgraded from 10.0)

[Rx_]

UPDATED: Once the 32 bit Native Client was located (see instructions below) simply changing 10.0 to 11.0 worked perfectlly!
Access 2010 developed on Windows 7 32 Bit - hosted on Citrix Server Windows 64 bit running Office 32 bit - linked to a SQL Server 2008r2 DB (DSN-Less)

Is the new SQL ODBC Driver 11 the same as SQL Server Native Client 11 ???
On my ODBC, the SQL Server SQl Native Client 10.0 was called Native Client. The SQL version 11 upgrade shows up as ODBC Driver 11 for SQL Server
Access 2010 Programmer that uses linked tables with SQL Server Native Client 10 on the Windows 7 (32 bit) development workstation. Rebooted both server and workstation.
The Windows 7 ODBC Data Source Administrator interface - Drivers show ODBC Driver 11 for SQL Server version 2011.110.2270.00 Can succcessfully connect to SQL Server with the 11 client.

Thought just changing the Native Client 10.0 to Native Client 11.0 would work. No such luck.
Line 50 The code below works perfectlly with Native Client 10.0 - It fails if it is changed to sQL Server Native Client 11.0.
Is there a different driver for SQL Server Native Client - or is there a different connection string?

10    UID = "MyUID"     
20    pwd = "MyPwd"
30    sLocalName = TableName   ' Table name passed in from list into this function
      Dim DataBaseName As String
40    'DataBaseName = "SQLDB"
50    strConnectionString = "ODBC;DRIVER=SQL Server Native Client 10.0;" & _
          "SERVER=mySQLl\myDBInstance;DATABASE=" & DataBaseName & ";" & _
          "UID=" & UID & ";" & _
          "PWD=" & pwd & ";" & _
          "Table=DBO." & sLocalName & ";Option=3;"
60        ModifiedRefreshDNSLess2 = strConnectionString

 

[WayneRyan]

Rx,

Does this help?

http://www.connectionstrings.com/sql-server-2012#sql-server-native-client-11-0-odbc-driver

Wayne

 

[Rx_]

Re: SQL Server Native Client 11.0 (upgraded from 10.0)

You are exactly on target. Tried that and failed. So, I am guessing that Microsoft in its wisdom had failed to provide clear documentation on exactly what driver to download. I will keep looking for the new SQL Native Client 11 download.

WARNING: do not use this site - as shown on the attachment
- Don't use the standard install - look at custom Install
- The standard install add a spam toolbar!!
- Step 4 won't stop even if you close the last step, it continues to run in the Task Manager!
I will leave this attachment so somoen won't accidently click on the hyperlink.

Update: Here is the {see warning} download site. Running from Windows 7 32 bit - the wizard runs from step 1 to 4 - this is step 4 of 4, a blank screen. The memory in Task Manager slightly changes ever few seconds.
Lots of complaints on the Microsoft site about non-existent documentation and wrong documentation.
sigh - will keep searching for a solution.

 

[Rx_]

1. http://www.connectionstrings.com/Providers/sql-server-native-client-11-0-oledb-provider

General Information on SQL Server Native Client 11.0
http://msdn.microsoft.com/en-us/library/ms130892.aspx


Download
OLE DB Provider (SQL Server Native Client 11.0 OLE DB Provider) can be downloaded here (see next step).
(be sure to EXPAND to see the details of each package -
About half way down - see SQL Server Native Client 64 / 32 bit downloads)

2. http://www.microsoft.com/en-us/download/confirmation.aspx?id=29065
This downloads the following Text file:
SQL Server 2012 Feature Pack Instructions:
The links to the SQL Server 2012 Feature Pack components can be found in the “INSTRUCTIONS” section on the SQL Server 2012 Feature Pack page. - The “INSTRUCTIONS” section can be found about half way down the SQL Server 2012 Feature Pack page.
- Once you navigate to the section please be certain to pick the
appropriate component architecture for download.
http://www.microsoft.com/en-us/download/details.aspx?id=29065 - go to Install Instructions and read ... everything. Each is a download.

Scroll about 46% down to Microsoft SQL Server connectivity Feature Pack Components.

Of Interest to this site:
There is new Excel Add In for SQL Server Data Mining (several)
ADO, OLEDB for DB2 (and others) JDBC, Direct stand-alone SQL Server Reporting, and my favorite: Microsoft® SQL Server® Migration Assistant that includes MS Access
http://www.microsoft.com/en-us/download/details.aspx?id=28763

Microsoft SQL Server 2012 Native client
e.g. SqlCmdLnUtils.msi is the 32 bit
http://go.microsoft.com/fwlink/?LinkID=239647&clcid=0x409
The 64bit SQL Server 2012 Native Client 11.0 can be found here:
http://go.microsoft.com/fwlink/?LinkID=239648&clcid=0x409

Microsoft® SQL Server® 2012 Master Data Service Add-in for Microsoft® Excel
Microsoft® SQL Server® 2012 PowerPivot for Microsoft® Excel 2010
Microsoft® SQL Server® 2012 Data Mining Add-ins for Office 2010
Microsoft® SQL Server® Report Builder for Microsoft® SQL Server® 2012 Report Builder provides a productive report-authoring environment for IT professionals and power users. It supports the full operational reporting capabilities of SQL Server 2012 Reporting Services. The download provides a stand-alone installer for Report Builder.

Given my interest in Excel Object Model Programming, will eventually see if the new drivers backward comptibility work with my SQL Server 2008. Why not?

FYI: Because I had found a malware site - check this out as an FYI
http://systemexplorer.net/file-database/file/sqlncli11-dll/7822757
Evidently, this download is difficult to find so it is being exploited -do not accept substitute sites!

The following is from the Microsoft SQL Server 2012 Feature Pack:
MICROSOFT SQL SERVER CONNECTIVITY FEATURE PACK COMPONENTS


Microsoft® SQL Server® 2012 Native Client
Microsoft SQL Server Native Client (SQL Server Native Client) is a single dynamic-link library (DLL) containing both the SQL OLE DB provider and SQL ODBC driver. It contains run-time support for applications using native-code APIs (ODBC, OLE DB and ADO) to connect to Microsoft SQL Server 2005, 2008, 2008 R2, and SQL Server 2012. SQL Server Native Client should be used to create new applications or enhance existing applications that need to take advantage of new SQL Server 2012 features. This redistributable installer for SQL Server Native Client installs the client components needed during run time to take advantage of new SQL Server code name ‘Denali’ features, and optionally installs the header files needed to develop an application that uses the SQL Server Native Client API.

X86 Package (sqlncli.msi)
X64 Package (sqlncli.msi)

 

[Rx_]

For what it is worth, an Access 2010 Front-End using DSN-Less linked tables with SQL Server Native Client 11.0 connectivity works with SQL Server 2008r2.

The Excel Object Model code (OLE) for connectiong to the SQL Server works exactly the same as it did using SQL Server Native Client 10.0

While ODBC for SQL Server comes with Windows 7, the SQL Server Native Client 11.0 must be installed on a workstation. It is free. The Microsoft® SQL Server® Migration Assistant is also free. Anyone designing tables in MS Access that needs to move the tables with all of the parameters to SQL Server will find this tool very useful.

The SQL Server Native Client is not for every situation. For example, if your end user client won't add anything to a workstation. The benefits are worth reviewing.