Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2003
    Location
    Londo, UK
    Posts
    4

    Unanswered: problems with bcp when dumping a table

    First let me say I'm very new to sybase

    My problem occurs when using bcp to dump a table (I thinks it is around 4GB).

    The command I use is :
    bcp OddsDealer out OddsDealer.txt -U sa -S db2

    This gives me the result :

    "Server Message: - Msg 208, Level 16, State 1:
    temp1 not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).

    Unexpected result type returned.
    Retrieving table format failed."

    I have searching the web for help on this, but everything I find has something to do with "stored procedures", which I do not use.

    I've tried adding the table name to the sp_help file, witout any luck.

    It suggest I "Specify owner.objectname" - i suppose objectname is the table name (OddsDealer). As far as I understand, I shouldn't specify an owner if the owner is dbo (which ownes almost every table according to sp_help). I'm really stuck here - so any help would be much appreciatet.

  2. #2
    Join Date
    Feb 2003
    Location
    Londo, UK
    Posts
    4

    more info about this problem

    I will get the same error in isql if I try selecting from any table :

    "1> select * from OddsDealer
    2> go
    Msg 208, Level 16, State 1:
    Line 1:
    OddsDealer not found. Specify owner.objectname or use sp_help to check whether
    the object exists (sp_help may produce lots of output).
    1>"

    the interfaces file contains the following :

    "db2
    master tcp ether db 4100
    query tcp ether db 4100"

    so I should be using the correct database.

  3. #3
    Join Date
    Feb 2003
    Location
    Londo, UK
    Posts
    4

    Help no longer needed!

    I won't be needing this bcp program anymore - doing things different.

  4. #4
    Join Date
    Jun 2002
    Location
    Argentina
    Posts
    78

    Smile Re: problems with bcp when dumping a table

    Late, but I guess You forgot the database name of the table, this like this:

    "Your_databases.owner.table_name"

    The next time try this:

    bcp Your_databases.dbo.OddsDealer out OddsDealer.txt -U sa -S db2 -e error_bcp.log

    Bye

    Sebastian

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •