mibuso.com
Home› NAV/Navision Classic Client
Options

Nodbc

lists.ryan@gmail.comlists.ryan@gmail.com Member Posts: 7
edited 2008-10-29 in NAV/Navision Classic Client
Hi All,

I am trying to connect Ms Access to a NAV 4 SP 2 Native database. I can log in fine with my account but when i try and link tables to it in Ms Access 2003 i get an error :-

ODBC -- Call Failed
[Simba][Simba ODBC Driver][DRM File Library] The Combination of user ID and password entered is invalid Try again. Database Error 1237 (#-49999)

I am a super user if that makes any difference.

TIA.
R
-
Ryan

Comments

  • Options
    Timo_LässerTimo_Lässer Member Posts: 481
    lists.ryan@gmail.com wrote:
    [...] Database Error 1237 (#-49999) [...]
    Internal Error 1237 in Module 19
    Module 19 = Database (look also Module 34)
    Errorcode: 1246421
    Description: #Err_DB_UnknownPassWord
    Timo Lässer
    Microsoft Dynamics NAV Developer since 1997
    MSDynamics.de - German Microsoft Dynamics Community - member of [clip]
  • Options
    lubostlubost Member Posts: 615
    You are accessing MS Access database, so you have to use login to it. Your permission on Navision are not important.
  • Options
    lists.ryan@gmail.comlists.ryan@gmail.com Member Posts: 7
    Hi All,

    Ok this may be a silly question.

    But if the password is specified in the System DSN and works when i select a company in the configuration screen, why does it not work through access ?

    TIA

    Ryan
    -
    Ryan
  • Options
    SkanderbySkanderby Member Posts: 12
    Hi,

    did you find a solution? I have a customer with the same problem. The selection of company works fine, but then he gets the logon error...

    /Michael
  • Options
    SkanderbySkanderby Member Posts: 12
    I found the solution. There is a hotfix!

    /Michael
  • Options
    FabermanFaberman Member Posts: 24
    Hi guys,

    Would you be so kind as to look at my "MS Access queries don't work with parameters using NODBC" post?

    I have looked all over for a solution to it but found nothing. ](*,)

    Any advice / solutions / pointers to articles, downloads, manuals will be greatly appreciated.

    [-o<
  • Options
    RainmaenRainmaen Member Posts: 1
    HI Michael,

    you wrote you did actually find a hotfix solving this problem. I encountered the same situation and did not get it fixed yet. Could you help me finding this hotfix ?

    Tks !!

    brgds - Raimer
  • Options
    j.marseloj.marselo Member Posts: 102
    MS Access queries don't work with parameters using NODBC
    I have a post on similar issue.
    I observe, it seems if a parameter put in a field with datatype is CODE, it will fail to filter.
    Eg. SO No., Item No., Prod. Order No. ...

    So what I do is, in ms access qbe: 
    Field   : No_         | order: left([Sales Order.No_],6) |
----------------------------------------------------------
Table   : Sales Order |                                  |
----------------------------------------------------------
Criteria:             |"SO-001"                          |

    Put the filter on another column, by first, converting the field to text datatype.

    If you still find error, please share here.

    Thank you.
    Kind regards, Joe Marselo | see my NAV blog joemarselo.wordpress.com | twitter @joemarselo
Sign In or Register to comment.