How to use 32bit Application with DBMaker on 64bit sever? (DBMR: 2106, 2144)

~ 0 min
2016-03-10 07:07

 If user has a 32-bit Program and they would like to install it on a 64-bit Windows server along with DBMaker, since the program is 32-bit and user is not willing to rebuild the program as 64bit or the program can not convert to 64bit, it requires a 32-bit data source, but the OS is 64bit. In this case, if we try to install the DBMaker Driver using the normal setup will failed and face error. But its normal behavior for this error because of DBMaker 32bit Normal version setup can’t work on x64 Environment. However, DBMaker 32bit bundle version can support in x64 OS and access database server via 32bit odbc driver manager. So we can suggest the user to use our 32-bit bundle version to avoid this error occur.

If user’s AP can be compiled to 64bit and they are willing to use the 64bit AP, and they used DBMaker5.1 or above version, they don't need to use our 32-bit bundle on 64bit OS, they can install 64bit normal version directly. Because DBMaker have began to support 64 bit OS from 5.1 version.

The next, we will introduce how to register 32bit bundle driver and DSN on 64bit OS, the detailed steps as below.

(1)Register 32bit bundle driver  

Steps (1) create a new key in the [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\ODBC Drivers] position:

DBMakerName =”Your Driver Name”, for example, you can named” DBMaker 5.1B Driver”

Type=”REG_SZ”

Data=” Installed”

As follows:

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

"DBMaker 5.1B Driver"="Installed"

Step (2) Register “Your Driver” in this position:

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

The ordinary method is create and edit a .reg file (e.g.: DBMaker 5.1B Driver.reg), then import the register-file into the registry. The .reg file’s content as below:

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\DBMaker 5.1B Driver] "Driver"="D:\\bundle\\DMAPI51.DLL"

"Setup"="D:\\bundle\\DMSET.DLL"

"APILevel"="1"

"ConnectFunction"="YYN"

"DriverODBCVer"="03.00"

"FileUsage"="0"

"SQLLevel"="1"

"HOME"="D:\\bundle"

Note: The 32bit ODBC Driver must register to \ Wow6432Node\....

(2) Register 32 bit DSN    

In general, there are two kinds of methods to create 32bit DSN on 64bit OS.

The one is, if dmset.dll exist in you system OS, you can launch odbcad32.exe directly from C:\Windows\SysWOW64\ directory to create DSN and then check the connection.

The other is edit registry directly. Create a .reg file and adds following contents, then import the register-file into the registry.

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

"DBSAMPLE5"="DBMaker 5.1B Driver"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\DBSAMPLE5]

"Driver"="D:\\DBMaker\\5.2\\bin\\DMAPI52.DLL"

"Database"="DBSAMPLE5"

Note: The first “DBSAMPLE5” stand for DSN name and the second “DBSAMPLE5” stand for your DataBase Name, you can give the same or different name for them depend on yourself.

Version: DBMaker All

Product: Bundle

Platform: All Windows

Average rating 0 (0 Votes)

You cannot comment on this entry

Tags