H
How can I access DBMaker if I didn’t register the DSN?
If you didn’t register the DSN ,you should use indiscriminately the following connection string when you use ADO:
strConn="Driver=DBMaker4.1Driver;DATABASE=Dbsample4;SvAdr=192.168.0.164;PtNum=8888;UID=sysadm;Pwd=;ATCMT=1;"
You ...
How does the inside of the DBMaker deal with when insert BLOB data repeatedly? Does it share the BOLB data when the inserted BLOB data is same?
DBMaker will store only a single LO and share it between the tuples, If the same LO data is contained in many tuples. But that ...
How to deal the error handling in VC program when there appear SQL_ERROR or SQL_SUCCESS_WITH_INFO?
It needs the program to do the estimation. If the SQLCODE=-1. It should write thecode to deal with the error handling. The sample code is too ...
How to deal the error handling in VB program when there appear SQL_ERROR or SQL_SUCCESS_WITH_INFO?
It uses adodb.sqlerror object instead of err object to get the native errors from the DBMaker for that err object can’t get the native error ...
How to decide the value of the FILLFACTOR?
Deciding appropriate FILLFACTOR is very case-dependent. Here are some rules of thumb.
If a table fits one of the following criteria,
set a larger FILLFACTOR for ...
How to change the file extension of SFO in PHP program?
Following is the sample:
$conn=odbc_connect("nba","SYSADM","");
if($conn)
{
error_reporting(0);
odbc_do($conn,"drop table php_fotest");
error_reporting(7);
$res1=odbc_do($conn,
"create table php_fotest(c1 int,c2 file)");
if($res1){
$res=odbc_prepare($conn,
"insert into php_fotest values(?,?)");
odbc_exec($conn, ...
How to migrate the database from 3.x to 4.x?
You can use the Unload/load commend to implement the migration, i.e. first unload the database from 3.x, and then load it to the 4.x. following ...
How to confirm deamon of auto update statistics working(is there anything shown on process)?What is the trigger to let update statistics work(like how many records insert into table)?
The statistics daemon launch at 3:00 am automatically if the DB_SVRST = 1 is set on dmconfig.ini when database start up. Customers can view whether ...
How does DBMaker deal with the delete command?
In DBMaker, every record has a structure, DBMaker just mark one of them to ''delete'’ flag, the data still exist in page (customer cannot see ...
How to investigate the reason if face deadlock problem? (From DBMR1703, version: DBMaker 4.1.2, OS: Windows XP Embedded SP1)
To investigate the reason, you should monitor lock first, for example, as the following:
dmSQL> select USER_NAME, TABLE_NAME, SYSLOCK.LK_OBJECT_ID,
SYSLOCK.LK_GRAN, SYSLOCK.HOLD_LK_CONNECTION, SYSLOCK.LK_CURRENT_MODE
from SYSLOCK, SYSTEM.SYSTABLE, SYSUSER where HOLD_LK_CONNECTION ...
How to collect the Database system information? (Form as the above)
Generally, when users across problem, they need to analyze the database system information before the problem occurs and when it occurs. So user needs to ...
How to insert data that contain single quotes into NCLOB column?(From DBMR1711)
The NCLOB data type is a variable length data type that can contain any Unicode character.When entering NCLOB data, it needs to enclose the Unicode ...
How is the ALTER TABLE statement treated by DBMaker internally? (From DBMR1740)
1. Before DBMaker 4.1x (include 4.1x) series, 'ALTER TABLE' statement should copy another internal table (select into), so it occupies double disk space and writes into journal ...
How to disconnect the useless sessions? (From MR1809)
To disconnect the connection automatically, DBMaker supports two keywords DB_ITimO and DB_DtClt.
The keyword DB_ITimO is used in Server side. DB_ITimO specifies the idle timeout interval, ...
How to check the status after starting DB with NT Service,and how to do when the service is on but the connect fail sometimes? (From DBMR1832)
After starting DB with NT service, the DB is in the middle of starting with creating Journal, at present, only journal file is increasing and ...
How to make effective use of memory, does it need changing some settings? (From DBMR 1839)
There are many factors effect performance, such as Hardware, OS, Database system, Application system.
For database factors, there are also many factors. Performance is decided by ...
How to avoid garbage character for following situation when use the character set UTF-8 in Web system? (From DBMR 1847)
1. Web AP insert/select UTF-8 data.
2. Web AP insert data and update the data by Ms Access and so on.
3. MS Access or dmSQL insert data into DB and Web AP select the data.
1. Web AP operating UTF-8 data is no problem, DBMaker only support U16LE.
2. If storing data as nclob/nvarchar/nchar, customer can use MS Access to access ...
How to use the NCHAR (unicode) data type for host variables in ESQL/C?
Please check esqltype.h has defined NCHAR like below:
typedef char nchar; /* for unicode #004 */ typedef varchar nvarchar; /* for unicode #004 */ typedef longvarchar ...
How to backup/recover DB with zip/unzip function by command? (From DBMR 1846)
DBMaker only compress the full backup files, incremental backup will not be compressed because the incremental backup file is smaller and compress it may cause ...
How to use ESQL/C stored procedure in 4.3.3 bundle version? (DBMR 1912)
Suppose the HOME directory is: C:\dbmaker\43bundle.
It will use some folders and files in 4.3.3 normal version, so user needs to copy them to related bundle ...
How to use Java stored procedure in 4.3.3 bundle version? (DBMR 1912)
Suppose the HOME directory is: C:\dbmaker\43bundle.
Workaround for building Java sp with 4.3.3 bundle as follows:
(1) Copy jre folder from normal to bundle (C:\dbmaker\43bundle\jre)
(2) Copy dmclassloader.jar ...
How to set DSN for dbmaker4.3 bundle on 64bit? (DBMR: 1911, version: DBMaker 4.3 bundle)
TheOther settings are same with 32bit OS except two points:
(1) user should register DBMaker4.3 and ODBC Driver in
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node] in regedit.
Node (Wow6432Node) is used to register ...
How long does it take for full backup of 100G database? (Both zip and no zip) (DBMR 1935; version: DBMaker bundle 4.3.3)
There are about 2 factors that will affects the full backup time, they are:
Data type: When doing full backup with zip, compressed situation is different ...
How does DBMaker act if network disconnection happens during inserting process? (DBMR 1945)
If the network disconnection happens during inserting process, the current disconnected connection may remains on server and the session still occupied the resource. The session ...
How to successfully create stored procedure from 03mail.ec which is installed with DBMaker samples in the StoreProc folder? (Version; DBMaker 4.3)
For using 03mail.ec correctly, user needs to link wsock32.lib:
First, Modify templates\vc60.mak as follows:
LINK32_FLAGS=wsock32.lib C:\DBMaker\4.3\lib\dmudf.lib
Then, create procedure from 'C:\dbmaker\4.3\samples\StoreProc\03mail.ec';
It will be ok. ...
How to export data to CSV file from DBMaker?
DBMaker supports the export function; user can refer the chapter 7.1 of Backup Restore Guide42.doc for detail. ...
How to hide the dmsql tool window to final user?
To hide the dmsql window, developer can add the following command to script file.
d:\dbmaker\5.0\bin\dmSQL32.exe /b
The parameter /b can help to hide console, then remember to add ...
How to backup and restore database with online full backup in bundle version? (DBMR1973; version:DBMaker bundle 4.3.4)
There are two methods to backup and restore database in bundle version.
The one is using the Jserver Manager tool, but if they only installing DBMaker ...
How to use OID in the program? (DBMR1974; version:DBMaker 4.2 in Linux)
The OID is a special data type. Although it is possible to use an OID in a query to select data from a table and ...
How to use DBMaker function TO_DATE (string_expr, date_format_string)?
TO_DATE (string_expr, date_format_string) is used to convert a selected string to DATE format. The selected string can be of any data type, but it must ...
How about DBMaker 5.1 support English / simplified Chinese / traditional Chinese error message issue?
add db_errlcode keyword in dmconfig.ini of client site
English: DB_ERRLCODE = EN.ASCII
Simplified Chinese: DB_ERRLCODE = ZH_CN.GBK
Traditional Chinese: DB_ERRLCODE = ZH_TW.BIG5
The client connection will check DB_ERRLCODE setting ...
how to avoid garbage character problem with UTF8 DB in php program? (DBMR: 1977)
The reason is data in the php pages was UTF-8 encoding. When the data was sent to driver manager, driver manager found the DBMaker supported ...
How to check the database situation from error message and find the solution when LOCK TIME-OUT occurs?
1) Check error message:
Lock time-out is normal behavior for Database, the cause of Lock time-out is waiting time beyond the maximum time setting when competition ...
How to connect to Server from Client in PHP program with DBMaker? (DBMR2016)
For PHP programs connect to DB, we usually just need to set ODBC data source, then connect through DSN name. For example: $Conn =odbc_connect (“DBSample5”,”SYSADM”,”xxxxx”);
If ...
How to avoid “ERROR (6101): allocated too many command handles”(DBMR: 2017)?
Applications can allocate 257 statement handles in one connection by default. The error will be return when statements reached database limited value.bescause Create Statement but ...
How to avoid connect error from client to server when database started by dmservice?
Install DBMaker Server and Client in different computers. Start db by dmservice in Server and connect to db from Client. If connect failed, you can ...
How to avoid Lock time-out occurs when different applications access the same table in database with different operations simultaneously? For example, unload and other DML operations occur simultaneously. (DBMR2123)
Locks are required for concurrency control between multiple transactions on the same database objects. Lock time-out will be occurring when multiple users access to one ...
How to avoid line wrap if the column data contains return code after execute EXPORT command and output to CSV data file? (DBMR: 2126)?
There is incorrect handling result output to CSV file if the column data which contains return code when execute “Export command”; i.e Table has only ...
How to get indexed column name of table from SQL by VB6.0 OR 2005 with ADODB connection? (DBMR2040)
The SQL cannot get indexed column name directly, it should parse multi-SQL to get. First, get num_column, reserve3 from system.sysindex, second, from above result then ...
How to avoid error: 10851 - invalid value in configuration file when database creation on 5 series reference old 4 series configuration setting on DB_USRBB? (DBMR: 2106)?
When customer upgrade database from 4 series to 5 series, the customer should create an empty 5 database firstly. If customer copy same database setting ...
How to avoid “Failed to start Service for
DBMaker with 11206 Error in restarting OS” (DBMR: 2111)?
We want to use Windows Service to start DB but the DB can’t start automatically when restart OS and ‘11206’ - cannot create/open a file ...
How about page compress operation internally? (DBMR: 2081, DBMR: 2132)?
Page compress will lock the whole page forcedly and escalate lock to page if lock granularity less than page lock, but higher lock granularity have ...
How to get the DEADLOCK error message (DBMR: 2081)?
In order to get more useful information for DEADLOCK we can set some keywords in dmconfig.ini file to trace. Detailed setting for NEW log system ...
How to start/ stop dmserver and how to check dmserver status in redhat linux?
we can put DBSAMPLE5 as a sample in this case.
1. The methods for start and stop dmserver in Linux as follows:
1) startup dmserver:
/home/DBMaker/5.2/bin/dmserver DBSAMPLE5
2) stop ...
How to use 32bit Application with DBMaker on 64bit sever? (DBMR: 2106, 2144)
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 ...
How to use COPYTABLE to duplicate a new table from old ones? (DBMR: 2136)
We can use call stored procedure “CALL COPYTABLE ()” to duplicate a new table based on an existing table. The usage as below:
COPYTABLE(VARCHAR(32) source_schema_name INPUT,
...
How to avoid the error: 18065 that cannot read codepage file?
We can make sure the Client Driver can read the codepage (Bundle\shared\codepage\xxxx.map) first, and can duplicate the error after dropping all the .map files.
For example: ...
How to avoid the problem that user have installed and activated DBMaker in a Windows VM which is in evaluation, after activating Windows VM, DBMaker didn't start anymore and reports the “invalid license” error?
We installed a licensed copy of DBMaker 5.2 in a Windows VM during Windows VM's evaluation period. After activating Windows VM, DBMaker reports that the license ...
How to avoid error 5388 when user use DBMaker Bundle version?
If we have a COBOL program and want to access DBMaker (bundle version) with DCI in Linux, we need to build the runcbl runtime first, ...
How to avoid WARNING63 while migrating db from DBMaker4.1 to 5.2?
User wants to migrate db from 4.1 to 5.2 and they unload DB from DBMaker4.1, and then try to load db to 5.2, but Warning63 ...
How to avoid the use of high-frequency characters 3?
First, user should backup the file tw.tab which located in c:\dbmaker\4.3\shared\stopword\ tw.tab, then open tw.tab and delete following contents.
0
1
2
3
4
5
6
7
8
9
10
After that, rename tw.tab to stopword.tab.(xx.tab user ...
How to make the MFCOBOL Compatible with Visual COBOL?
We found some errors (such as “Not support N type in Visual Cobol “,” 114 Error”) will be faced when compile COBOL PROGRAM after replace ...
How does make the collating order file as word sort order for Japanese? (dbmr2178)
About collating order, DBMaker work with default binary sort order.
if user want to use other Language as an option, should create an order file which ...
How to avoid the limitation when the situation multi-thread uses same connection handle to call server function (DBMR2299)?
Some unexpected behaviors (such as: hung-up) will be faced when multi-thread use same connection handle to call server function. we can set DB_MTIMO to solve the ...
How to avoid the double reading problems when read data from Long Varchar type by ODBC in DBMaker5.2?
Insert a large quantity of pure text data into a column which is Long Varchar type, and then read the contents with JDBATool, the query ...
How to allocate pages for tables or indexes in DBMaker? (DBMR2238)
When a table is created, the number of pages allocated for it depends on the number of columns, the column type and table header information ...
How to make C compilers available which are installed after DBMaker’s installing previously? (DBMR2252)
Suppose a user had installed DBMaker without installing C compilers previously and now he want to install C compilers for the installed DBMaker, for parts ...
How to send mail to DBA immediately when DMERROR.LOG is updated? (DBMR2257)
Once DMERROR.LOG is updated, DBMaker will immediately send DBA an email of which the content is “Please see the alter message in C:\DBMaker5.2\DMERROR.LOG”. (“C:\DBMaker5.2\DMERROR.LOG” will ...
How to start or stop a NT service for a database? (DBMR2260)
Answer2: The command “net start ServiceName” is used to start a NT service and the command “net stop ServiceName” is used to stop a NT ...
How to get view definition from database? (DBMR2327)
There are two SQL statements in DBMaker used to get view definition. One is “def view view_name”, and the other is “select cast (view_definition as ...
How to move a table and its indexes into another tablespace with simply commands? (DBMR2363)
From DBMaker5.3, DBMaker supports the command “ALTER TABLE table_name MOVE TABLESPACE tablespace_name” used to move tables and its indexes into another tablespace. Users can’t access ...
How to create/rebuild indexes for tables created by other users for SYSADM? (DBMR2372)
To create/rebuild indexes for tables created by other users, SYSADM should add the table owner’s name before the table name rather than the index name.
For ...
How to migrate the DBMaker4.3 database from Windows to Linux? (DBMR2384)
For the file system among versions that belong to the same series of DBMaker is compatible, users can only copy data files into Linux and ...
How to ensure the DB can be shutdown normally (which can shorten the starting period next time)? (DBMR2517)
If the database is shut down due to abnormal events of system, it may take much time to restart dmserver. The reason is that, to ...
How to insert NULL into a field with data type CHAR in DBMaker via DCI in a COBOL program? (DBMR2557)
The following three configuration variables are used to insert NULL into a field with data type CHAR via DCI.
DCI_NULL_ON_SPACE_CHAR
DCI_NULL_ON_ILLEGAL_DATE
DCI_NULL_ON_ILLEGAL_DATA
In addition, users can ...
How to use DCI_WHERE_CONSTRAINT under MF COBOL 4.1 on Linux? (DBMR2553)
From the end of January 2014, DBMaker DCI begin to support DCI_WHERE_CONSTRAINT. Users can use it by calling DCI_SET_WHERE. If want to use DCI_WHERE_CONSTRAINT under ...
How to solve the error “dmserver cannot be connected or started when DB_UMODE=0”? (DBMR2612)
For old DB versions, DB_UMODE may be changed to 0 and cannot be reset to 1 even after restarting in some situations, for example: OS ...
How to investigate the causes of ERROR (6590) while creating Stored Procedure? (DBMR2613)
1.Check <procedure_name>.msg, and according to the massage which included in it to investigate reasons.
2. If <procedure_name>.msg is empty, check the sp32.bat.
First, check whether the version ...
How to create a table replication in one same database? (DBMR2758)
Generally, table replication is applied between different databases. However, it also can be used in one same database.
There are two ways:
First, use Create Replication syntax. ...
How to avoid the infrequent error "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified." in the process of a WEB application accessing ODBC? (DBMR2740)
In the application, users can replace “DSN=XXXXX” with “"Driver=DBMaster 5.x.x Driver” in ODBC Connection String to avoid this error, for example, ODBC Connection String="Driver=DBMaster 5.x.x ...
How to use foreign keys when a COBOL program accesses DBMaker with DCI? (DBMR2780)
In order to use foreign keys when a COBOL program accesses DBMker with DCI, users should ensure that the xml file matches the table.
Users need ...
How to check the running state for all of DBMaker's background processes on Linux? (DBMR2777)
DBMaker has 3 base processes on Linux: BACKUP_SERVER, SERVICE_SERVER and IO_SERVER. Users can use the following SQL statement to confirm the process id (the process ...
How to use the date in the format of "dd/mm/yyyy" or "dd-mm-yyyy" in DBMaker? (DBMR2773)
Users set DB_DaoFm in dmconfig.ini to control the date output format. Now DBMaker supports the following date formats.
mm/dd/yy
mm-dd-yy
dd/mon/yy
dd-mon-yy
mm/dd/yyyy
mm-dd-yyyy
yyyy/mm/dd
yyy-mm-dd
dd/mon/yyyy
dd-mon-yyyy
dd.mm.yyyy
DBMaker doesn't support "dd/mm/yyyy" or "dd-mm-yyyy", but users ...
How to avoid ERROR (6534) when create a database by JServerManager Tool with old bundle version on Windows? (DBMR2490)
This error is caused by the conflict between libxml2.dll of JAVA7 and that of DBMaker. To avoid this error, users need to change the name ...
How to avoid crash errors for executing a DCI case with isCOBOL2016R1? (DBMR2783)
When users execute DCI case in command lines, an error happens as following:
>java.exe ISMIGRATE
Exception in thread "main" java.lang.UnsatisfiedLinkError: com.iscobol.dci.Dci.dci__getenv(I[B[B)I
at com.iscobol.dci.Dci.dci__getenv(Native Method)
at com.iscobol.lib.DCI_GETENV.call(DCI_GETENV.java:43)
at com.iscobol.lib.DCI_GETENV.call(DCI_GETENV.java:24)
at com.iscobol.rts.Factory.call(Factory.java:3780)
at com.iscobol.rts.Factory.call(Factory.java:3689)
at ...
How to convert hex type data to char or integer type data (DBMR2801)
You can use CAST to convert hex to char, and use BINTOINT to convert hex to integer type. Function BINTOINT supported in new versions built ...
How to use sleep function in SQL statements?
We support an UDF function sleep () for sleeping a while.
For example:
dmSQL> create function to_date.sleep(int) returns int;
dmSQL> select sleep(5);//sleep 5 seconds
Version: 5.3.x, 5.4.x
Product: Normal/Bundle
Platform: Windows/Linux ...
How to use LoadExternalDB to load DB/table/data online?
You can use LoadExternalDB to load external DB into local DB directly via DSN.
If set unload external 'connection string', dmSQL will print "set external db ...
How to encrypt table records for only some columns?
Can encrypt some columns with encryption UDF as following.
A. create function LIBCRYPT.AES_ENCRYPT(string,string) returns string;
create function LIBCRYPT.AES_DECRYPT(string,string) returns string;
B. insert into tableXX(columnXX) values(AES_ENCRYPT(‘XXXXXX’, 'user_defined_key'));
Or update ...
How to log CONNECTION and DISCONNECTION information only? (DBMR2835)
Setting DB_LGSVR=4,5,6 can record traced LOG which include CONNECTION and DISCONNECTION information, and also include SQL COMMAND, SQL COMMIT, SQL ROLLBACK, ERROR, and SLOW OPERATION.If ...
How to make LOAD DB more faster for huge DB? (DBMR2919)
LOAD DB support 2 option, safe and fast, the default is safe.
Set LOAD DB [safe | fast]
If set LOAD DB to SAFE, the database runs ...
How to make a batch script for rebuilding all indexes? (DBMR2924)
Enter follow SQL commands to check and rebuild all indexes. For example, there is a database including five indexes.
Check “CREATE_TIME” of original indexes.
dmSQL> SELECT CREATE_TIME, ...
How to start the database in single-user mode for maintenance? (DBMR2947)
You can use dmSQL or JDBA tool to maintain database in single-user mode. Follow below step to start the database for maintenance. Take database DBSAMPLE5 ...
How to avoid AbstractMethodError: dbmaker.sql.JdbcOdbcConnection.isValid(I)Z? (DBMR2960)
This error indicates that the version of DBMaker JDBC driver is outdated. Please update the driver to support isValid() method in JDBC. Before DBMaker 5.4.1, ...
How to register OLE DB driver for bundle versions in Windows10 x64? (DBMR2996)
To install OLE DB driver bundle version in Windows x64, you need to register the driver manually. If you register the 32-bit driver, open cmd ...
How to make the uncommitted records rollback in slave DB?
If master database terminated db before some transactions hadn’t been committed, theseuncommitted records had been existed in slave database and didn’t be rollback automatically. You ...
How to connect DBMaker with an Android client application? (DBMR2987)
You need to set dmjdbct3c.jar in external classpath, then change driver class and URL on your code. Add below code to connect DBMaker for Android ...
How to connect to multi database with different LCODE simultaneously? (DBMR3134)
From DBMaker 5.4.3, we fix the problem. You can connect to multi database with different LCODE simultaneously.
It is a restriction before DBMaker 5.4.3. DBMaker ...
How to connect DBMaker via Microsoft SQL Linked Server? (DBMR3153)
There are two providers to use MS linked server to connect DBMaker. They are Microsoft OLE DB Provider for ODBC Drivers and OLE DB Provider ...
How to install JDBC type3 as Windows Service? (DBMR3162)
1. Unzip attached JettyService.zip (3 files) in dbmaker\5.4\jetty
a. install-service.bat
b. JettyService.exe
c. bin\JettyService.exe
2. Run cmd as Administrator
> cd dbmaker\5.4\jetty
> install-service.bat
Note: you ...
How to comment code in SQL stored procedure? (DBMR3183)
You can use these symbols “/* */”, “//”, “#” and “--” to comment code. Using symbol“/* */” to comment code inside the symbol. Using the ...
How to restore table with another table name from Full Backup? (DBMR3188)
It is not easy to support restore table with another name from a full backup. Maybe we need to support more unload syntax to support ...
How to get all index columns via query? (DBMR3196)
From DBMaker 5.4.3, we add a stored procedure command “showindex”. Enter below command, you can get the index column.
dmSQL> call showindex(owner_name, table_name);
Here is an example. ...
How to get table schema via query? (DBMR3207)
From DBMaker 5.4.3, you can get table schema via dmSQL or JDBA tool.
1. There is a table t1 in the database. Enter below command, you ...
How to avoid shrinking database with journal full? (DBMR3233)
Shrinking database could be rolled back, which meant your “shrink” operation required journal file, and the required size should be double of compressed data and ...
How to export and import data to JSON format?
Enter below code to create store procedure “EXPORTJSON”. This stored procedure can export table to JSON format.
dmSQL> set block delimiter @@;
dmSQL> @@
CREATE OR REPLACE PROCEDURE ...
How to set system file object extension name in PHP via PDO ODBC? (DBMR3280)
Without loading file
$DB = new PDO('odbc:mydb', 'sysadm', '');
$filePath = '/tmp/demo.html';
$id = 1;
$sth = $DB->prepare("update demo set f = ? where id = ?");
if ($sth == ...
How to fix invalid view? (DBMR3289)
If you dropped the table, then recreated the table, the view which was based on the table became invalid view. When you select the invalid ...
How much is the Key length for network encryption? How to work? (DBMR3291)
To start network encryption, set DB_NETEC to 1 in dmconfig.ini. All data is encrypted by DES, and transmits to clients. When server creates the connection, ...
How to add single quotation mark in char compatible type?
You have to add two single quotations in string. For example, if you want to add “Hello, I’m DBMaker!” in table t1, you can type ...
How to fix ERROR(7302) or ERROR(7303) when create Linked Server in MS SQL Server? (DBMR3397)
For detail you can refer to http://www.lingan.com.cn:8117/faq/?sid=10&lang=en&action=faq&cat=72&id=825&artlang=en&highlight=dbmr3153 , and try to set AllowInProcess=1. Or set in "Microsoft SQL Server Management Studio":
Server Objects -> ...