May 22, 2012 at 10:16 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy