Stack Overflow
Stack Overflow

Questions tagged [sqlncli]

37 questions
2
votes
2 answers

Logon failed, Crystal Reports 9, VB6 , sql server, sqlncli

i'm trying to build a setup package for a legacy vb6 software. the software itself connects to a sql server via sqlncli (native client). i've packaged all the dependencies and deploy them to a new machine running winxp and office2003. now, from the…
BigBlackDog
  • 544
  • 1
  • 6
  • 19
2
votes
1 answer

SQLNCLI10 Provider with windows 8

I'm facing a trouble with Windows 8. I've an application in VB6 using SQL Server 2008 through the net with SQLNCLI10 provider, which I always install with sqlncli10.msi, but when I tried to install in a PC with Windows 8, I can't... said something…
Gabriel
  • 879
  • 1
  • 13
  • 33
1
vote
2 answers

SQLBindParameter to prepare for SQLPutData using C++ and SQL Native Client

I'm trying to use SQLBindParameter to prepare my driver for input via SQLPutData. The field in the database is a TEXT field. My function is crafted based on MS's example here: http://msdn.microsoft.com/en-us/library/ms713824(VS.85).aspx. I've setup…
antik
  • 5,282
  • 1
  • 34
  • 47
1
vote
0 answers

ODBC Errors in client application connecting to MS SQL database

Hello the issue started like month ago, when our administrators updated Windows servers to latest updates and our customer start having weird error messages in certain time window from 6am to 8am on client application. The message is…
Roman Schmidt
  • 55
  • 1
  • 12
1
vote
1 answer

SQL Server Always Encrypted - Certificate not found (ODBC)

I'm hitting an issue when trying to test a legacy classic ASP application against a SQL Server 2016 Always Encrypted column. This is a sample of the ASP code: conn.ConnectionString = "Driver={ODBC Driver 13 for SQL Server};Server…
FrugalShaun
  • 166
  • 7
1
vote
1 answer

TCP Provider: An existing connection was forcibly closed by the remote host

I'm having problems with SQL clients randomly disconnecting from the server with a TCP connection forcibly closed error message. Setup is as follows: SQL 2014 Express running on Windows Server 2008. Clients are Wi-Fi connected Microsoft Surface…
Jim
  • 71
  • 1
  • 1
  • 8
1
vote
1 answer

Error connecting to Sql Azure: TCP Provider: No such host is known

I am trying to connect to SQL Azure using OLEdb. When i do, i get the error: Source: Microsoft SQL Server Native Client 10.0 Description: TCP Provider: No such host is known. SQLState: 08001 NativeError: 11001 I can connect using: SQL Server…
Ian Boyd
  • 246,734
  • 253
  • 869
  • 1,219
1
vote
1 answer

sqlnclir.rll being loaded and unloaded continuously

I'm working with SQL Native Client 9 in a C++ application that communicates with SQL Server 2000. I'm working on debugging things right now but something I've noticed that bothers me (mostly because it's creating significant clutter) is that…
antik
  • 5,282
  • 1
  • 34
  • 47
1
vote
1 answer

Installing SQL Sever 2008 R2 Native Client Not Working

I'm struggling to install SQL Server 2008 R2 Native Client using MSIExec through VBScript. I'm trying to complete the installation without the user needing to interact with the installer but I'm getting the error message The required…
Gareth
  • 5,140
  • 5
  • 42
  • 73
1
vote
1 answer

Linked Server inconsistent metadata

Set up a linked server between SQL 2005 and Azure. Downloaded Native Client 10 since it is apparently needed. Says the Connection is successful. Receive the following in trying to retrieve or upload data: The OLE DB provider "SQLNCLI10" for linked…
alemus
  • 314
  • 1
  • 2
  • 17
0
votes
1 answer

Changing SQL Provider from SQLOLEDB.1 to SQLNCLI.1 causes app to fail when accessing data via stored procedure

I'm supporting a legacy app written in MFC/C++. The database for the app is in SQL Server 2000. We bolted on some new functionality recently and found that when we change the SQL Provider from SQLOLEDB.1 to SQLNCLI.1 some code that is trying to…
Scott
  • 513
  • 9
  • 20
0
votes
1 answer

SQLNCLI syntax error when using OPENROWSET in SQL Server 2019

SQLNCLI syntax when using OPENROWSET We have been using this syntax when using OpenRowset to collect data from other SQL Server instances. SELECT a.* FROM OPENROWSET('SQLNCLI', 'Server=MyServer;Database=Tasks; User…
Saqlain Mushtaq
  • 153
  • 3
  • 9
0
votes
0 answers

The 'SQLNCLI10.1' provider is not registered on the local machine for VS 2019

I have already visited all these answers but they are not working for me, I have installed Native server but still getting the same error but still facing this error: I also download OLE DB drivers from here
AHF
  • 1,070
  • 2
  • 15
  • 47
0
votes
1 answer

SQLNCLI is Deprecated, but is that only for SQLNCLI OLEDB, or for SQLNCLI ODBC as well?

We have an application written in C (not c++) that uses sqlncli.h, specifically, the ODBC implementation and not OLEDB. According to Microsoft The SQL Server Native Client (SQLNCLI) remains deprecated and it is not recommended to use it for new…
DbForumGuy
  • 63
  • 1
  • 6
0
votes
2 answers

Use conditional compilation to check if user has SQL Native Client? (ODBC)

I want to use sqlncli.h but only if it is available to the user, and if not, I want to use less optimal but functional replacement code (I really just want to use Multiple Active Result Sets, other DBMSes don't seem to require special configuration…
gabriel.hayes
  • 2,267
  • 12
  • 15
1
2
3