设为首页 加入收藏

TOP

The16thtipofDBQueryAnalyzer(一)
2015-07-24 11:56:52 来源: 作者: 【 】 浏览:31
Tags:The16thtipofDBQueryAnalyzer

The 16th tip of DB Query Analyzer
---- SQL Schedule will be executed even DBMS has ever been down in 6.02

Ma Genfeng

(Guangdong Unitoll Services incorporated, Guangzhou 510300)

Abstract The latest version of DB Query Analyzer is 6.02. In 6.02, if yous elected the option ‘SQL Schedule Reconnect’ in window configurations, theSchedule SQL scripts will be executed as long as the Database Server is in use,even though the Database Server had been down.

As I said in the interview with ChineseSystem Development Net, if I have time what I want to do is to realize the reconnection to DBMS in SQL Schedule Function even DBMS has ever been down. Today, I am very glad to realize this function.

Key words DB Query Analyzer


1 Brief introduction of DB Query Analzyer

DB Query Analyzer is presented by Master Genfeng, Ma from Chinese Mainland. It has English version named ‘DB Query Analyzer’ and Simplified Chinese version named \vcD48cD5EQiBRdWVyeSBBbmFseXplciBpcyBvbmUgb2YgdGhlIGZldyBleGNlbGxlbnQgQ2xpZW50IFRvb2xzIGluIHRoZSB3b3JsZCBmb3IgaXRzoa9wb3dlcmZ1bCBmdW5jdGlvbiwgZnJpZW5kbHkgaW50ZXJmYWNlLCBlYXN5IG9wZXJhdGlvbiBhbmQgYXBwbGljYWJpbGl0eSB0byBldmVyeSBwcm9kdWN0aW9uIG9mIFJEQk1TLjwvcD48cD5JdCBsZXRzIHlvdSBxdWVyeSBPREJDIGRhdGFzb3VyY2VzLCBhdXRob3IgU1FMIHNjcmlwdHMgYW5kIHF1ZXJpZXMsIHJldHVybiBxdWVyeSByZXN1bHRzIHRvIGEgZ3JpZCBvciBmcmVlLWZvcm0gdGV4dCBvciBhIGZpbGUsIHJldHJpZXZlIE9EQkMgZHJpdmVyIGluZm9ybWF0aW9uLCBleGVjdXRlIG11bHRpcGxlIFNRTCBzY3JpcHRzIG9yIHN0b3JlZCBwcm9jZWR1cmVzIHNpbXVsdGFuZW91c2x5LCBhbmQgbW9yZS48L3A+PHA+PHN0cm9uZz4gPC9zdHJvbmc+PC9wPjxwPjxzdHJvbmc+QWNoaWV2ZW1lbnQgb2YgREIgUXVlcnkgQW5hbHl6ZXI8L3N0cm9uZz48L3A+PHA+SW50aGUgTmV3IHByb2R1Y3RzICZhbXA7IFRvb2xzIHJldmlld3Mgb2YgcHJvZ3JhbW1lciBzZWNvbmQgaXNzdWUgb2YgMjAwNywgREIgUXVlcnkgQW5hbHl6ZXIgaGFkIGJlZW4gc3Ryb25nbHkgcmVjb21tZW5kZWQuPC9wPjxwPk5vdyB0aGUgU2ltcGxpZmllZCBDaGluZXNlIHZlcnNpb24gb2YgREIgUXVlcnkgQW5hbHl6ZXIgaXMgdGhlIHRvcCA1MCBkYXRhYmFzZSBhcHBsaWNhdGlvbiBzb2Z0d2FyZSBpbiB0aGUgZmFtb3VzIHNvZnR3YXJlIHdlYnNpdGUgaHR0cDovL3hpYXphaS56b2wuY29tLmNuL2Rvd25sb2FkX29yZGVyL3N1Yl81NTAuaHRtbC4gSW4gbW9zdCBjYXNlIGl0IGxpZXMgdGhlIHRvcCAxMCBhbmQgaXQgaGFzIGJlZW4gZG93bmxvYWQgbW9yZSB0aGFuIDEwMCwwMDAgdGltZXMuPC9wPjxwPjxzdHJvbmc+NzEgdGVjaG5pY2FsIGFydGljbGVzIDwvc3Ryb25nPmFib3V0IERCIFF1ZXJ5IEFuYWx5emVyIGhhdmUgYmVlbiBwdWJsaXNoZWQgb3IgYmVlbiBwdWJsaXNoaW5nIGluIGNvbXB1dGVyIGpvdXJuYWwsIEJBSURVIExpYnJhcnksIHRoZSBDU0ROIHJlc291cmNlIG9yIG15IGZvdXIgYmxvZy13ZWJzaXRlLjwvcD48cD4gPC9wPjxwPjxzdHJvbmc+QSBraW5kIHJlbWluZDwvc3Ryb25nPjwvcD48cD5CZWNhdXNlIFdpbjcvV2luOC9XaW5kb3dzIDIwMTAgc3RhcnQgdG8gc2VsZWN0IKGuL6GvICBhcyB0aGUgZGVmYXVsdCBzZXBlcmF0b3IgY2hhcmFjdGVyIGJldHdlZW4gc2hvcnQgZGF0ZS4gVGhpcyB3aWxsIHJlc3VsdCBpbiBhbiBlcnJvciB3aGlsZSBydW5uaW5nIERCIFF1ZXJ5IEFuYWx5emVyLGluY2x1ZGluZyBFbmdsaXNoIHZlcnNpb24goa5EQiBRdWVyeSBBbmFseXplcqGvIGFuZCBTaW1wbGlmaWVkIENoaW5lc2UgdmVyc2lvbiA8aW1nIHNyYz0="https://www.cppentry.com/upload_files/article/57/1_avtxh__.jpg" alt="\" />.

I will solve this BUG in DB Query Analyzer 6.03. In order to use DB Query Analyzer properly,please set ‘-‘ as the default setting of short date in Win7.



2 6.02 version new characteristic

The latest version of DBQuery Analyzer is 6.02.

In 6.02, if you selected the option ‘SQLSchedule Reconnect’ in window conf

首页 上一页 1 2 3 下一页 尾页 1/3/3
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇【实战】sphinx的配置文件 下一篇Redis集群_1.redis主从配置

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容:

·如何理解智能指针? (2025-12-24 12:48:26)
·c++是否应避免使用普 (2025-12-24 12:48:23)
·如何通俗易懂学会 C+ (2025-12-24 12:48:21)
·在 C 语言函数中,如 (2025-12-24 12:19:41)
·C盘里面的AppData文 (2025-12-24 12:19:38)