Connecting to the proprietary database from the client

arry_veins
arry_veins Member Posts: 29
edited 2005-12-23 in NAV/Navision Classic Client
I have setup a navision database server on a LAN, and got the clients connecting to the database. Now, what do I do to get clients simultaneously connecting to the server as I am getting the error msg: "You cannot use the file...databse.fdb because it is already in use" when I am getting to connect from another client..

Pls guide.. Thanks

Comments

  • DenSter
    DenSter Member Posts: 8,307
    You have your database file on the network, and someone is just connecting directly to the database file. This way only one session at a time can be connected. You are not connecting through the Navition Database Server.

    You need to install the Navision Database Server, and when connecting to it, instead of browsing to the database file, you enter the server name and then it should find it automatically. Note that when you want to use the name your machine must know how to resolve it, so you need to add the IP address and port number to your hosts and services files. You can always use the server's IP address directly in the server name box when you connect the client.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    There is an installation guide on the product CD.
    Marije Brummel | Freelance Business Central Specialist
  • kine
    kine Member Posts: 12,562
    arry_veins wrote:
    I have setup a navision database server on a LAN, and got the clients connecting to the database. Now, what do I do to get clients simultaneously connecting to the server as I am getting the error msg: "You cannot use the file...databse.fdb because it is already in use" when I am getting to connect from another client..

    Pls guide.. Thanks

    It seems, that you (or someone) are using the "Database Name" field for entering the database instead "Server name" only. You need to not fill the field "Database name", just fill "Server name" with the name of the server PC.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • arry_veins
    arry_veins Member Posts: 29
    I used the server name to connect to the database from the client. I get the following error nessage: "the server does not exist in the hosts file (TCP/Ip error NO_DATA)
    tcp/ip connection cannot find the correct 'host' in your 'hosts' file (TCP/IP error HOST_NOT_FOUND)."

    My hosts and services files are uodated with the navision databse server information. But with the name and ip address of the server, I cannot connect from the client.

    However, I can ping and connect to the shares on the server from my client... so it looks like not a network issus, more of a navision issue which I am not able to resolve.. ](*,)
  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    Have you tried logging on via the IP addres and Portnumber
    127.0.0.1:3001

    Have you also checked the Network protocol tab?
    Marije Brummel | Freelance Business Central Specialist
  • arry_veins
    arry_veins Member Posts: 29
    I am trying to do a databse>open from the client...............
    so in the server name, I am putting \\servername
    and there is the advanced tab - where i use tcp as the protocol...... no luck


    is it not the right way to connect to the server from the client?
  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    \\servername is not correct

    It should be either just the servername, the name in you Hostfile or the IP address

    Don't put in any slashes.
    Marije Brummel | Freelance Business Central Specialist
  • arry_veins
    arry_veins Member Posts: 29
    with the ip address in the servername filed in database open window, the same error is coming.
  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    Have you installed a client on the server?

    You can try this and log into localhost. If this is not working the problem is on the server, if it works the problem is on the client.
    Marije Brummel | Freelance Business Central Specialist
  • arry_veins
    arry_veins Member Posts: 29
    connecting to the server without the slashes gives this weird error: teh operating system cannot find the file fin.flf.

    On the server, I do have the client (for the databse.fdb file)... and in that machine, when i use localhost as the server, i get the tcp/ip error: ECONNRESET error.
  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    The flf error probably means that there is no licence on the server.

    Have you checked if there is a correct license in the Navision Server directory?

    What do you mean by having a client for the database file? What do you think this is nessesairy for?
    Marije Brummel | Freelance Business Central Specialist
  • arry_veins
    arry_veins Member Posts: 29
    the licence file is there in the server directory, still i get the error.
  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    I hate to ask...

    Is the name of the license fin.flf?
    Marije Brummel | Freelance Business Central Specialist
  • arry_veins
    arry_veins Member Posts: 29
    actually fin.flf is there... i get a ECONNRESET error, it asks me to start client, server or check tcp/ip setup.. any ideas???? ](*,) ](*,) ](*,)
  • JulianHarper
    JulianHarper Member Posts: 63
    Do you have any firewalls running on the server?
    Julian Harper
    IT Manager
    Laytons Wine Merchants Ltd
  • ecclectic
    ecclectic Member Posts: 176
    are u sure u usin tcp? see connections
    can u pin server
  • arry_veins
    arry_veins Member Posts: 29
    Hey Mark -

    thanks to you - the license file was not there in the server directory and as u said i tried using without the slashes... bingo!!! =D>

    merry christmas.
    :D

Categories