What are the general steps about installing DBMaker Client and DSN on Windows platform manually? (From DBMR1783; Version: DBMaker 4.16)

~ 0 min
2016-03-07 11:05

Generally, there are 4 steps to install DBMaker client and DSN; they are as following (take DBMaker 4.16 for example)

Step1: Copy Filesinsure the following files must be exist in the correct directory.

Directory

files

Windows home directory

(Such as C:\Windows\, C:\Winnt)

dmconfig.ini

dmerr41.tab

DMSQL.INI

Windows system directory

(Such as C:\Windows\system32\, C:\Winnt\system32)

dmapi41.dll

DMSQL.INI

(DBMaker Home directory)

\4.1\

COPYRIGHT

EVALUATION

grammar.sql

README.TXT

(DBMaker Home directory)

\4.1\bin\

dmdttut.dll

dmjdbaut.dll

dmjdbc20.jar

dmjdbc20xa.jar

dmjdbc30.jar

dmjsvrut.dll

dmppc32.exe

dmppcc.exe

dmset.dll

dmsql32.exe

dmxtm.dll

dmxtm.jar

dmxtt.dll

dmxtt.jar

expat.dll

icudt22l.dll

icuin22.dll

icuuc22.dll

jcfgditor.ico

jdatatran.ico

jdbatool.ico

jh.jar

jhelp.jar

jmonitor.ico

jsvrmanager.ico

jtools.jar

startup.jar

xerces-c_2_1_0.dll

xtm.ico

xtm.jar

xtt.ico

xtt.jar

(DBMaker Home directory)

\4.1\include\

dmxtm.h

dmxtt.h

eqmacro.h

eqspincl.h

esqlda.h

esqlincl.h

esqlprot.h

esqltype.h

jni.h

jni_md.h

libudf.h

odbc.h

sql.h

sqlca.h

sqlext.h

sqlopt.h

sqltypes.h

sqlucode.h

sqlunix.h

XMLTransfer.hpp

XTMTransfer.hpp

(DBMaker Home directory)

\4.1\jre\

All files

(DBMaker Home directory)

\4.1\lib\

dmapi41.lib

dmxtm.lib

dmxtt.lib

(DBMaker Home directory)

\4.1\ shared\errtab\

dmisql.tab

dmJdbc.properties

dmjtool.tab

(DBMaker Home directory)

\4.1\ shared\codepage\

dmB5LToU.map

dmB5UToL.map

dmCyrillicLToU.map

dmCyrillicUToL.map

dmGBKLToU.map

dmGBKUToL.map

dmGreekLToU.map

dmGreekUToL.map

dmJISLToU.map

dmJISUToL.map

dmLatin1LToU.map

dmLatin1UToL.map

dmLatin2LToU.map

dmLatin2UToL.map

Some tools can directly be used by opening the exe file, such as dmppcc (dmppc32.exe) and dmSQL(dmsql32.exe). But for other JAVA Tools, creating shortcut is used to open DBMaker JAVA Tool.

Create shortcut of JDBATool:

Target: C:\DBMaker\4.1\jre\bin\javaw.exe -classpath startup.jar;dmjdbc20.jar;jhelp.jar;jtools.jar jdba

Begin Location: C:\DBMaker\4.1\bin

ICO: %SystemDrive%\DBMaker\4.1\bin\jdbatool.ico

Step2: Configure dmconfig.ini file

     [DBSAMPLE4]

     DB_PTNUM = 2453

     DB_SVADR = 192.16.0.121   ; address of the server machine

     DB_USRID = SYSADM

Step3: Registry ODBC Driver

[HKEY_LOCAL_MACHINE\SOFTWARE\DBMaker]

[HKEY_LOCAL_MACHINE\SOFTWARE\DBMaker\4.1]

"HOME"="C:\\DBMaker\\4.1"

"COMPILER"=""

"INSTALLTYPE"="Client"

"CURRENTVERSION"="4.1.6"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\DBMaker 4.1 Driver]

"Driver"="C:\\WINDOWS\\system32\\DMAPI41.DLL"

"Setup"="C:\\DBMaker\\4.1\\bin\\DMSET.DLL"

"APILevel"="1"

"ConnectFunctions"="YYN"

"CPTimeout"="60"

"DriverODBCVer"="03.00"

"FileUsage"="0"

"SQLLevel"="1"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers]

"DBMaker 4.1 Driver"="Installed"    

Step4: Registry DSN

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\DBSAMPLE4]

"Driver"="C:\\WINDOWS\\system32\\DMAPI41.DLL"

"Database"="DBSAMPLE4"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]

"DBSAMPLE4"="DBMaker 4.1 Driver"

Average rating 0 (0 Votes)

You cannot comment on this entry

Tags