How to connect 2 database on the same Database Server

neramit
neramit Member Posts: 46
edited 2006-11-04 in NAV/Navision Classic Client
All expert,

Now i use native database and i have 2 database on the same database server and i want to connect to both database but i can connect only one database. Can i make more then one connection to database on the same server? if can do please tell me how to do

thank you

Comments

  • ara3n
    ara3n Member Posts: 9,258
    Yes you can have to navision services running on the same box on different ports. Try to search on mibuso on how to install two navision services.
    Basically the process is this. You copy the server folder into a another folder start dos prompt and go to the new folder and run server.exe with some parameters and installasservice.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • kriki
    kriki Member, Moderator Posts: 9,121
    Check this: http://www.mibuso.com/forum/viewtopic.php?t=7479
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • neramit
    neramit Member Posts: 46
    Hi ara3n,

    thank you for your suggestion and i can do it but i can not connect both database in the same time because i cannot start 2 Database server service in the same time too.

    if you have any suggestion please tell me

    thank you.
  • Poltergeist
    Poltergeist Member Posts: 200
    You have to adapt the files hosts en services in c:\windows\system32\drivers\etc (of C:\winnt\system32\drivers\etc, on NT and 2000 systems). First determine wat servername you are going to use (something like test, orso). Open hosts in Notepad. Add to the line saying 127.0.0.1 the choosen servername (in this case test), so the line reads something like

    127.0.0.1 Localhost test

    Save this file. Don't add a fileextension. Now open services with Notepad. Add the line

    test 2408/tcp

    to this file.

    Start a commandprompt (cmd.exe or %comspec). Now go to the directory where you placed the new server files, using the CD command. Type the following line:

    server cache=<value>, commitcache=<YES|NO>, database=<path to database>, servername=text, nettype=TCP.

    It should now start without any problem. You can connect from the client with IPAdres:2408 or <NAME OF THE SERVER>:2408

    If this works, you can simply run the line again, followed with Installasservice. Now a service called test is created, and this can start when the server starts.

    If you want to install more servers, use 2409,2410,2411, etc. You can use any portnumber you like, when it is not used yet.
  • neramit
    neramit Member Posts: 46
    Thank you very much everyone .
    Now i can do it
    \:D/

Categories