Stack Overflow
Stack Overflow

Questions tagged [sql-server-native-client]

58 questions
2
votes
0 answers

Why are the ODBC queries from my desktop is blocked by the sql server after running several queries in rapid succession?

I usually create queries using Visual Foxpro 9.0 from a desktop computer to a MS SQL Server 2005 running on Windows Enterprise Server (2003). My queries are repetitive and sometimes, one session would query the SQL server 200,000 times in rapid…
Jojo del Rosario
  • 21
  • 3
1
vote
1 answer

What is the methodology for using SQL Native Client Transparent Client Redirect and mirroring?

I've never used mirroring, clustering or other failover techniques. But am investigating how easy it is to adapt my DAL so that SQLNativeClient transparent client redirect will work for us if my customers decide to use mirroring with or without a…
GilesDMiddleton
  • 2,279
  • 22
  • 31
1
vote
1 answer

When is it safe to uninstall SQL Server Native Client programmatically?

How do you determine when it is safe to uninstall the 'SQL Server Native Client'? I believe that simply checking whether there is an SQL Server instance installed is naive. I've tried researching and testing the behavior of the following keys, among…
jasnmoore
  • 13
  • 1
  • 4
1
vote
1 answer

Is there a best practice on how to connect to a SQL Server database from a 2-tier application?

I'm developing a desktop client application in wpf and I want to put my database which I currently have in Access on our SQL Server instance. I don't think it's a good idea to use windows authentication, because then every user should be added to…
Arne W
  • 53
  • 6
1
vote
1 answer

SQL Native Client, linked server error Only on Deletes

We are using a SQL Native Client to connect to a local SQL Server 2005 from a Borland application. It will fine for selects, inserts, and updates. When we delete we get the error: Could not find server SERVERNAME\SQLEXPRESS in sys.servers.…
Anthony D
  • 10,877
  • 11
  • 46
  • 67
1
vote
1 answer

SQL Server 2008 Native Client issue

We have two virtual machines on a server. We have Sql server installed on one vm and on another vm sybase is installed. We can't find "SQL Server 2008 Native Client" driver on the machine where we have intalled sybase. We have tried to install it…
Kavita Nemad
  • 13
  • 2
1
vote
1 answer

Why is my Access 2013 ODBC SQL Server Data Source failing after a few minutes?

I am using Access 2013, with forms. There are inked tables from an Azure SQL Server 12.0 database. The tables are linked with an ODBC Data Source using the "SQL Server Native Client 11.0" driver. I saved the "SQL Server Authentication" password when…
Christopher Page
  • 19
  • 6
1
vote
1 answer

Client Protocols and Alias missing on sql native

No Client Protocols or Alias has anything under. Please see attached pic.
user21729897
  • 11
  • 2
1
vote
1 answer

Notifying Excel 2007 about changes in a database in SQL Server 2008 R2

I have a lot of trouble using Excel 2007 together with SQL server 2008 R2. I need to share data between two or more workbooks, and I want to do this through a SQL database (placed in SQL Server 2008 R2) on a remote server. I use VBA with ADO and…
Lulz
  • 11
  • 1
1
vote
0 answers

Error 80040e21 and DBBINDSTATUS_BADBINDINFO during bind after switching from SQLOLEDB to SQLNCLI or MSOLEDBSQL provider

I'm working on some legacy C++ code that uses OLE DB to connect to a SQL Server database. I need to move from the old SQLOLEDB provider to a more modern one (SQLNCLI, SQLNCLI10, SQLNCLI11, or MSOLEDBSQL). Suposedly, this should be possible by just…
the klaus
  • 81
  • 2
  • 5
1
vote
0 answers

TSQL datetime versus datetime2 compatibility issue and the Native Client 11.0

The following code failed when we had to switch to the SQL Server Native Client 11.0 driver (so that we could upgrade our TLS to 1.2): convert(varchar(15),getdate()+cast(1 as datetime),10) The error was: Microsoft SQL Server Native Client 11.0 :…
fthurber
  • 11
  • 1
1
vote
0 answers

Does SQL Native Client come with SQL Server 2014 LocalDB?

Does the SQL Server Native Client come with SQL Server 2014 LocalDB? It is unclear due to https://msdn.microsoft.com/en-us/library/hh510202.aspx and https://msdn.microsoft.com/en-us/library/cc280510.aspx... Do we have install it separately and if…
NoWar
  • 36,338
  • 80
  • 323
  • 498
1
vote
2 answers

SQL Native client interface error 8058 when using table-valued parameter, cannot diagnose cause

I've written a function which sends data to a T-SQL stored procedure using table valued parameters. Its the first time I did this and I got stuck by this Error: The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is…
antipattern
  • 743
  • 1
  • 9
  • 20
1
vote
0 answers

SQLDescribeParams function call - SQL Server Native Client 11.0 driver fails with “Invalid object name”

I want to create a temporary table on SQL Server 2012 and insert into it in bulk. I don't always know the type of parameters that the temp table will be created with, so I need to invoke SQLDescribeParam so that I can bind the parameters. I am using…
user2237963
  • 103
  • 7
1
vote
0 answers

Couldn't insert record with text fields with a lengh of more than 257 characters via pyodbc

I have a SQL server which version is 10.50.4000. I connect to it from linux via pyodbc with SQL server Native Client 11.0 driver. Here is the table definition. SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE…
belcon
  • 11
  • 1
  • 2
1
2
3 4