Installing XpertMart
™ on a Hybrid Macintosh/PC Network
XpertMart™ will run equally well on either
the Windows™ or Mac™
OS X operating systems. For this reason you can also run XpertMart
™ on a network consisting of a mixture of Mac
™s and PCs.
Currently XpertMart™ is tested to run on any
of the following databases: Interbase™, Firebird
™ (Firebird is a "branch" off of the original Interbase open
source database), Oracle™, PostgreSQL
™ and MySQL™. As shipped, XpertMart
™ runs on Interbase™ on Windows
™ and Firebird™ on Mac
™ OS X.
These instructions tell you how to configure for either Interbase
™ or Firebird™.
When you run XpertMart™ on a network you
install the database server on only one of the machines. All the machines
use the same database server. On a mixed Windows™
and Mac™ OS X network you would either
install Interbase™
on a Windows™ machine
or Firebird
™ on a Mac™ OS X machin
e.
All XpertMart™ needs to know to run on
any kind of network is where the database server and database are located.
If you start XpertMart™ and it does not
know where to find the database server, or the database server or database
is not working properly XpertMart™ will
display this window and message:
If you answer yes to this message then XpertMart
™ will display the File
Configuration
window open to the Database tab
as shown below:
You can also open this window from the Main Menu choosing this option:
Only the entry titled "Database" changes from one machine to other on the
network and from Windows™ to OS X.
The database line actually has three parts to it. There is the designation
of the type of JDBC interface to the databse, the machine which hosts the
database and the file which contains the database.
JDBC Interface to Database
The text "jdbc:firebirdsql:" refers to the JDBC interface to the database.
You use the same text both for Interbase™
and Firebird™ database servers.
Machine Which Hosts the Database
The text "//localhost/" refers to the machine which hosts or has the database
server installed. (The name localhost is interpreted to mean that the database
is on the same machine.) You can put the IP address of the machine here as
in "//192.168.0.34" or the name the machine has on the network such as "//officecomputer/".
The important thing is that the machine which has XpertMart
™ installed can "see" the machine that hosts the database
server. This can be tested via the Ping command in either a command (Windows
™) or terminal (Mac™ OS X)
window. Examples of this are: "ping localhost", "ping 192.168.0.34" or "ping
officecomputer". If the Ping command says it cannot find the specified computer
or address then XpertMart™ will not be
able to find it either. If the Ping command finds computer on the network
then XpertMart™ will also find it.
It is best that the computer's name be only one word and not two or more
words separated by spaces.
NOTE: Interbase™ and Firebird
™ use ports 3050 and 3060 to receive and send information
from and to the database. Make sure your firewall does not block these ports
so that XpertMart™ can work with the database
server.
File Which Contains the Database
The text "C:/Main/Main.gdb" specifies the location of the file on the host
machine that contains the database. On a host Windows™
machine it would begin with the driver letter, on a host Mac
™ OS X machine it would begin with the file root as in this
example: "/Main/Main.gdb".
It is important to note that you specifiy the file which has the database
on the host machine, not on the machine running XpertMart
™. So even though you are running XpertMart
™ on a Mac™ if the database
server is on a Windows™ machine then you
have to specify the drive letter as in: "C:/Main/Main.gdb". Likewise if you
are running XpertMart™ on a PC but the
database server is hosted on an Mac™ OS
X machine then you do not specify the drive letter as in: "/Main/Main.gdb".
Sample Configurations
Database text to point to a database on a Windows™
machine: jdbc:firebirdsql://windowsPCname/c:/main/main.gdb
Database text to point to a database on a Mac™
OS X machine: jdbc:firebirdsql://MacName/main/main.gdb
Copyright
© 2003 Dinari Systems LLC