SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 9 of 9
  1. #1
    Member
    Join Date
    Jun 2002
    Location
    Guildford,Surrey,United Kingdom
    Posts
    40
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Problem with usage of DLL...

    User (prasanna_chanthu@standardlifehealthcare.com.nospa m) posted:

    Hi All,

    I wanted to use a dll created in VB. I used following piece of code for
    loading the dll and accessing the function in dll.

    ####
    unload_dll("c:\\DataTableSearch.dll");
    load_dll("c:\\DataTableSearch.dll");
    extern int search(in string,in string,in int,in string);
    search ("excel.xls","76115",137,"C");
    ####
    I'm getting following error..

    "Error: Function 'search' : RPC ERROR

    ###
    Can anyone guide me to overcome this error....Thanks in advance....

    ---------------------------
    Regards,
    Prasanna.
    EPS - Testing.


    For more information on Standard Life Healthcare, visit our
    website http://www.standardlifehealthcare.co.uk

    Standard Life Healthcare Limited is a wholly owned subsidiary of The
    Standard Life Assurance Company. Registered Office: Wey House,
    Farnham Road, Guildford, Surrey GU1 4XS. Registered in England
    Number 2123483. Tel: 01483 440550. Calls may be recorded or
    monitored. This confidential e-mail is for the addressee only.
    If received in error, do not retain/copy/disclose it without our consent
    and please return it to us. We virus scan all e-mails but are not
    responsible for any damage caused by a virus or alteration by a third
    party after it is sent.



  2. #2
    Senior Member
    Join Date
    Jun 2002
    Location
    Hadera, Israel
    Posts
    313
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Problem with usage of DLL...

    User Roman Zilber (romanz@enigma.com.nospam) posted:

    try:
    extern int search(inOUT string,inOUT string,in int,inOUT string);


  3. #3
    Member
    Join Date
    Jun 2002
    Location
    Guildford,Surrey,United Kingdom
    Posts
    40
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Problem with usage of DLL...

    User (prasanna_chanthu@standardlifehealthcare.com.nospa m) posted:


    I tried with
    extern int search(inout string,inout string,inout int,inout string);
    extern int search(inout string,inout string,in int,inout string);

    Both,while executing the function it is giving
    "Argument passed to "(null)" in search must be variable or array element.

    Any more tips????
    ---------------------------
    Regards,
    Prasanna.
    EPS - Testing.
    +44-(0)1483-553725(O)
    +44-(0)7732938769(M)



    Roman Zilber
    <romanz@enigm To: "'winrunner@yahoogroups.com'" <winrunner@yahoogroups.com>
    a.com> cc:
    Subject: RE: [winrunner] Problem with usage of DLL...
    04/07/2002
    15:50
    Please
    respond to
    winrunner



    try:
    extern int search(inOUT string,inOUT string,in int,inOUT string);


  4. #4
    Senior Member
    Join Date
    Jun 2002
    Location
    Hadera, Israel
    Posts
    313
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Problem with usage of DLL...

    User Roman Zilber (romanz@enigma.com.nospam) posted:

    not "inout" for int


  5. #5
    Member
    Join Date
    Jun 2002
    Location
    Guildford,Surrey,United Kingdom
    Posts
    40
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Problem with usage of DLL...

    User (prasanna_chanthu@standardlifehealthcare.com.nospa m) posted:


    I tried both ..inout for int and just in for int...
    both are giving same error...
    ---------------------------
    Regards,
    Prasanna.
    EPS - Testing.
    +44-(0)1483-553725(O)
    +44-(0)7732938769(M)



    Roman Zilber
    <romanz@enigm To: "'winrunner@yahoogroups.com'" <winrunner@yahoogroups.com>
    a.com> cc:
    Subject: RE: [winrunner] Problem with usage of DLL...
    04/07/2002
    16:01
    Please
    respond to
    winrunner



    not "inout" for int


  6. #6
    SQA Council
    Join Date
    Mar 2001
    Posts
    8,591
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Problem with usage of DLL...

    User Rocky Dean Pulley (it@mikersoft.com.nospam) posted:

    What's the VB declaration of the function? That would help a lot.

    ----- Original Message -----
    From: <prasanna_chanthu@standardlifehealthcare.com>
    To: <winrunner@yahoogroups.com>
    Sent: Thursday, July 04, 2002 9:15 AM
    Subject: [winrunner] Problem with usage of DLL...


    to winrunner-unsubscribe@yahoogroups.com.
    you require. We get long mailings when the entire message is left
    the email message
    poster to be banned from this list. Please consult 'Terms of Service&quot;
    and &quot;Guidelines&quot; prior to making your first post.



  7. #7
    Member
    Join Date
    Jun 2002
    Location
    Guildford,Surrey,United Kingdom
    Posts
    40
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Problem with usage of DLL...

    User prasannacd (prasanna_chanthu@standardlifehealthcare.com.nospa m) posted:


    This is the piece of code for that function....
    ###########################
    Public Function Search(ExcelName As String, SearchString As String,
    Rowcount As Integer, Colname As String) As Integer

    Dim Filename As String
    Dim Rownumber
    Dim cnt As Integer
    Dim Formula As String
    Dim Col As String
    Dim Quo As Integer
    Dim Remainder As Integer
    Dim Let1 As String
    Dim Let2 As String

    'Filename = "C:\" & ExcelName
    On Error GoTo ErrBlock
    Set WB = ExcelApp.Workbooks.Open(ExcelName)

    For cnt = 1 To 75
    If UCase(Trim(ExcelApp.ActiveSheet.Cells(1, cnt).Value)) =
    UCase(Trim(Colname)) Then
    If cnt > 26 Then
    Remainder = cnt Mod 26
    Quo = (cnt - Remainder) / 26
    Let1 = GetColumnLetter(Quo)
    Let2 = GetColumnLetter(Remainder)
    Else
    Let1 = GetColumnLetter(cnt)
    Let2 = ""
    End If
    Exit For
    End If
    Next cnt

    Col = Let1 & Let2
    If IsNumeric(SearchString) Then
    Else
    SearchString = """" & SearchString & """"
    End If

    Formula = "=MATCH(" & SearchString & "," & Col & "1:" & Col & Rowcount &
    ",0)"

    WB.Worksheets("Sheet1").Range("A" & Rowcount + 1).Formula = Formula
    Rownumber = WB.Worksheets(1).Range("A" & Rowcount + 1).Value

    WB.Close (False)
    ExcelApp.Quit
    Set ExcelApp = Nothing

    Search = Rownumber

    Exit Function

    ErrBlock:
    Search = 0
    WB.Close (False)
    ExcelApp.Quit
    Set ExcelApp = Nothing
    End Function

    ##########################

    Any ideas???????????????????????
    ---------------------------
    Regards,
    Prasanna.
    EPS - Testing.
    +44-(0)1483-553725(O)
    +44-(0)7732938769(M)



    "Rocky Dean
    Pulley" To: <winrunner@yahoogroups.com>
    <it@mikersoft cc:
    .com> Subject: Re: [winrunner] Problem with usage of DLL...

    04/07/2002
    16:24
    Please
    respond to
    winrunner



    What's the VB declaration of the function? That would help a lot.

    ----- Original Message -----
    From: <prasanna_chanthu@standardlifehealthcare.com>
    To: <winrunner@yahoogroups.com>
    Sent: Thursday, July 04, 2002 9:15 AM
    Subject: [winrunner] Problem with usage of DLL...


    message
    to winrunner-unsubscribe@yahoogroups.com.
    you require. We get long mailings when the entire message is left
    in
    the email message
    poster to be banned from this list. Please consult 'Terms of Service&quot;
    and &quot;Guidelines&quot; prior to making your first post.

  8. #8
    Member
    Join Date
    Nov 2001
    Location
    Hartford, CT USA
    Posts
    47
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Problem with usage of DLL...

    User condoman1944 (bneild@travelers.com.nospam) posted:

    This was previously discussed. VB cannot create dll's that WinRunner
    can use.


    --- In winrunner@y..., prasanna_chanthu@s... wrote:
    for
    consent
    third



  9. #9
    Member
    Join Date
    Nov 2001
    Location
    Hartford, CT USA
    Posts
    47
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Problem with usage of DLL...

    User condoman1944 (bneild@travelers.com.nospam) posted:

    No problem. I had researched this some time ago and wanted to save
    you the trouble.

    --- In winrunner@y..., prasanna_chanthu@s... wrote:
    question...sorry,if


    winrunner@y...

    cc:

    Re: Problem with usage of DLL...

    08/07/2002

    12:05

    Please

    to

    winrunner



    WinRunner
    code
    advance....
    The
    message
    program
    that
    address in
    cause the
    Service&quot; http://docs.yahoo.com/info/terms/
    consent
    third



 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 7.14%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 06:27 AM.

Copyright BetaSoft Inc.