Linux -Blue forest free software | Return to home page | Site Map | Search WWW | Contact Us |
Your current position : Homepage > Free Software > Technological exchanges >Database


    

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



 Privacy Policy  Copyright © 1999-2000 LSLNET.COM. All rights reserved. Blue Forest website owners. E-mail : Webmaster@lslnet.com