BCP fails when run from a client system in SQL 7.0

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Hi Eric

When I do BCP out from the Server console, it is extracting the data, where as if I run the same command it gives the following error :

SQLState : S1092 [ODBC] [Microsoft SQL Server Driver] Invalid attribute / object identifier.

The syntax what I have used is :

bcp master..sysxlogins out syslogin.out -S -Uusername -Ppassword -c

COuld you helpme out in this regard



-- Anonymous, October 04, 2001



You need to reinstall MDAC 2.1 (not 2.0) from the SQL Server 7 CD.

Hope this helps,


-- Anonymous, October 09, 2001

Moderation questions? read the FAQ