BCP Out error SQLState = 08001, NativeError = 22

• Rodrigo Moraes

  Old Hand

  Points: 358

  More actions

  May 22, 2012 at 10:16 am

  #73358

  Hi all,

  I'm looking for the exact "SQLState = 08001, NativeError = 22" error through the web since last 14, May.

  It looks like nobody got this error but I'm facing it now.

  I have an client tool(C# WinForm) that connects to a sql server and list all the tables in a datagrid. This grid have some checkboxes that I use to check what tables going to be exported through an BCPOut command, that will run on the client's windows shell through a call on cmd.exe process, not on ".NET System.Data.SqlClient".

  My current scenario is:

  Client machine: Windows 7 64bit with SQL Server Management Studio (SQL 2008)

  Server machine: Windows 2000 with SQL Server 2000

  Suspect: Client machine with Win 7 and SSMS 2008 does not have a SQL 2000 client installed

  An example of command:

  BCP "select a.* from Database.dbo.Table a (nolock)" QUERYOUT C:\tabela.txt -SMyServer -UUser -PPass -c -t\t -E -b10000

  And the error message:

  SQLState = 08001, NativeError = 22

  Error = [Microsoft][SQL Server Native Client 11.0]SQL Server Native Client 11.0 does not support connections to SQL Server 2000 or earlier versions.

  I really would like to know how could I install the SQL 2000 client on win7 64bit.

  I appreciate any help.

  Thanks!