Nodbc

lists.ryan@gmail.com · 2007-03-02

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

Timo_Lässer · 2007-03-02

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

lubost · 2007-03-02

You are accessing MS Access database, so you have to use login to it. Your permission on Navision are not important.

lists.ryan@gmail.com · 2007-03-05

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

Skanderby · 2007-11-08

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

Skanderby · 2007-11-08

I found the solution. There is a hotfix!

/Michael

Faberman · 2007-12-10

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<

Rainmaen · 2008-10-27

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

j.marselo · 2008-10-29

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.

Nodbc

Comments

Categories