Open the same native database on 2 clients on 2 machines

vandang · **Joined:** Tue Dec 08, 2009 11:36 am **Posts:** 66

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 · **Posted:** Tue Aug 28, 2012 12:56 pm

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

vandang · **Joined:** Tue Dec 08, 2009 11:36 am **Posts:** 66

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 · **Joined:** Tue Dec 08, 2009 11:36 am **Posts:** 66

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 · **Posted:** Tue Aug 28, 2012 3:53 pm

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 · **Joined:** Tue Dec 08, 2009 11:36 am **Posts:** 66

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 · **Posted:** Wed Aug 29, 2012 6:57 am

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 · **Joined:** Tue Dec 08, 2009 11:36 am **Posts:** 66

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

mibuso.com

Open the same native database on 2 clients on 2 machines

Who is online