Post reply

Extended Procedure

  • February 8, 2008 at 10:16 am

    #154119

    I created an extended procedure in the following format

    sp_addextendedproc xp_add , 'C:\Program Files\Microsoft SQL Server\MSSQL\Binn\add.dll'

    When i was try to execute it, getting the following error

    Cannot find the function xp_add in the library C:\Program Files\Microsoft SQL Server\MSSQL\Binn\add.dll. Reason: 127(The specified procedure could not be found.).

    please help me out

  • February 8, 2008 at 6:13 pm

    #776667

    Is that file path on the server... or on your desktop box?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • February 8, 2008 at 8:33 pm

    #776673

    its in my specified folder

  • February 10, 2008 at 8:01 am

    #776737

    susheereddy (2/8/2008)

    its in my specified folder

    The server needs to be able to "see" and "read" your "specified folder". That's why I was asking what its physical location was.

    Good luck.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • February 10, 2008 at 12:04 pm

    #776767

    this is where is stored my dll file

    C:\Program Files\Microsoft SQL Server\MSSQL\Binn\add.dll

    thanks for ur reply

  • February 10, 2008 at 12:57 pm

    #776775

    I know... you said that before...

    WHICH MACHINE is that on! Is it on the SQL Server or on your DESKTOP computer?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • February 10, 2008 at 1:29 pm

    #776777

    I mean i have installed a developer edition in my computer and thats path is in C folder

    i am learning sql i don't have any real time experience

  • February 10, 2008 at 3:45 pm

    #776785

    Ok... understood...

    Run the following query from SSMS and let's make sure that the "server" (your Developer's Edition) can see the file...

    EXEC master..xp_fileexist 'C:\Program Files\Microsoft SQL Server\MSSQL\Binn\add.dll'

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • February 11, 2008 at 10:40 am

    #776996

    Thank u man

    i have executed the command which u said and it shows that the file is existed.

    I have no problem in creating an extended procedure and only problem i am getting is while executing it.

    I don't why i am getting this error.

    Cannot find the function xp_add1 in the library C:\Program Files\Microsoft SQL Server\MSSQL\Binn\add.dll. Reason: 127(The specified procedure could not be found.).

  • February 11, 2008 at 4:08 pm

    #777121

    Could it be that simple? Your original post said you added an extended sp called "xp_add" yet in your latest post you say you are using "xp_add1". Do notice the extra character there...

    I'm running out of ideas here...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • February 11, 2008 at 5:37 pm

    #777153

    since xp_add is already there i have created one more xp_add1 with all your suggestions but still i am getting the same error

    thanks for ur support

  • February 11, 2008 at 5:53 pm

    #777155

    When you created the new xp's, did you make sure that you created them in the Master database?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply