NODBC with .NET

mctaggart

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

kine

Try to configure the Navision for Windows Logins. May be that now it is trying to do Database login but without User and Password...

mctaggart

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

I tried the access connection string and that didn't work for me either.

Mike

marco.morreale

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