Stack Overflow
Stack Overflow

Questions tagged [sql-server-native-client]

58 questions
0
votes
0 answers

SQL server using Native Client 10.0 error

I need to run a BCP export from a db for an external client. The stored proc is pre-written. When I try and output the file to csv, I get this error Error = [Microsoft][SQL Server Native Client 10.0]This version of SQL Server Native Client does not…
Snork
  • 1
  • 1
0
votes
1 answer

Does MSSQL JDBC utilize server aliases

I am preparing for a SQL Server database migration. I would like to use the alias functionality from the SQL Server Native Client, configured with cliconfg.exe, to redirect my client applications to the new server. I am using this in conjunction…
CElliott
  • 442
  • 2
  • 8
0
votes
0 answers

ODBC DSN connection Error (SQL Server Native Client 11.0)

I am trying to create a 64 bit DSN connection to connect with SQL Server. Below are the configuration that I am making (Keeping rest of the settings to default): Server: a_sql_server Authentication: Windows Authentication Application intent:…
Mahendra Dhaker
  • 43
  • 8
0
votes
0 answers

SQL Server instance list in ODBC not populating

I have two computers connected to the same switch on the same network with the same subnet, and when I go to either 32 or 64-bit ODBC to create a System DSN and attempt to add a new DSN using the SQL Server Native Client 11.0, the Server list is…
Sophtware
  • 1,796
  • 2
  • 21
  • 34
0
votes
1 answer

SQL Server Native Client compatibility

Our whole team is using SQL Server Native Client 11.0 and we have a new member joining our team but he is only able to install SQL Server Native Client 2012. Will there be any compatibility problems or issues that may arise from this?
googlesheet test
  • 247
  • 1
  • 13
0
votes
1 answer

Could not retrieve table list. - SQL Server Import and Export - SQL Server Native Client RDA 11.0

I am trying to import data to database from text file. I have SQL Server 2019 installed. I am using SQL Server Native Client RDA 11.0. For some reason I cannot connect to the database when I want to set the data destination. This is the message I…
Furia 824
  • 11
  • 1
  • 4
0
votes
1 answer

Unable to install SSIS on SQL Server 2016 due to SQL Server 2012 Native client error

I am trying to add SSIS to SQL Server 2016, but I keep getting the error message: "An installation package for the product Microsoft SQL SERVER 2012 Native Client cannot be found. Try the installation again using a valid copy of the installation…
LilJam
  • 11
  • 3
0
votes
0 answers

Is there any way to connect to SQL Server 2000 from SQL Server 2016 Profiler

We're verifying legacy system in SQL Server 2000 and confirmed we can connect it from SQL Server Management Studio 2016 (Need to add TCP port though). Now we'd like to connect SQL Server Profiler 2016 to 2000, since we'd like to capture running…
Sachiko
  • 808
  • 1
  • 12
  • 31
0
votes
2 answers

VB6 "Provider cannot be found."

I have a few applications written in VB6 that are all using the same connection string on the same machine. They are using the ODBC provider with the SQL Server Native Client 10.0 driver and connecting with explicit username and password. At…
Geo Ego
  • 1,315
  • 7
  • 27
  • 53
0
votes
1 answer

SQL Native client driver 10 vs 11

Has anyone experienced a difference between SQL driver SQLNCLI11.1 vs 10.1? I inherited a complex SSIS package where I had to make minor changes (package loads data from 18 files to a SQL database). The package works well with 10.1. But gives an…
Nayak
  • 473
  • 3
  • 10
0
votes
0 answers

ADODB.recordset AddNew/Update Method Error -2147467259 (80004005)

I've been getting the following error when trying to write data from my HMI to a MSSQL db using ADODB.recordset with the AddNew/Update Methods. I'm using SQL Server Native Client 11.0 for the connection and Microsoft ActiveX Data Objects 6.0…
ObsoleteATM
  • 1
  • 3
0
votes
1 answer

Connect to SQL Server Native Client 10.0 OLE DB Provider in java

I've seen lots of sites online that have connection strings for languages other than Java to connect to SQL Server Native Client 10.0 OLE DB Provider, such as: "Provider=SQLNCLI10;Server=myServer;Database=myDatabse;UID=myUID;PWD=myPWD" And I've…
Steven DiCarlo
  • 11
  • 8
0
votes
2 answers

How to run a win32 native application that requires sql server native client on MacOSX with winebottler?

I am experimenting with WineBottler and I would like to try to run my win32 native application written in Delphi on OSX. The application runs, but I stop at login screen since I cannot connect to SQL Server. Does anyonw know how to install and…
UnDiUdin
  • 14,924
  • 39
  • 151
  • 249
0
votes
1 answer

MSSQL query no longer works with Windows 10 client: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value

We have been using the following SQL query for a long time in a WinForms program with no problems, until some end users upgraded to Windows 10. They suddenly get the exception:"ERROR [22007] [Microsoft][SQL Server Native Client 11.0][SQL Server]The…
Håkon Seljåsen
  • 589
  • 5
  • 18
0
votes
0 answers

Cannot create ODBC datasource using SQL Native Client

I have SQL Server 2005 and some databases created on system A. Then I had to create System B by cloning system A. I made all the necessary changes to ip and hostname and respective changes to sql server configurations. Earlier I had created an ODBC…
Rohit Sasikumar
  • 89
  • 1
  • 2
  • 10
1 2
3
4