How to verify that the connected database is NAV? (ODBC)

Venezuela

Hello,

I have an application that should read data from a SQL Server Database and the access is with a ODBC conncetion. How can one make sure, that the database is a MS Dynamics NAV database and not something else? Which options are there and which one would you use?

The same solution should work on the last NAV version, but also on 2009, 5.x and 4.x, if possible.

Cheers
Venezuela

kriki

The database should have a table dbo.[$ndo$dbproperty].

Venezuela

oops, it seems that my first reply got lost ... sorry in advance, if there will be a double post

thanks for the quick answer, kriki!
This table is there, and in my installation here it is the very first table listed in SQL Management Studio.
But I would like to add a bit more safety, since with this test it would be possible that the user just adds that table (probably not likely, but ...)
What else would be checkable? Maybe a combination of 3 or 4 things would be great.

kriki

Your first reply was stopped in the moderating queue. From now on, your posts should pass the moderating queue without being stopped.

You can also test if exists:
-dbo.Company
-dbo.[Member Of]
-dbo.[Object]
-dbo.Permission
-dbo.[User]

you can also control if certain fields exist in those tables.

Venezuela

that sounds really good, thanks a lot!