Navigator User Forums
  Navigator 9.0 New Features
  Problem installing 9.0 on a peer-to-peer network

Post New Topic  Post A Reply
profile | register | preferences | faq | search

UBBFriend: Email This Page to Someone! next newest topic | next oldest topic
Author Topic:   Problem installing 9.0 on a peer-to-peer network
FN_User
Member
posted 05-30-2008 11:48 AM     Click Here to See the Profile for FN_User     Edit/Delete Message
I installed Navigator 9.0 on my peer-to-peer network. When I start Navigator, I get an error message “Cannot connect to the database server using connection string
Provider…Data Source=C:\Program Files\FN90\data\fn001.mdb…”
My computer uses the mapped drive letter H: that points to the Navigator files on the server.

IP: Logged

FN_User
Member
posted 05-30-2008 11:49 AM     Click Here to See the Profile for FN_User     Edit/Delete Message
It sounds like you installed Navigator on the computer that acts like a server on your peer-to-peer network. That computer will run Navigator fine with the connection string C:\Program Files\FN90\data\fn001.mdb. When you try to run Navigator on your computer, your computer looks on its local C: drive and of course can’t find any data.

The connection string tells Navigator where to find your data.

To fix this, map a drive on the server and change the connect string.

To fix your installation:.

  1. Create a mapped drive on the server. For instance, map drive H:\ to C:\Program Files\.
  2. Edit fnsql.ini, changing the connection string from C:\ProgramFiles\FN90\data\fn001.mdb to H:\FN90\data\fn001.sql. fnsql.ini is located in the Navigator 9.0 program folder C:\Program Files\FN90.
  3. Edit the Target in the desktop shortcut for Navigator on the server. For instance, change C:\Program Files\FN90\fn90.exe to H:\FN90\fn90.exe.
If you have not installed 9.0 or want to reinstall instead of following the steps above, here are the steps for to install Navigator on a peer-to-peer network.

To install Navigator on a peer-to-peer network:

  1. Share the C:\ProgramFiles\FN90 on the server so everyone has access.
  2. Map drives on all computers, including the server. For instance, if Navigator is in C:\ProgramFiles\FN90, map H: to C:\Program Files\FN90 on the server and H: to {server}\Program Files\FN90 on all the workstations.
  3. Do a full installation of Navigator 9.0 on the server. You should be physically at the server. When asked for the path, use H:\, not C:\ProgramFiles\FN90. This will create a desktop shortcut on the server that runs Navigator from H: and a connection string that also uses H:
  4. Do a Workstation Installation of Navigator on each computer. Be sure to use the correct path (H: for example).

Note: You will have the same problem (and the solution is the same) if you have a real network with a real server and need to run Navigator while you are sitting at the server.

-- David
FNI Technical Support

IP: Logged

All times are PT (US)

next newest topic | next oldest topic

Administrative Options: Close Topic | Archive/Move | Delete Topic
Post New Topic  Post A Reply
Hop to:

Contact Us | Home

Copyright 2010 Financial Navigator, Inc.


Ultimate Bulletin Board 5.47e