Database Administrators
Q&A for database professionals who wish to improve their database skills
Latest Questions
0
votes
1
answers
2303
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 issues. When it came to the Live servers which are HA Availability Groups built on Windows Clustering, t...
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 issues. When it came to the Live servers which are HA Availability Groups built on Windows Clustering, there were no issues... until we ran Failover Cluster Manager, then the cluster went down. Has anyone experienced similar issues? Is anyone aware of this being an issue? I have not seen any documentation from Microsoft, but it is clear from our subsequent testing that removing SQL 2012 Native Client breaks Failover Cluster Manager. SQL is running on 2017 and the OS is Windows Server 2016.
Michael F
(13 rep)
Nov 1, 2022, 01:43 PM
• Last activity: Oct 4, 2024, 01:09 PM
1
votes
1
answers
793
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][1], > A desktop runtime written in C++ with Qt allows it to run standalone > for individual users... I'm expe...
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 standalone
> for individual users...
I'm expecting that a native qt GUI app can be run, and acts as a pg-client, but I can NOT find it out anywhere, neither startting-menu nor the DESTDIR of the installation, i.e /usr/pgadmin4/bin.
There is only one program file /usr/pgadmin4/bin/pgadmin4, but running it still open a browser window to serve as a pg-client, instead of any NATIVE app!
Would anyone please tell me that:
Is the one so called "A desktop runtime written in C++ with Qt" meaning a native GUI client app? or only a management server that resides on the system tray?
If a native GUI client really exists, where to find it or how to start it?
Thanks a lot!
Pls forgive my ugly English.
Leon
(411 rep)
Sep 27, 2020, 01:40 AM
• Last activity: Jan 23, 2024, 11:04 PM
2
votes
1
answers
788
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 are written in PowerBuilder (versions 12.5 and 6.5) and support SQL Server 2005 - 2014 and Express Edi...
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) and support SQL Server 2005 - 2014 and Express Edition - Enterprise Edition.
I read about the KeepAlive property at [Link](https://learn.microsoft.com/en-us/archive/blogs/sql_protocols/understand-special-tcpip-property-keep-alive-in-sql-server-2005) , https://technet.microsoft.com/en-us/library/ms190771(v=sql.120).aspx , and http://www.databaseskill.com/2357386/ . Would this help with this situation?
I also looked at the Microsoft site https://msdn.microsoft.com/en-us/library/ms130822(v=sql.120).aspx which lists all the SQL Native Client connection string properties. I found Failover_Partner, but this is for database mirroring, and I found MultiSubnetFailover, but this is for Always On Availability Groups (AG).
I also looked at http://www.connectionstrings.com/sql-server/ .
Thank you!
Mike Petrak
Mike Petrak
(436 rep)
Oct 13, 2015, 04:03 PM
• Last activity: Oct 15, 2023, 11:32 AM
-1
votes
2
answers
1449
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. 1. Server Type: SQL Server 2. Server Type: Other data source; Microsoft OLE DB Provider for SQL Server 3. Server Type: Other data source; SQL Server Native Client 11.0 4. Server Type: Other data source; Microsoft OLE...
To configure linked server pointing to a SQL server, there are 4 possible options.
1. Server Type: SQL Server
2. Server Type: Other data source; Microsoft OLE DB Provider for SQL Server
3. Server Type: Other data source; SQL Server Native Client 11.0
4. Server Type: Other data source; Microsoft OLE DB Driver for SQL Server
In this question I want to specifically ask when is the recommended to use either of the above in terms of **a) use case**; and **b) deprecated/recommended not to be used**.
variable
(3590 rep)
Oct 22, 2021, 11:30 AM
• Last activity: Oct 22, 2021, 05:14 PM
1
votes
1
answers
591
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 application server to use the new client version? Oledb connection Thanks
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 version? Oledb connection
Thanks
Trevor Coen
(11 rep)
Jan 21, 2021, 09:07 AM
• Last activity: Jan 25, 2021, 04:46 PM
0
votes
1
answers
10131
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).
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
(1 rep)
Sep 17, 2019, 10:41 AM
• Last activity: Dec 6, 2019, 12:07 PM
2
votes
2
answers
17005
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 for connecting, and we need to install the OLE DB driver instead. Is this correct? I have not found mu...
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 driver instead.
Is this correct? I have not found much online other than the Native Client is deprecated and also this article on the lifecycle .
What impact would this have on existing .Net applications and SSIS packages that connect to the database.
Here is a sample connection from an application...
connectionString="metadata=res://*/LoggingModel.csdl|res://*/LoggingModel.ssdl|res://*/LoggingModel.msl;provider=System.Data.SqlClient;provider connection string="data source=myServer;initial catalog=DBLogging;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework"" providerName="System.Data.EntityClient"
Kevin
(533 rep)
Aug 28, 2019, 03:38 PM
• Last activity: Aug 28, 2019, 05:02 PM
4
votes
3
answers
8067
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
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 rep)
Aug 19, 2019, 03:03 PM
• Last activity: Aug 19, 2019, 04:00 PM
0
votes
1
answers
1503
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 - Microsoft SQL Server 2016 LocalDB installed already. ( I noticed that because there was a Microsoft SQL...
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
- Microsoft SQL Server 2016 LocalDB
installed already. ( I noticed that because there was a Microsoft SQL Server folder in Program Files)
Can I just proceed with the installation?
I don't recall having installed SQL server previously so I am not sure why those two are installed in the first place
Also, I would like to have SQL Server management studio installed. Is this a separated install?
KansaiRobot
(123 rep)
May 27, 2019, 04:08 AM
• Last activity: May 27, 2019, 07:35 AM
6
votes
2
answers
4426
views
How do I get the Query Timing with sqlcmd?
Running SQL Server 2017, using the interactive [REPL client `sqlcmd`](https://en.wikipedia.org/wiki/Read%E2%80%93eval%E2%80%93print_loop) how do I get the time for Query Execution? You can [sp_BlitzErik](https://dba.stackexchange.com/users/32281/sp-blitzerik) showing this in [his answer here,](https...
Running SQL Server 2017, using the interactive [REPL client
sqlcmd](https://en.wikipedia.org/wiki/Read%E2%80%93eval%E2%80%93print_loop) how do I get the time for Query Execution?
You can [sp_BlitzErik](https://dba.stackexchange.com/users/32281/sp-blitzerik) showing this in [his answer here,](https://dba.stackexchange.com/a/174093/2639)
SQL Server Execution Times:
CPU time = 1859 ms, elapsed time = 321 ms.
Evan Carroll
(65502 rep)
May 23, 2017, 03:53 AM
• Last activity: Dec 12, 2017, 05:52 PM
0
votes
1
answers
143
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 server with SQL Server Native Client 10.0 ? I saw on multiple forums that they only won't be able to use...
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 server with SQL Server Native Client 10.0 ?
I saw on multiple forums that they only won't be able to use new features of SQL 2012 but they never speak about level of compatibility of databases.
Can someone give me some clarification ?
Thanks a lot!
liotims
(178 rep)
Nov 29, 2017, 09:12 AM
• Last activity: Nov 29, 2017, 09:14 AM
1
votes
1
answers
4876
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 along with Unicode content like `\u3000` ([Ideographic Space][1]). This happens only we are using the...
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 (Ideographic Space ). This happens only we are using the Windows MSSQL Driver and the query is parametrized.
The column is a VARCHAR(MAX). So it should support 2GB.
* What could be the reason for this?
* Why is it that length matters?
If I just insert this Unicode character alone, it won't cause an issue!
I was trying to see this from a theoretical point of view. Switching to NVARCHAR is not an option for us currently, but removing Unicode is.
Here are some more details as per the questions asked by Solomon Rutzky:
1. Column Collation is SQL_Latin1_General_CP1_CI_AS
2. String length where I start seeing the error is 4019.
3. sqlalchemy.connectors.mxodbc, line 86, in error_handler is where I get the initial error. This is from the traceback.
4. It works fine with single Unicode character.
5. A 20000 character string without Unicode works fine.
6. It makes it ASCII from when I try this from this software (Web App). I tested in Dbeaver by exporting the data.
Nishant
(899 rep)
Jul 21, 2017, 02:34 PM
• Last activity: Jul 24, 2017, 02:34 PM
3
votes
1
answers
1144
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 try to configure `SQL Native Client 11.0 Configuration` | `Client Protocols`, there is no opti...
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 Configuration | Client Protocols, there is no option to specify to which instance the setting will be applied. It appears that this is server (machine) level setting that would apply to every instance installed on it.
Am i missing something here? How to allow one protocol, say Named Pipes only for InstanceA and TCP/IP only for InstanceB? (without using aliases, preferably)
Thanks
user99201
Jun 3, 2017, 04:51 AM
• Last activity: Jun 3, 2017, 05:04 AM
2
votes
0
answers
2834
views
SQL Server Native Client ODBC Connection Fails
I am trying to troubleshoot an issue where some clients can connect and others cannot. 1. Server and Database is online, Browser started, Named Pipes & TPC/IP enabled 2. All users use the same SQL Account and Password 3. Connection to database from SSMS works 4. Local firewall rules are from GPO and...
I am trying to troubleshoot an issue where some clients can connect and others cannot.
1. Server and Database is online, Browser started, Named Pipes & TPC/IP enabled
2. All users use the same SQL Account and Password
3. Connection to database from SSMS works
4. Local firewall rules are from GPO and match all clients
5. Instance is configured to allow remote connections
6. Server does not have firewall rule blocking any client IP involved
We create a SQL Server Native Client 11 ODBC connection. On some clients the connection comes back with Success and others come back TESTS FAILED!
The full text of the message is:
Running connectivity tests ...
Attempting connection
[Microsoft][SQL Server Native Client 11.0]Named Pipes
Provider: Could not open a connection to SQL Server .
[Microsoft][SQL Server Native Client 11.0]Login Timeout expired
[Microsoft][SQL Server Native Client 11.0]A network-related
or instance-specific error has occurred while establishing a
connection to SQL Server. Server is not found or not
accessible. Check if instance name is correct and if SQL
Server is configured to allow remote connections. For more
information see SQL Server Books Online.
Any ideas on why some clients are not able to connect?
Michael Heindel
(21 rep)
Mar 1, 2017, 01:53 PM
• Last activity: Mar 1, 2017, 04:18 PM
2
votes
1
answers
2320
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 linked to cells: https://superuser.com/a/758792/164558 My connection string ends up looking like this:...
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: https://superuser.com/a/758792/164558
My connection string ends up looking like this:
DRIVER=SQL Server Native Client 11.0;SERVER=blabla.yadayada.eu-west-1.rds.amazonaws.com;UID=MyUserID;PWD=MrPasswordMan;APP=Microsoft Office 2013;WSID=COMPUTER-NAME;
And this works perfectly on my PC (I have SQL Server installed), I can link to cells with dates and it accepts them as date parameters. However when I try refresh the data in this spreadsheet from other PCs (that do not have SQL Server installed on them), the data won't refresh throwing ODBC errors about default driver's not being specified.
If I change the driver in the connection string to
DRIVER=SQL Server (i.e. drop the native client bit) then it will work on the other PCs. However, it now will only accept text cells for date parameters instead of date cells!
Is there a way to get those SQL Server native client 11.0 drivers installed on the other PCs? Is this something that can be solved via the odbcad32.exe (which I do not know anything about)? Or if not, does anyone know how to get the normal SQL Server driver to accept cells containing dates and not date strings to work as parameters?
Dan
(183 rep)
Aug 5, 2015, 04:26 PM
• Last activity: Feb 2, 2016, 10:07 PM
3
votes
1
answers
7433
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 client has `2011.110.5058.00` (aka `11.00.5058`). I've been around the house on Microsoft websites,...
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 been around the house on Microsoft websites, including MSDN, but I can't find a version more recent than the one I have.
Is there a reliable repository of the different versions of the installer (sqlncli.msi) for testing purposes, or a guide to which versions are bundled with other products?
JV.
(133 rep)
Oct 29, 2015, 11:21 AM
• Last activity: Nov 8, 2015, 06:58 PM
0
votes
1
answers
366
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 conjunction with Instant Client.! Why is that so? If that is the case I would rather install the native Oracle...
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 conjunction with Instant Client.! Why is that so? If that is the case I would rather install the native Oracle client which takes time to install but still end of the day performance matters right? Why should I prefer instant client when there are memory leaks with it?
tesla747
(1910 rep)
Jul 22, 2015, 05:21 PM
• Last activity: Jul 22, 2015, 05:48 PM
1
votes
0
answers
54
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 client' i mean the one in a terminal, command-line, shell or whatever you like to call it. I didn't...
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, shell or whatever you like to call it.
I didn't see an option for it at http://dev.mysql.com/doc/refman/5.6/en/mysql-logging.html and couldn't easily find a solution.
My guess is that it will be hard because it logs to a file ( e.g. ~/.mysql_history), like other shells do (e.g. ~/.bash_history). But I thought it couldn't hurt to ask. Here's to hoping for workarounds, hacks or something like that.
immeëmosol
(111 rep)
Jul 11, 2014, 03:27 PM
0
votes
1
answers
341
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. Is there a way I can preserve this script in edit mode, switch back to the regular mysql mode, run my comma...
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, switch back to the regular mysql mode, run my command, and then come back to edit?
Another example would be: I forget how a column name is spelled and I need to look it up after I've started typing a command in edit mode.
Thanks!
Steve Tauber
(103 rep)
Aug 30, 2013, 08:15 PM
• Last activity: Aug 31, 2013, 04:07 AM
1
votes
1
answers
864
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?
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 rep)
May 31, 2013, 05:52 AM
• Last activity: Jun 4, 2013, 06:29 AM
Showing page 1 of 20 total questions