在Windows平台手动安装DBMaster客户端和DSN通常有哪些步骤?(From DBMR1783; Version: DBMaster 4.16)
一般地,安装DBMaster客户端和DSN有如下四个步骤(以4.16为例):
步骤1:复制文件,确保以下的文件在正确的路径下
路径 |
文件 |
Windows 路径 (如C:\Windows\, C:\Winnt) |
dmconfig.ini dmerr41.tab DMSQL.INI |
Windows 系统路径 (如C:\Windows\system32\, C:\Winnt\system32) |
dmapi41.dll DMSQL.INI |
(DBMaster 根目录) \4.1\ |
COPYRIGHT EVALUATION grammar.sql README.TXT |
(DBMaster 根目录) \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 |
(DBMaster 根目录) \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 |
(DBMaster根目录) \4.1\jre\ |
All files |
(DBMaster根目录) \4.1\lib\ |
dmapi41.lib dmxtm.lib dmxtt.lib |
(DBMaster根目录) \4.1\ shared\errtab\ |
dmisql.tab dmJdbc.properties dmjtool.tab |
(DBMaster根目录) \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 |
But for other JAVA Tools, creating shortcut is used to open DBMaster JAVA Tool.
一些工具能通过打开exe文件直接使用,像dmppcc (dmppc32.exe) 和 dmSQL(dmsql32.exe)。但是对于JAVA工具,要创建快捷方式打开DBMaster JAVA工具。
创建JDBA工具的快捷方式:
目标Target: C:\DBMaster\4.1\jre\bin\javaw.exe -classpath startup.jar;dmjdbc20.jar;jhelp.jar;jtools.jar jdba
开始路径: C:\DBMaster\4.1\bin
ICO: %SystemDrive%\DBMaster\4.1\bin\jdbatool.ico
步骤2:配置dmconfig.ini文件
[DBSAMPLE4]
DB_PTNUM = 2453
DB_SVADR = 192.16.0.121 ; address of the server machine
DB_USRID = SYSADM
步骤3:注册ODBC驱动
[HKEY_LOCAL_MACHINE\SOFTWARE\DBMaster]
[HKEY_LOCAL_MACHINE\SOFTWARE\DBMaster\4.1]
"HOME"="C:\\DBMaster\\4.1"
"COMPILER"=""
"INSTALLTYPE"="Client"
"CURRENTVERSION"="4.1.6"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\DBMaster 4.1 Driver]
"Driver"="C:\\WINDOWS\\system32\\DMAPI41.DLL"
"Setup"="C:\\DBMaster\\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]
"DBMaster 4.1 Driver"="Installed"
步骤4:注册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"="DBMaster 4.1 Driver"