about OdbcParameter

ERROR [42000] [Microsoft][SQL Native Client][SQL Server]Procedure or Function 'abc' expects parameter'@.xyz', which was not supplied.

i have supplied the parameter in the storeprocedure and the odbccommand

anyone why this error still happening?

thanks

How did you supply the parameter? Could you post related code?

about bcp

Hi all,

I would like to know about bcp. The input file (in parameter) must to has \t to separate the columns? Is there a way to choice the separator simbol?

for example the file:

1;Test1;active;
2;Test2;active;
3;Test3;inactive;

Yes, there is a command-line parameter "-t" which can be used to specify a field terminator. See Books Online for more details on the command-line options of BCP.

http://msdn2.microsoft.com/en-us/ms162802(SQL.90).aspx