Category : Paradox DBMS
Archive   : TECH91.ZIP
Filename : TI620.ASC

PRODUCT : Paradox NUMBER : 620
VERSION : 3.5
OS : PC DOS
DATE : September 11, 1991 PAGE : 1/4

TITLE : Connecting to IBM EE Database Manager




TROUBLE SHOOTING COMMON INSTALLATION PROBLEMS CONNECTING TO IBM
EE DATABASE MANAGER:

If you run into problems when you first use Paradox SQL Link with
the IBM EE Database Manager, try to isolate the problem. (The
Database Administrator must perform these tasks, keeping the
needs of other applications in mind.)

-> Make sure that the server was installed to support remote
database access. One way to verify this is to install
another OS/2 machine and run the Query Manager.

-> Verify that the network layer is functioning by trying to
share files and print jobs to the spooler.

-> If you are using LAN Server and cannot connect, check to see
that your network software is running. If DOS workstations
can access a shared directory on the server, then you have
the correct drivers loaded and you know your hardware is
working properly.

-> If you're using a Token Ring network, verify that your
CONFIG.SYS contains the following lines:

DEVICE=C:\SQLIBM\DXMA0MOD.SYS
DEVICE=C:\SQLIBM\DXMC0MOD.SYS
DEVICE=C:\SQLIBM\DXMTA0MOD.SYS S=12 C=14 ST=12

If you're using an Ethernet network, verify that your
CONFIG.SYS contains the following lines

DEVICE=C:\LANMAN\PROTMAN.EXE
DEVICE=C:\LANMAN\ELNKII.DOS
DEVICE=C:\LANMAN\DXMA0MOD.SYS 045
DEVICE=C:\LANMAN\DXME0MOD.SYS
DEVICE=C:\LANMAN\DXMT0MOD.SYS

You can use the configuration program (DXMAID) to configure
your workstation properly and to copy the correct drivers to
your hard disk.

DXMTOMOD.SYS (the NETBIOS device driver) can have serval
parameters. The most common parameters are listed here:














PRODUCT : Paradox NUMBER : 620
VERSION : 3.5
OS : PC DOS
DATE : September 11, 1991 PAGE : 2/4

TITLE : Connecting to IBM EE Database Manager




-> S = Sessions

Indicates the maximum number of NETBIOS interface
sessions that you can define.

-> C = Commands

Indicates the NETBIOS interface commands that can be
outstanding at one time.

-> ST = Station


Indicates the maximum number of NETBIOS workstations you
can define. If this number is too large (default is 16),
you will not be able to connect to your network.

-> If you are starting the LAN Requestor, check the parameters
in IBMLAN.INI (the OS/2 LAN Server initialization file) as
described next, and allow access for the increased number of
workstations. The following lists the section in IBMLAN.INI
that affects how the workstation connects. You should ask
your Database Administrator for assistance with these
parameters, or refer to your IBM EE DBM manuals for a full
explanation.

-> [networks] (The information in this section of IBMLAN.INI
is read by the redirector at device initialization.)

NET1 = NETBIOS$, 0, NB30, 32, 32, 16

The fourth and fifth parameters affect how Paradox SQL
Link connects.

The fourth parameter, 32 is the number of NETBIOS
sessions the requestor allocates from the Communications
Manager configuration file. Changing this value
increases or decreases the maximum number of connections
(a connection can be a logon or a NET USE).

The fifth parameter, 32 is the number of simultaneous
NETBIOS commands. Changing this value can increase or
decrease the number of requests the LAN requestor can














PRODUCT : Paradox NUMBER : 620
VERSION : 3.5
OS : PC DOS
DATE : September 11, 1991 PAGE : 3/4

TITLE : Connecting to IBM EE Database Manager




process at once. The default value is 32 for a server or
16 for a requestor that NETBIOS names. Decreasing this
value means sharing fewer resources and adding fewer
messaging names. Increasing this number means sharing
more resources.

-> Make sure you specify the correct server name on the
Tools|SQL|Connecting|Select screen. If you are using the
Query Manager on your server, the server name is the
workstation name shown on the Tools|Reconfigure screen in
the Query Manager.

-> A codepage is a table that defines a coded character set
for a language or country. To find the active codepage
on your server, type chcp at the OS/2 prompt. Paradox
returns a remote database error if you try to use a
database that was created under a different codepage than
the one currently set. You must modify your CONFIG.SYS
if the Query Manager's codepage specifies a different
number that the one on your workstation.

-> Verify that the Database Manager and all corresponding
pieces are installed on your server by entering the
command syslevel at the OS/2 prompt. IBM EE returns the
version number, the location on all installed elements,
and the names of all installed elements. Here's a sample
report:

C:\0S2\INSTALL\SYSLEVEL.OS2
IBM 0S/2 Base Operating System

C:\CMLIB\SYSLEVEL.ACS
IBM OS/2 Communications Manager

C:\SQLLIB\SYSLEVEL.SQL
IBM OS/2 Database Services

C:\SQLLIB\SYSLEVEL.QRW
IBM OS/2 Query Manager

C;\MUGLIB\SYSLEVEL.MUG
IBM OS/2 User Profile Management














PRODUCT : Paradox NUMBER : 620
VERSION : 3.5
OS : PC DOS
DATE : September 11, 1991 PAGE : 4/4

TITLE : Connecting to IBM EE Database Manager




C;\DBDRQLIB\SYSLEVEL.PDR
IBM OS/2 DOS Database Requestor

C:\IBMLAN\SYSLEVEL.REQ
IBM OS/2 LAN Requestor

C:\IBMLAN\SYSLEVEL.SRV
IBM OS/2 LAN Server - Version 1.2

-> If you're using the DOS LAN Requestor, verify that your
AUTOEXEC.BAT file contains the following lines (some
parameters differ based on your environment):

PATH=C:\;C:\DOS:C:\SQL\BIN;C:\SQLIBM;C:\DOSLAN;
YNPROMPT Y N 30 START DOS LAN REQUESTOR (Y/N)?
IF ERRORLEVEL 1 GOTO NODLR
NET START
IF ERRORLEVEL 1 GOTO NODLR
CALL INITFSI.BAT
:NODLR
NET LOGON JSMITH JOE
C:

-> Use the Query Manager to verify that the database is
running.

-> Finally, try using hardware diagnostics to make sure your
network card works.

-> For more information on IBM tools, see you IBM EE DBM
documentation.