Re: Problem with SqlCommandBuilder.DeriveParameters

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Patrice Scribe (nobody_at_nowhere.com)
Date: 03/04/04 

Date: Thu, 4 Mar 2004 14:14:47 +0100

In this case, I don't see how to workaround other than doing your own
derivation (either by calling the same procedure or by using directly
Information_Schema.Parameters). Additionaly you'll be able then to cache
this information to save server roundtrips...

Patrice 

-- 
"Xandu" <Kristian.Sandven@netinfodoc.no> a écrit dans le message de
news:6969720C-57E8-4D16-A7CA-39D41677DA63@microsoft.com...
> I've tried with:
> System.Data.SqlClient.SqlCommand cmd = new
System.Data.SqlClient.SqlCommand("\"SomeUSer\".\"PAK_TEST.P_OPEN\"",
sqlConnection1);
> cmd.CommandType = CommandType.StoredProcedure;
> System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(cmd);
>
> This also fails, but with a different errormessage:
> Could not locate entry in sysdatabases for database "SomeUser". No entry
found with that name. Make sure the name is entered correctly.
>
> To me it seems that DeriveParameters splits the sp-name into
db.user.sp-name using period (.) and not quoted identifiers or square
brackets as it should.
>
> Xandu

Relevant Pages

  • Re: Tasking, protected objects, Ada 95 RM
    ... protected types "entry" statement. ... So calling connect from there is not potentially blocking. ...
    (comp.lang.ada)
  • Re: BASIC problem calling LIB$ RTL
    ... entry point was improperly passed to the LIB$RENAME_FILE RTL. ... The error message was most accurate. ... so the result of calling it is passed as an argument ...
    (comp.os.vms)
  • Re: Cannot make out what is wrong!Please Help:-(
    ... > SUBROUTINE STATE ... > ENTRY GINITL ... What does your calling program look like? ...
    (comp.lang.fortran)
  • Re: protected type interrupts
    ... calling a protected *entry*). ... out of the entry and into the task, and just use the entry for the ... As far as I understand, it's the mere fact of calling an entry of a protected object that serves as interrupt handler, with a priority in Interrupt_Priority range. ...
    (comp.lang.ada)
  • Re: Resolving a deadlock
    ... Daniel Wild wrote: ... > Task B is calling an entry in Task A to pass it some data. ... Monty Python & the Holy Grail ...
    (comp.lang.ada)