NODBC with .NET

mctaggart
mctaggart Member Posts: 4
edited 2005-11-02 in NAV/Navision Classic Client
Hi,

I'm a .NET programmer who just started working with Navision. I installed NODBC and created a DSN and tested it in MS Access - It worked fine, I was able to link to Navision tables so I know the DSN is configured correctly.

I tried to create an odbcDataAdapter in a C# app by dragging it on to the web form. The wizard then prompts you for a datasource. I selected the DSN I just created from the dropdown list of DSNs and I received an error "Unable to Log on to Database". The odd thing is that the server explorer connection list display the DSN and all the tables associated with the database after the failed attempt. I tried dragging a table on to the web form from the server explorer and I get the same error? Anybody have an idea on how to resolve this?

Thanks, Mike

Comments

  • kine
    kine Member Posts: 12,562
    Try to configure the Navision for Windows Logins. May be that now it is trying to do Database login but without User and Password...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • mctaggart
    mctaggart Member Posts: 4
    Hi Kamil,

    I tried configuring the DSN for both windows login and Database login and neither works in .NET. They both work in MS Access.

    Mike
  • mctaggart
    mctaggart Member Posts: 4
    I tried the access connection string and that didn't work for me either.

    Mike
  • marco.morreale
    marco.morreale Member Posts: 58
    I experienced the same error: "unable to log into database".

    Did anyone find any solution in the meanwhile?

    I used Navision CODBC 3.70 for long without problems.

    It appears to be a new issue for NODBC.

    M

Categories