Stack Overflow
Stack Overflow

Questions tagged [sql-server-native-client]

58 questions
11
votes
4 answers

Cannot connect from Classic ASP to SQL Server 2008 R2 using SQL Native Client (Windows 7 - IIS7)

I'm able to connect to SQL server 2008 R2 when I use Provider=SQLOLEDB in my connection string. But when I use Provider=SQLNCLI in connection string I'm unable to connect. ADODB.Connection error '800a0e7a' Provider cannot be found. It may not be…
IsmailS
  • 10,797
  • 21
  • 82
  • 134
5
votes
4 answers

Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Communication link failure

Below, you'll notice some Windows Command Prompt commands that I'm trying to call from the 64 bit Program Files folder for Microsoft SQL Server 2008 C:\Program Files\Microsoft SQL Server\100\Tools\Binn>SQLCMD -S "SQLI2B2" -d "I2B2_CRC-DEV" -i…
JustBeingHelpful
  • 18,332
  • 38
  • 160
  • 245
5
votes
1 answer

Insert TDateTime field to SQL 2008 DB using Native Client 10

We have a legacy application that is written in Delphi 2007 and is still using the BDE (yes it needs to be switched to ADO but with over 500K lines, that's a BIG job). It connects to an SQL Server 2008 DB using an SQL SERVER ODBC connection. I am…
Caynadian
  • 747
  • 2
  • 12
  • 37
4
votes
2 answers

Record Has Been Changed By Another User when try to Post or Edit

Am developing application using Delphi 7 and Sql Server express 2008 R2 , am using BDE to connect Sql Server through ODBC, and SQL Native Client is used for driver. In some particular forms the table component raise EDBEngineError 'Record has been…
bejarun
  • 175
  • 3
  • 11
4
votes
7 answers

Connection string for SQL Server native client in ASP.NET web.config

I want to connect to SQL Server 2012 using SQL Server native client from my ASP.NET application. Currently, I have one existing connection string connect using odbc and working fine.
vmb
  • 2,878
  • 15
  • 60
  • 90
4
votes
1 answer

How to get SQL Server DateTime field in ODBC native client

I'm have SQL Server table: CREATE TABLE [dbo].[Table1]( [rec_id] [int] IDENTITY(1,1) NOT NULL, [id] [int] NOT NULL, [date] [datetime] NOT NULL, [ps] [varchar](200) NULL ) ON [PRIMARY] I'm getting data by a code: status =…
amaranth
  • 979
  • 2
  • 22
  • 40
4
votes
3 answers

Why doesn't SQL Server automatically up-convert DATE to DATETIME for comparison purposes?

I love the new DATE datatype in SQL Server 2008, but when I compare a DATE field to a DATETIME field on a linked server (SQL 2005, in this case), like this: DECLARE @MyDate DATE SET @MyDate = CONVERT(DATE, GETDATE()) SELECT * FROM…
SqlRyan
  • 33,116
  • 33
  • 114
  • 199
4
votes
1 answer

Page hangs when trying to load SQLSRV (PHP5 in IIS6, Windows Server 2003 R2)

I apologise if any of this sounds like a broken record but I've trawled the internet for days and have cross-referenced at least three "how to install PHP 5 with IIS 6" guides but have had no luck whatsoever. I'm trying to configure PHP 5.4 with IIS…
valoukh
  • 541
  • 1
  • 8
  • 19
3
votes
2 answers

sqlcmd not working after installing sql server 2005 express

I downloaded the 53.5 MB setup of SQL Server 2005 Express from this URL: Microsoft SQL Server 2005 Express Edition Then I ran sqlcmd by going into command promp , but it shows error HResult 0x2, Level 16, State 1 Named Pipes Provider: Could not…
sqlchild
  • 8,754
  • 28
  • 105
  • 167
3
votes
2 answers

How to migrate datetime to datetime2 with new SQL Server Native Client

We are currently migrating our database from datetimeto datetime2 including SQL Server Native Client v11 (SQL Server 2012). The database update was easily done, but the problems come along with the new SQL Server Native Client 11 we want to use. In…
Danielku15
  • 1,490
  • 1
  • 13
  • 29
3
votes
3 answers

BDE, Delphi, ODBC, SQL Native Client & Dead lock

We have some Delphi code that uses the BDE to Access SQL Server 2008 through the SQL Server Native Client ODBC driver (2005 version). Our issue is that we're experiencing some deadlock issues in a loop doing inserts to multiple tables. The whole…
EspenS
  • 31
  • 1
  • 2
2
votes
3 answers

ODBC Error: Invalid String or Buffer Length--Microsoft Server 2008 32bit vs 2008 R2 64bit

Attempting to connect from Java 6 console app to Microsoft SQL Server 2008 R2 on an Microsoft Windows Server 2008 R2 64bit system via an ODBC System DSN using SQL Server Native Client 10.0. The following source code: try { …
Noel
  • 2,061
  • 4
  • 31
  • 47
2
votes
2 answers

What is the difference between SQL Server Native Client SQLNCLI11 & SQLNCLI11.1?

I'm having a look at a connection string with Provider=SQLNCLI11 and another one with Provider=SQLNCLI11.1 & i'm wondering what the difference between the two is. What is the difference between SQLNCLI11 & SQLNCLI11.1?
StackTrace
  • 9,190
  • 36
  • 114
  • 202
2
votes
1 answer

Return NULL data types in C++ native client from SQL Server

I'm writing small C++ console application (VS 2013 / Windows7) that uses SQL Server native client sqlncli.h. I'm have trouble with NULL fields in program - I'm not see right values in out. #include #include #include…
amaranth
  • 979
  • 2
  • 22
  • 40
2
votes
3 answers

PromptDataSource and password

I use PromptDataSource to allow users to setup a database connection. connectionString := ADOdb.PromptDataSource(0, ''); However I can't get it to work with "Allow saving password" when using the SQL Server Native Client 10.0…
MGH
  • 1,189
  • 1
  • 10
  • 18
1
2 3 4