What are the general steps about installing DBMaker Client and DSN on Windows platform manually? (From DBMR1783; Version: DBMaker 4.16)
Generally, there are 4 steps to install DBMaker client and DSN; they are as following (take DBMaker 4.16 for example)
Step1: Copy Files,insure 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"