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

Regards

Sudhakar

-- Anonymous, October 04, 2001

Answers

Sudhakar,

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

Hope this helps,

Eric

-- Anonymous, October 09, 2001