|
Blue Forest http://www.lslnet.com at 11:08 on July 8, 2006
Bcp into being given (solution), however, new problems Bcp safedb.shenbao.tblStatus out /home/sybase/tx.txt -Ushenbao -Pabcdefg -STEST-c
This order can tblStatus tx.txt document into the record.
But implementation :
[color=Red]bcp Safedb.shenbao.tblStatus in /home/sybase/tx.txt -Ushenbao -Pabcdefg -STEST -c[/color]
Incorrect report :
User not allowed in database 'sybsystemprocs' only the owner of this database can access it.
Stored procedure 'sp_serverinfo' not found.Specify owner.objectname or use sp_help to check whet her the object exists.
Where is this right?
Thank you
|
Ha ha Strange
What version? What platform? List all the way? |
Database users in a field in the same table bcp trying to see what |
I know, it is thought that the reasons for users. I tell you the correct order :
Safedb.shenbao.tblStatus out : bcp derived /home/sybase/tx.txt -U[color=Red]shenbao[/color] -Pabcdefg -STEST-c
Introduction : bcp safedb.shenbao.tblStatus in /home/sybase/tx.txt -U[color=Red]sa[/color] -Pabcdefg -STEST-c
Introduction sa users when necessary, if the shenbao users may need to give authority to ask bcp is what authority?
|
Insert bars |
-->
$ Isql -Usa P -SLINUX1
1>grant insert to shenbao
2>go
Incorrect report : Incorrect syntax near the keyword 'to'
Is not where |
Grant insert on tblStatus to shenbao |
Your order wrong bcp
Bcp database. . Table name
You made a point to the database with two points after
Bcp safedb. . Shenbao.tblStatus in /home/sybase/tx.txt -Ushenbao -Pabcdefg -STEST-c
Bcp must insert in authority must select bcp out authority, the authority should pay more attention to documents OS |
| |