Questions tagged [native-client]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
1k views

Is anyone aware of issues where uninstalling SQL 2012 Native Client has broken Failover Clustering?

We were recently asked to remove unsupported software from our servers and the list included SQL 2012 Native Client. Version 11 was installed, so we removed it from test & dev servers without any ...
Michael F's user avatar
-1 votes
2 answers
948 views

Linked server - When is it recommended to use SQL Server or the 4 Other data sources for SQL Server?

To configure linked server pointing to a SQL server, there are 4 possible options. Server Type: SQL Server Server Type: Other data source; Microsoft OLE DB Provider for SQL Server Server Type: ...
variable's user avatar
  • 3,593
1 vote
1 answer
463 views

SQL Native Client Upgrade

Application server for CRM has SQL native client 2008 version installed. I have installed SQL native client 2012 side by side as need to connect to an sql availability group listener. How do I get the ...
Trevor Coen's user avatar
1 vote
1 answer
1k views

How to troubleshoot "Encryption not supported on the client OLE DB provider "SQLNCLI11" for linked server" error

We are using LocalDb for integration/unit testing of a .NET Core application. I have been using this solution for months and recently started getting sporadic errors. It seems to happen the first time ...
Dude0001's user avatar
  • 111
0 votes
1 answer
617 views

Is there a native(none-web) GUI client of pgadmin4?

I don't like web-based GUI, so I only installed the pgadmin4-desktop package for my Kubuntu 20.04, instead of pgadmin4-web and pgadmin4. According to the offical web page of pgAdmin4, A desktop ...
Leon's user avatar
  • 347
0 votes
1 answer
8k views

Where to find the installer for SQL Server Native Client 11.0.7462?

I would like the exact version mentioned since my application does not support the 11.0.5058 version of the SQL Server Native Client (sqlncli).
user191110's user avatar
2 votes
2 answers
16k views

SQL Native Client 11 - SQL Server 2017

We currently connect to SQL Server 2014 with the Native Client without any issues. However, the SQL Server is being upgraded to SQL 2017. I have been told that SQL Native Client will no longer work ...
Kevin's user avatar
  • 533
4 votes
3 answers
7k views

What is the latest version of SQL Server native client that is compatible with Sql Server 2008 r2

Title says it all, what is the most recent version of Sql Server native client that is compatible with Sql Server 2008 R2
KySoto's user avatar
  • 213
0 votes
1 answer
1k views

Install SQL Server 2017 over 2016 Local DB and 2012 native client

I have downloaded Microsoft SQL Sever 2017 and would like to install it. But just to be sure I checked installed applications and I found that there is: Microsoft SQL Server 2012 native client ...
KansaiRobot's user avatar
0 votes
1 answer
126 views

SQL Server 2012 (compability level 110) and SQL Server Native Client 10

I've upgraded my SQL Server 2008R2 to SQL 2012. I will set the compability level to 110 (2012) to all databases. But I'm wondering if it will create some problems for clients that connect to this ...
liotims's user avatar
  • 178
1 vote
1 answer
4k views

Saving into a VARCHAR(MAX) throwing error in some scenarios

We are noticing an error like this: InterfaceError: ('HY104', 0, '[Microsoft][SQL Server Native Client 11.0] Invalid precision value', 10226) It happens when we insert a certain length of characters ...
Nishant's user avatar
  • 859
3 votes
1 answer
1k views

Sql Server Configuration Manager

I have two SQL Server named instances, InstanceA and InstanceB on one computer, and they correctly show up under Sql Server Configuration Manager | SQL Server Network Configuration. However, when I ...
user avatar
6 votes
2 answers
4k views

How do I get the Query Timing with sqlcmd?

Running SQL Server 2017, using the interactive REPL client sqlcmd how do I get the time for Query Execution? You can sp_BlitzErik showing this in his answer here, SQL Server Execution Times: CPU ...
Evan Carroll's user avatar
  • 62.9k
2 votes
0 answers
3k views

SQL Server Native Client ODBC Connection Fails

I am trying to troubleshoot an issue where some clients can connect and others cannot. Server and Database is online, Browser started, Named Pipes & TPC/IP enabled All users use the same SQL ...
Michael Heindel's user avatar
3 votes
1 answer
7k views

Where to find the installer for SQL Server Native Client 11.0.5058?

I am trying to track down some behaviour issues in our software which seem to dependent on the version of SQL Server Native Client in use. I have version 2011.110.2100.60 (aka 11.00.2100) but our ...
JV.'s user avatar
  • 133
2 votes
1 answer
757 views

SQL Native Client and network disconnects

Does the SQL Native Client provide support for maintaining a persistent connection over the network at the driver level if there is a momentary network disconnect like a 999 error? Our applications ...
Mike Petrak's user avatar
2 votes
1 answer
2k views

Query SQL Server from Excel with parameters linked to cells

I have a bunch of Excel spreadsheet that have data connections to a SQL Server DB (Hosted by AWS RDS) and I follow exactly this procedure to get those connections up and running with the parameters ...
Dan's user avatar
  • 183
0 votes
1 answer
331 views

Oracle instant client memory footprint

In the link mentioned here --> http://www.oracle.com/technetwork/database/features/oci/ic-faq-094177.html it says there is increased virtual memory footprint when running my applications in ...
tesla747's user avatar
  • 1,886
1 vote
0 answers
48 views

How could I prevent the mysql cli-/terminal client from converting/altering multiline-statements (in the process of logging)?

Is there a way to prevent the default mysql client from ?: 'removing newlines' a.k.a. 'converting newlines to spaces' a.k.a. 'mapping newlines to spaces' Being more specific, with 'default mysql ...
immeëmosol's user avatar
0 votes
1 answer
334 views

Lookup data while in mysql cli edit mode (external editor) (\e)

I'm using the mysql cli in edit mode (\e). > Select * from \e Goes to vim and I finish typing my command. Select * from test_table; Only to realize I've forgotten to use the database I need. ...
Steve Tauber's user avatar
1 vote
1 answer
853 views

Sql Server 2012 and native client 10

What is the difference between SQL Server Native client versions 10 and 11? Can I use Native Client 10 with SQL Server 2012 running?
arnabius's user avatar
1 vote
1 answer
206 views

Is it possible to use Native Clients from previous releases to connect SQL Server 2012?

Is it possible to use SQL Server Native Clients from previous SQL Server releases (e.g. SQL Server 2008 R2 Natice Client) to connect SQL Server 2012 database?
jrara's user avatar
  • 5,333