How can i know Database type or Connection type?

yukon
yukon Member Posts: 361
edited 2009-12-11 in NAV/Navision Classic Client
Hi Expert,


How can i know database type or connection type? It means current nav connection is SQL or native database. If database is native database, i want to know that connection is local or server.
Another one, can i know current user login type? It means current user is login with window authorization or database . Is it possible to do?



Best Regards,
Yukon
Make Simple & Easy

Comments

  • Yaroslav_Gaponov
    Yaroslav_Gaponov Member Posts: 158
    Hi

    Just use CONTEXTURL command and Session table with filter on My Session field :D
    Yaroslav Gaponov
  • Shedman
    Shedman Member Posts: 194
    SQL or Native you can check by using the RECORDLEVELLOCKING command. If RECORDLEVELLOCKING is true, then you are using SQL.

    To check if you're logged on as database or windows user, you can use the corresponding tables. If you don't find USERID in the user table (2000000002) you're probably logged on as a windows user. You could do some extra checks for that in the Windows Login table (2000000054).
  • yukon
    yukon Member Posts: 361
    Hi,

    Thank 4 your reply. Now i got it. We can check at session table.

    Best Regards,
    Yukon
    Make Simple & Easy

Categories