OleDbCommandBuilder unexpected behavior

  • Thread starter Thread starter Prodip K Saha
  • Start date Start date
P

Prodip K Saha

Here is my scenario- I have two stored procedures in Sybase with same name
with different ownership. Normally, I have only one procedure with dbo
ownership but today I have another procedure with non-dbo owner. That's
where the problem starts. I am using .Net Framework 1.1 with this app.

When I use OleDbCommandBuilder.DeriveParameters(cmd); //OleDbCommand cmd;
It get paqrameters from both stored procedures. The count is exacttly
duplicated (26) since I have same number (13) of parameters in both the
procedures.

Workaround: Build the command with owner.procedure_name as oppose to just
the procedure_name.

I just wanted to share this information with you all.

Thanks,
Prodip
 
Back
Top