DB Query Analyzer 6.04 is distributed,78 articles concerned have been published
DB Query Analyzeris presented by Master Genfeng, Ma from Chinese Mainland. It has Englishversion named ‘DB Query Analyzer’ and Simplified Chinese versionnamed .
DB Query Analyzeris one of the few excellent Client Tools in the world for its’ powerfulfunction, friendly interface, easy operation and applicability to everyproduction of RDBMS.
① It lets you query ODBC data sources, author SQLscripts and queries, return query results to a grid or free-form text or afile, retrieve ODBC driver information, ② execute multiple SQL scripts or stored procedures simultaneously,③save the result to files withhigh efficiency which is as quick as tools provided by database system. ④What is more, from 6.01, DBQuery Analyzer provides SQL Execute Schedule function to execute SQL scripts incertain time. If you select the option ‘SQL Schedule Reconnect’ in windowconfigurations, the Schedule SQL scripts will be executed as long as theDatabase Server is in use, even though the Database Server had been down. ⑤From version 6.03, withoutchanging any Windows OS settings or configurations, DB Query Analyzer can runon any Microsoft Windows OS directly such as Windows 10, Windows 8, Windows 7,Windows Vista, Windows 2003, Windows XP, Windows 2000, Windows NT, Windows ME,Windows 9X.
In the New products& Tools reviews of programmer second issue of 2007, DB Query Analyzer hadbeen strongly recommended.
Now the SimplifiedChinese version of DB Query Analyzer is the top 50 database applicationsoftware in the famous software website http://xiazai.zol.com.cn/download_order/sub_550.html .In most case it lies the top 10 and it has been download more than 110,000 times.
78 technicalarticles about DB Query Analyzer have been published or been publishing incomputer journal, BAIDU Library, the CSDN resource or my four blog-websites.
The latestversion of DB Query Analyzer is 6.04. It was distributed on August 18th, 2015 in zol.com.cn, pconline.com.cn, onlinedown.net ,to name but a few.
In 6.04, Itresolve the BUG that error message will be prompted when executing a singlelong SQL script with more than thousands of line or the file size of single SQLscript more than 200KB.
Remarks:
If the SQL scriptwith more than thousands of line or the file size of single SQL script morethan 200KB, please switch the checkbox ‘Color the key words, function of SQLstatement’ off. Otherwise, it will take you about half a minute for DB QueryAnalyzer to analyzer the Function names, Stored Procedures and Key Words.
Click the menuitem Tools, then click the sub menu item Configuration to open the windowConfigurations bellow.
Switch off the item ‘Color the key words,function of SQL Statement’ in the window.
Normally, theitem is set on and Function names, Stored Procedures and Key Words input byusers will be drew different color in DB Query Analyzer no matter what RDBMSproduct. So it is convenient not only to rectify the mistake but also to findout whether a certain function or system table or a stored procedure exists incurrent DBMS connection.
DB Query Analyzer 6.04 download URL:
http://xiazai.zol.com.cn/detail/43/420901.shtml
http://www.unitedpowersoft.com/UpFile/DBQueryAnalyzer_English_603.rar
DB QueryAnalyzer Simplified Chinese version 6.04 download URL:
http://xiazai.zol.com.cn/detail/27/264455.shtml
How to downloadthe installation packages of DB Query Analyzer from ZOL?
Recently, Zhongguancun Online distributedthe ZOL Downer for users to download the resources from ZOL. In this case,users can just download the ZOL downer with the code of resources, not theinstallation packages.
But if someone want to install the PC whichis isolated from the INTERNET, he or she will no longer do that.
So how do the users download theinstallation packages? Please see the eassy bellow
How todownload the installation package by ZOL Downer
http://blog.csdn.net/magenfeng/article/details/38750901
Remark :
Please uninstall the former versionfirst, then install the latest version.
My blog is http://blog.csdn.net/magenfeng
http://blog.sina.com.cn/magenfeng
http://user.qzone.qq.com/630414817
Interview with CSDN: http://www.csdn.net/article/2014-08-09/2821124
78 technicalarticles about DB Query Analyzer have been published or been publishing incomputer journal, Baidu Library, the CSDN resource or my fourblog-website.
The following 7articles have been published in computer journal.
Guangdong Highway settlement business analysis systembased on Star Schema in Data Warehousing according to national standardization in Computer Era 7th issue of 2015 in Hangzhou.
DBQuery Analyzer to cancel a running SQL statement in Computer Era 12th issue of 2011 in Hangzhou.
DBQuery Analyzer Returns Information in More Detail While Batch SQL Statement Endof Execution in Computer Programming Skill & Maintenance 24th issue of 2011 in Beijing
TheApplication of the Transactions Control in DB2 with DB Query Analyzer inComputer Programming Skill & Maintenance 22nd issue of 2011 in Beijing.
Howdoes DB Query Analyzer cancel the SQL statement committed to DBMS in ComputerEngineering & Software 6th issue of 2011 in Tianjin.
TheApplication of the Transactions Control in Oracle with DB Query Analyzer inMicrocomputer Applications11th issue of 2011 in Shanghai.
DB Query Analyzer had been stronglyrecommended In the New products & Tools reviews of programmer 2nd issue of2007.
The following 71 articleshave been published or been publishing in Baidu Library, the CSDN resource ormy four blog-website.
TheDBMS that DB Query Analyzer Users often use cover all kinds of DBMS have beenpublished.
Howto configure ODBC DSN in Client to access remote DB2 for Windows
How to configure ODBC DSN to access localDB2 for Windows
WhichSQL statement is the trump card to the senior software developer
Exepacker prevent DB Query Analyzer from beging debugged have been published.
16articles from The 1st tip of DB Query Analyze to The 16th skills of DB QueryAnalyzer have been published.
Thetable name must be enclosed in double quotation marks or sqare bracket whileaccessing EXCEL by DB Query Analyzer
How to download the installation packageby ZOL Downer
DBQuery Analyzer, the most excellent Universal database Access tools on anyMicrosoft Windows OS
Demonstrationof DB Query Analyzer 6.03 Installation and Running on Microsoft Windows 8