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.
I will get the same error in isql if I try selecting from any table :
"1> select * from OddsDealer
Msg 208, Level 16, State 1:
OddsDealer not found. Specify owner.objectname or use sp_help to check whether
the object exists (sp_help may produce lots of output).
the interfaces file contains the following :
master tcp ether db 4100
query tcp ether db 4100"