Open the same native database on 2 clients on 2 machines

vandang

Dear experts,

I have 2 clients on 2 machines and placed the database at one pc. Then shared this folder for using by 2 clients on 2 machines. It happens on 50 sp1, when I try to open the database from CSIDE client at one pc, then I can't do the same at another. I read the guideline in viewtopic.php?f=23&t=30609&view=previous but they just mention about the mutiuser on the same pc. So what could we find the solution for this case.


Best Regards

slmaluwa

Install native NAV server on one PC and allow others to access it. This way, you can scale up also.

vandang

Thanks for replying,

I already installed NAV Database server on PC, I think to solve this problem we need to installl 2 NAV Database server on the same machine. Could you explain more about how to setup/install NAV Database server to solve this problem. Thanks!

vandang

Just followed the useful steps here : http://www.mibuso.com/howtoinfo.asp?FileID=10. But how to let the other client on the other machine know this NAV DB?..
Thanks Alain Krikilion (alias kriki) for the article!

Sog

native database
when you use the direct path to the databasefile. it is open in single-user mode.
When a NAV database server is running, it is set-up with a path to the databasefile. and multiple users can select the same instance of the database server to connect to the same database.
There is no need to install a database server for each user.

The other clients pc will not discover the database server, however, when you use ip:port/+instance or computername:port/+instance, the 2nd client can connect

vandang

Sog wrote:

native database
when you use the direct path to the databasefile. it is open in single-user mode.
When a NAV database server is running, it is set-up with a path to the databasefile. and multiple users can select the same instance of the database server to connect to the same database.
There is no need to install a database server for each user.

The other clients pc will not discover the database server, however, when you use ip:port/+instance or computername:port/+instance, the 2nd client can connect

Thanks Sog,

let me clarify each parameter you point out:

ip: 192.168.0.100
port: 2407
instance: ??? please tell where I can get this one

so the completed path in my NAV client now is 192.168.0.100:2407/????? and placed it on the Server Name field

slmaluwa

vandang wrote:

Thanks Sog,
let me clarify each parameter you point out:

ip: 192.168.0.100
port: 2407
instance: ??? please tell where I can get this one

so the completed path in my NAV client now is 192.168.0.100:2407/????? and placed it on the Server Name field

I don't see why this is so much complicated. if you have NAV native server properly installed, then it is a matter of opening CSIDE Client on the client machine (hope there is a network connectivity in place),
select File-->Database-->Open and in the open database windows:
enter NAV Server pc IP address in "server name", select the appropriate "Net Type" under Advance tab (most of the time, it will be TCP). If you have defined a username and password in the database, enter them also. Click OK to open the database in client.

vandang

Thanks you slmaluwa very much, follow your guideline I can solved it!