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.

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.

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

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