BCP Out error SQLState = 08001, NativeError = 22

  • 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!

Viewing post 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply