License Problem with Navision ODBC

ta5
ta5 Member Posts: 1,164
edited 2006-10-17 in NAV/Navision Classic Client
Hi
It seems that a valid license file (not the one for Cronus) has to be stored in the odbc installation folder.
This is quite a surprise for me, because in this case the license files have to be distributed to the client computers. As far as i understand, a normal Navision client can start with any license file and uses the real license file after connecting to the db server :?

Versions: Navion 4.01

Thanks in advance

Thomas

Comments

  • NR
    NR Member Posts: 78
    Go throught the following factors :

    1. The license must include the granule for C/ODBC. This will allow access to Navision data through C/ODBC.

    2. Also the System permission for C/ODBC object at the user level must be assigned. This will allow access from outside application like MS Excel, MS access to Navision.

    Put your query more precisely if this not answer your query.
  • ta5
    ta5 Member Posts: 1,164
    Thanks for the answer. Sorry, it was not very clear.
    The question is actually: why is a license file needed on the client, even if connection is made through db server?

    Thomas
  • NR
    NR Member Posts: 78
    To my knowledge, the license file is not required on the client if it has been imported on the Navision DB server.
  • ta5
    ta5 Member Posts: 1,164
    Yes, quite strange.
    Anyway: If I connect through a normal client (without custom license) it works fine. The license was uploaded to the server and this license is used by the client.

    If I connect through ODBC I get the ffw error:
    Your program licens permits a maximum of 2 nondemonstration companies. Contact the system manager if you need to set up additional companies. You can, however create an unlimited numer of demonstration companies. Their names must start with "CRONUS".
    Database Error: 1228
    Drivers's SQLSetConnectAttr failed.

    Any ideas?
  • NR
    NR Member Posts: 78
    Check out the DSN created for C/ODBC driver. There is an option to specify the license file. See whether it is pointing to the customer license file. If its blank, it usually picks up the license from the database it is connecting to.

    Which application are use using to connect to Navision through C/ODBC?
  • ta5
    ta5 Member Posts: 1,164
    DSN Setup: Does not point to customer file.

    The only flf-file in c:\program files\shared\navision\nodbc\ is cronus.flf.
    If I add the customer license to the path above it works fine.
    But actually I want to avoid copying license files to client computers.

    I connect with Excel.

    Thanks
    Thomas

Categories