Questions tagged [native-client]
21 questions
6
votes
2 answers
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 time = 1859 ms, elapsed time = 321 ms.
Evan Carroll
- 65,432
- 50
- 254
- 507
4
votes
3 answers
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
- 213
- 3
- 9
3
votes
1 answer
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 try to configure SQL Native Client 11.0…
user99201
3
votes
1 answer
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 client has 2011.110.5058.00 (aka 11.00.5058). I've…
JV.
- 133
- 1
- 5
2
votes
2 answers
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 for connecting, and we need to install the OLE DB…
Kevin
- 533
- 2
- 12
- 20
2
votes
0 answers
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 Account and Password
Connection to database from SSMS…
Michael Heindel
- 21
- 1
- 3
2
votes
1 answer
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 are written in PowerBuilder (versions 12.5 and 6.5)…
Mike Petrak
- 436
- 6
- 16
2
votes
1 answer
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 linked to cells:…
Dan
- 183
- 13
1
vote
0 answers
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 client' i mean the one in a terminal, command-line,…
immeëmosol
- 111
- 3
1
vote
1 answer
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
- 11
- 1
1
vote
1 answer
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
- 5,393
- 20
- 58
- 65
1
vote
1 answer
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 application server to use the new client…
Trevor Coen
- 11
- 1
1
vote
1 answer
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 runtime written in C++ with Qt allows it to run…
Leon
- 411
- 6
- 15
1
vote
1 answer
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 along with Unicode content like \u3000…
Nishant
- 899
- 2
- 13
- 20
0
votes
1 answer
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. Is there a way I can preserve this script in edit mode,…
Steve Tauber
- 103
- 2