Database in use !

jesnet

Hope someone can help - I will try to make the problem description short.
1. have license for 2 users
2. client can open 2 copies - no problem (running tcp)
3. server can start 2 copies - no problem
4. if one copy started on client - can't start a copy on server (database in use message)
5. if one copy started on server - can't start a copy on client (database in use message)

Regards and thanks
Bent in Denmark

Slawek_Guzek

What do you mean by 'server can start 2 copies?' Are you talking about native NAV server or about databases hosted on a SQL Server?

Also - what do you mean by the 'copy started on client'. Is it again a NAV database service started on the client, or the database is hosted on client's local SQL Server, or you are trying to open the fdb files in the client directly?

jesnet

Hi Slawek
The database is hosted on a sql server. The program is always started on the server, either directly or via tcp (Intranet). Hope this makes it more clear.

Slawek_Guzek

The databases (two copies) are on the SQL server. That's clear now.

But "The program is always started on the server, either directly or via tcp (Intranet). " is not, frankly speaking..

Anyway - since your databases are hosted on the SQL Server NAV checks licenses bases on number of sessions on the SQL Server openened form NAV clients. If you have 2 users in your license you can have 2 concurrent connections per server (or more precisley per SQL Server instance) - no matter what database clients are connected to, and where the client is running.

Could it be that one client is connected to one database and you try to connect 2 more to another database?

jesnet

The problem is solved - turned out that the NAVserver was not running !

RemkoD

-is puzzled- That doesn't explain the 'database in use message' yet. Well, I'm glad for you it's solved!

Savatage

If the Navserver was not running then the client was opening the database directly. If that's the case you can only open it once.