Connecting to the proprietary database from the client

arry_veins

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

DenSter

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.

Marije_Brummel

There is an installation guide on the product CD.

kine

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.

arry_veins

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

Have you tried logging on via the IP addres and Portnumber

127.0.0.1:3001

Have you also checked the Network protocol tab?

arry_veins

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

\\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.

arry_veins

with the ip address in the servername filed in database open window, the same error is coming.

Marije_Brummel

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.

arry_veins

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

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?

arry_veins

the licence file is there in the server directory, still i get the error.

Marije_Brummel

I hate to ask...

Is the name of the license fin.flf?

arry_veins

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

Do you have any firewalls running on the server?

ecclectic

are u sure u usin tcp? see connections
can u pin server

arry_veins

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.