OleDbCommandBuilder unexpected behavior

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call stored procedure in SSMS from Access 2016 doesn't work. 0
ExecuteReader() not firing exceptions from stored procedures, also HasRows() vs Read() 6
Geting Identity back from SS SP 4
Mystery of ADO.NET: DataAdapter.Update Trucates Decimal Digits 3
No Results 1
DeriveParameters throws NummReferenceException 1
Return_Value not being passed back 3
Problems deploying membership on a hosted environment 2

Top