list of databases on a server

abtmn
abtmn Member Posts: 27
edited 2006-02-09 in NAV/Navision Classic Client
I'm building a form in navision and would like to access a list of "non-navision" SQL Server databases.

Ultimately, I would like to have the user select from a list of databases. I looked at the Database table...but this only tells you the navision databases. Anyone have any ideas?

Comments

  • ara3n
    ara3n Member Posts: 9,258
    creat a view in sql and link it to navision table. The view will be a list of all the databases on sql
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • DenSter
    DenSter Member Posts: 8,307
    You can't open a non-Navision database in Navision anyway, so it's not a strange idea to only see Navision databases :).

    The application designers guide has all the information you need to create SQL Server views and linking them to Navision.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • ermannog
    ermannog Member Posts: 9
    Excuse me but it possible from an externa application
    have the list of SQL Server Navision Databases?

    The Navision client in the Open Database Dialog show only
    the Navision Database how is possible do it without connect
    to the database (and check for example the tables)?

    I think that the Navision client retrive the info from the master db
    but I not know what check.

Categories