Stack Overflow
Stack Overflow

Questions tagged [sqlncli]

37 questions
46
votes
10 answers

Need a row count after SELECT statement: what's the optimal SQL approach?

I'm trying to select a column from a single table (no joins) and I need the count of the number of rows, ideally before I begin retrieving the rows. I have come to two approaches that provide the information I need. Approach 1: SELECT COUNT(…
antik
  • 5,282
  • 1
  • 34
  • 47
10
votes
5 answers

The 'SQLNCLI' provider is not registered on the local machine, sql server 2012

Working on deploying an application from my development box to a client. On the client when I run my exe, I get the error "The 'SQLNCLI10' Provider is not registered on the local machine. I'm developing in SQL Server 2012. I have tried installing…
tuj
  • 575
  • 2
  • 9
  • 25
6
votes
8 answers

Delphi with SQL Server: OLEDB vs. Native Client drivers

I have been told that SQL Native Client is supposed to be faster than the OLEDB drivers. So I put together a utility to do a load-test between the two - and am getting mixed results. Sometimes one is faster, sometimes the other is, no matter what…
Jerry Dodge
  • 26,858
  • 31
  • 155
  • 327
6
votes
1 answer

SQL native client data type compatibility - incompatible with SQLOLEDB

We have ran into a problem with our legacy application when switching to use SQL Native Client (SQLNCLI) as the provider for ADO. Our original connection string was: Provider=SQLOLEDB; Server=host; Database=bob; Integrated Security=SSPI; we changed…
Chris J
  • 30,688
  • 6
  • 69
  • 111
4
votes
1 answer

SQLGetData issues using C++ and SQL Native Client

I have a C++ application that uses SQL Native Client to connect to a MS SQL Server 2000. I am trying to retrieve a result from a TEXT column containing more data than the buffer initially allocated to it provides. To clarify my issue, I'll outline…
antik
  • 5,282
  • 1
  • 34
  • 47
4
votes
2 answers

How to check if a client has SQLNCLI10 provider installed when browsing?

I have a c# website that allows a client to connect directly to a remote SQL Server database from their PC, bypassing the web server, by using a 3rd party ActiveX control. I was originally using the SQLOLEDB provider and it was working fine. The…
JumpingJezza
  • 5,498
  • 11
  • 67
  • 106
4
votes
3 answers

SQL Native Client ODBC application not disconnecting after SQLDisconnect and not pooling?

Background: I'm working with a program coded in C++ which uses ODBC on SQL Native Client to establish connections to interact with a SQL Server 2000 database. Problem: My connections are abstracted into an object which opens a connection when the…
antik
  • 5,282
  • 1
  • 34
  • 47
4
votes
1 answer

Dead-lock created by 2 SQL connections, each using transactions, different tables, foreign key constraint between the two tables

Environment I'm working on a C++ application that uses SQL Native Client 9.0 to communicate with a SQL Server 2000 database. Scenario 2 connections are opened to the DBMS Each connection is set to use transactions A query on Connection1 works with…
antik
  • 5,282
  • 1
  • 34
  • 47
4
votes
4 answers

Linked servers SQLNCLI problem. "No transaction is active"

Im trying to execute a stored procedure and simply insert its results in a temporary table, and I'm getting the following message: The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "MyServerName" was unable…
Smur
  • 3,075
  • 7
  • 28
  • 46
4
votes
4 answers

Failure to connect to SQl Server from Linux

I am trying to connect to SQL Server 2008 on CentOS 5.8. I am using unixODBC 2.3.0 and SQL Server ODBC Driver (www.microsoft.com/en-us/download/details.aspx?id=28160). When I try to test the connection by running: isql -v mydsn username password it…
kirylm
  • 101
  • 1
  • 1
  • 8
2
votes
1 answer

SQLNCLI11 provider has the error of The fractional part of the provided time value overflows

I have the following connection string: provider=SQLNCLI11;Server=[server];Database=[db];uid=[uid];pwd=[pwd] and I have the following code: OleDbCommand oComm = new OleDbCommand(); oComm.Connection = OleConnection; …
Lys
  • 591
  • 2
  • 9
  • 19
2
votes
2 answers

Upgrading to SQL Server 2005: Cannot INSERT QNAN into float column?

Background: I'm working on migrating from SQL Server 2000 to SQL Server 2005. This is providing DB service for a C++ application that uses SQL Native Client to communicate with SQL Server via ODBC. Problem: I'm attempting to insert QNAN into a…
antik
  • 5,282
  • 1
  • 34
  • 47
2
votes
1 answer

Alternative way with which I can execute the stored procedure which generates dynamic columns, which can be supplied to PIVOT in the "in clause"

I am working on a query in sql server management studio 2012 which generates dynamic columns, as we have used pivot to convert rows to columns. Due to some constraints we cannot use stored procedure to return the pivoted result set. In order to…
Jennifer Jes
  • 35
  • 5
2
votes
2 answers

"Provider cannot be found" error after migrating from IIS 6.0 to IIS 8.5

I have a ASP site which is working fine on Windows Server 2003 & IIS 6.0. I migrated to Windows Server 2012 R2 IIS 8.5 I am getting an error when it tries to connect to a database: Provider cannot be found. It may not be properly installed Error…
Hardik
  • 21
  • 1
  • 4
2
votes
1 answer

Sql Server ODBC TVP procedure with a NULL field value

Summary: How do you specify a nullable field value at a row/column index of a tabled-value parameter using odbc Fully Bound Multirow Buffer technique? Details: I have defined a Table Type as follows: CREATE TYPE tp_Transition AS TABLE ( …
Frédéric
  • 21
  • 1
1
2 3