Stack Overflow
Stack Overflow

Questions tagged [sqlncli]

37 questions
0
votes
0 answers

SQL SERVER - TCP an OLE DB Provider Errors

I'm using a Linked Server to execute remote queries between two DBs on different servers. Both DBs are SQL SERVER. However, I'm getting the following errors: 1 - TCP Provider: The semaphore timeout period has expired. 2 - OLE DB Provider:…
AnnaB
  • 35
  • 5
0
votes
0 answers

Network related instance specific error When connecting sql2000 from sql2012

Since yesterday I am trying to access my sqlserver 2000 which is hosted on windows server pc. From my laptop on same network, using sql2012 and also by c# connection string. I have also installed native client 10.50 side wise. Still no success. Can…
nimra asad
  • 179
  • 6
  • 18
0
votes
2 answers

SQL Native Client crashes when second connection is opened when connection pooling is on?

I'm working with a C++ application that uses SQL Native Client to communicate via ODBC with a SQL Server 2000 database. Before doing any database work, I allocate an environment handle as follows: retcode = SQLAllocHandle( SQL_HANDLE_ENV,…
antik
  • 5,282
  • 1
  • 34
  • 47
0
votes
1 answer

Command dialect is not supported by SQLNCLI11 provider SQL Server 2012

We are using classic ASP and SQL Server 2012 standard edition. Our connection string is as below provider=SQLNCLI11;Data Source=xxx; MultiSubnetFailover=True; Initial Catalog=xxx; User ID = xxx; Password =xxxxxx; DataTypeCompatibility=80; Integrated…
Dream
  • 11
  • 1
  • 1
  • 3
0
votes
0 answers

Application for debugging SQLNCLI Connections

I am having difficulty getting an application that uses SQL native client to connect to my SQL Server, which up until this point functioned just fine. SQL Profiler on the source server indicates my troublesome application isn't even connecting to…
Al Geary
  • 53
  • 6
0
votes
1 answer

Failing to delete record from linked server

I've spent the past two days searching everywhere for a solution to my problem but without any luck. I have this query that deletes record from a remote server: delete from OPENROWSET('SQLNCLI',…
Moshe Derri
  • 206
  • 2
  • 11
0
votes
1 answer

What are the differences between SQL Native Client and SQL Native Client 10?

Can anyone direct me to a link or source that outlines either in general or in detail reasons to change your connection string from SQLNCLI to SQLNCLI10 when upgrading from SQL Server 2005 to 2008? Outside of datatype issues, I am not seing any…
user1186256
  • 197
  • 3
  • 5
  • 15
1 2
3