Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Run-time error "5...
Microsoft Dynamics RMS (Archived)

Run-time error "5"; Invalid Procedure call or argument

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

error #-2147467259 sql server does not exists or access denied

error #-2147467259 sql server does not exists or access denied. (source: Microsoft OLE DB Provider for SQL Server)

SELECT GETDATE() AS CurrentDateTime

after that is displayed anothe error pops up

 

Store Operations POS

Run-time error "5";

Invalid Procedure call or argument

RMS Ver 2.0.1006

SQL 2008R2

Window 7

I am getting above error message durning a transacion ramdomly.

It happens after upgraded from SQL 2005 to SQL 2008r2.

any idea??

*This post is locked for comments

  • RMS Wizard Profile Picture
    RMS Wizard 1,205 on at
    RE: Run-time error "5"; Invalid Procedure call or argument

    POS, Ctrl-F6, uncheck "Display HTML status bar", OK.

    Does problem go away afterwards?

  • Suggested answer
    arishi Profile Picture
    arishi 740 on at
    RE: Run-time error "5"; Invalid Procedure call or argument

    Hello Haemin,

    if you have a spare PC with WIN7 Pro, just try switching the server and monitor if you get any error

    do you have any custom Add-on Modules running?

    contact local partner for on site support

    if not You can find a new partner by going to www.microsoft.com/dynamics, clicking on the "Resources" tab, and choosing "Marketplace." You can search for a new partner by location, business industry, product line, or all three at the same time.

    or contact Microsoft Dynamics Technical Support by calling 888-477-7877

    or if you would like I can remote login and check for you

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Run-time error "5"; Invalid Procedure call or argument

    Hi. Arif Hamirani

    I just got a call from cutomer.

    they said that it happened again even after upgrded from 2.0.126 to 2.1.006

    and also I have another customer who has been using RMS 2.0 and SQL 2008R2 for 2 years. he is having the same issue.(the same error message) when they print Z report.

    this is very weird. because this customer did not have any problem for 2 years.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Run-time error "5"; Invalid Procedure call or argument

    Hi Ramy EL-Hefnawy

    I have double checked that they did not change any LANGUAGE setting.

    any other idea?

  • Suggested answer
    raelhefn Profile Picture
    raelhefn on at
    RE: Run-time error "5"; Invalid Procedure call or argument

    This issue rising from change language setting of your PC. change machine language to previous language setting from control panel. check for both POS and back office server.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Run-time error "5"; Invalid Procedure call or argument

    I just upgraded RMS ver from 2.0.126 to 2.1.006

    I will let you know what will happen.

    Thank you.

  • Suggested answer
    arishi Profile Picture
    arishi 740 on at
    RE: Run-time error "5"; Invalid Procedure call or argument

    click on start button --> enter in search Event Viewer --Windows Logs --> Application

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Run-time error "5"; Invalid Procedure call or argument

    window 7

    firewall is off and No anti virus installed.

    how can I check event logs?

  • Suggested answer
    arishi Profile Picture
    arishi 740 on at
    RE: Run-time error "5"; Invalid Procedure call or argument

    check event logs for errors on server for SQL Server 2008 R2, may be you will get a lead from there

    which OS is running on Server? if you have any spare Windows 7 Pro system try with SQL 2012 express and see if that fix the problem, make sure do not install any Anti Virus or Firewall

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Run-time error "5"; Invalid Procedure call or argument

    Hi Arif.

    I have install SQL Express 2005 Backward on server and all worksatations.

    and updateed RMS to Lastes ver.

    but I still have the same issue.

    any idea?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans