Cannot gain access to the file

upasanisandipupasanisandip Member Posts: 405
Hi,
I have installed navision server on the Server & in Database Server folder copied database database.fdb.
I am trying to connect that server from another machine (from client).
Getting following message
The Operating System cannot gain access to the file \\192.168.9.24\c\program files\mbs\database server\database.fdb
Please check that the file type and attributes are correct.

Anyone knows solution abt this.

thanks,
Sandip.

Comments

  • girish.joshigirish.joshi Member Posts: 407
    The navision database and the database server should be running on the same machine (or at least the database should live on a mapped drive, though I have never tried that).
    The server program does not come with a database. If you already have a Microsoft Navision database, copy it to the same computer that your server will be installed on.

    (my italics above)

    make sure that service account that the database server is running as has priveleges to read the file directory location.

    When you connect via the client, make sure you have the client point at the database server not the database itself.
  • mgillmgill Member Posts: 20
    Check the property of the DB,make sure that Read only is marked False
  • andrejsmandrejsm Member Posts: 122
    Edited - deleted, sorry.
    Andrejs Muraskins
  • TOMJTOMJ Member Posts: 1
    Try to specify like this in Server Name ip and access port
    use services to check 10.219.23.70\C$
    for example

    10.219.23.70:3000

    then database name on server for example :
    c:\database.fdb

    It works !

    Best regards :D
  • johnson_alonsojohnson_alonso Member Posts: 690
    edited 2006-07-19
    Dear all,
    What I have successfully done are as follows:
    A. in server computer
    1. install nav. dbase server, set all users can access this computer, set custom, set location for server, set server name:
    LALALA,select TCP, cache 10000 kb, select license file to be personnal license, select database now, next..
    2. from administrative tools, click 2x services and start the mbs navision database server - LALALA --> this is only for services (local){Edit}
    3. from administrative tools, click 2x Datasources ODBC, on tab user DSN, select Navision Database name, then configure. Change Navision Database name to be LALALA, then connection set to be server, and server name is your IP.
    other depends on your database like user ID, password, but beside that, don't fill anything else
    4. OK the windows, then OK the Datasources (ODBC) widows
    5. Go to C:\WINDOWS\system32\drivers\etc, write in host from notepad, your IP <LALALA>, then save it

    6. Run cmd (command), then go to Data server directory, type server.exe then enter.
    7. By now, your navision database is on run
    8. You can access or open the database now from server computer
    . {edit}

    B. In client computer
    5. Go to C:\WINDOWS\system32\drivers\etc, write in host from notepad, your IP <LALALA>, then save it
    6. You can access the database that exists in the server now.

    don't use TCPS, you must use TCP/IP. For more detail write me, I will give you the setup wizard file in detail.


    Rgds,
    Johnson
  • krikikriki Member, Moderator Posts: 9,118
    Check also http://www.mibuso.com/forum/viewtopic.php?t=7479. It is also for only 1 DB on the server.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • johnson_alonsojohnson_alonso Member Posts: 690
    Dear Kriki,
    What I see from your answer is really different than mine, I never set the services, but only host, every clients I write the same host as written in the server computer where database.fdb file stored.
    Another different, you don't use ODBC, my computer uses windows XP 2000 SP2.
    Although different, it runs in mine and I will try your answer. :)



    Rgds,
    Johnson
  • johnson_alonsojohnson_alonso Member Posts: 690
    BlackTiger

    yeah..., I have read it and it's not you that create or design Microsoft Dynamics products, isn't it..?



    :lol: [-X

    Rgds,
Sign In or Register to comment.