Get Navision Databases

pan
pan Member Posts: 3
edited 2005-06-13 in NAV/Navision Classic Client
Does anybody know how can i get the Navision databases in an SQL Server with Cfront ocx.
Something like the form when you go File-Database-Open and you select the database from the Sql Server.

Comments

  • toenne
    toenne Member Posts: 38
    i didn't verify, but maybe you can read them from table 2000000048, but prior you have to open one of the databases......
  • pan
    pan Member Posts: 3
    I 'm try to create a form similar to Database\Open with same functionality.
    I did try to read the server databases from table Database ,but to do this you must open one of the databases first.
    So i need some other way
  • kriki
    kriki Member, Moderator Posts: 9,121
    Check out the different automation-controllers for SQL. Probably one of them will have the possibility to get all the names of the DB's in it. For more info, try the Microsoft-pages.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Arhontis
    Arhontis Member Posts: 667
    You could use the Automation Object:
    'Microsoft SQLDMO Object Library'.SQLServer

    with connect(Sqlservername, username, password) ...

    and then get the databases with the property:
    SQLServer.Databases.Item(...) and other functions...

    That way you will get all the dbs of the server. To show only the dbs of navision you could use the $dbo$property table and check the databaseversionno field to show only the proper Navision version dbs...
    Regards,
    Arhontis

    https://forum.mibuso.com/search

Categories