AQT822数据库客户端

Install Notes for Advanced Query Tool v8 ======================================== AQT is installed using the Microsoft Installer. To install AQT, the Microsoft Installer needs to be installed on your PC. If so, double-clicking the *.msi file will install AQT. The Microsoft Installer *should* be on your PC if you have: . Windows NT V4 (with Service Pack 3 or higher) . Windows 2000 . Windows XP . Windows Vista If Windows does not recognise the msi file type, or the install is not working, you may need to install or upgrade the Windows Installer. This can be downloaded from the Microsoft site, as follows: . For Windows NT (with Service Pack 6) or Window 2000 go to http://download.microsoft.com/download/WindowsInstaller/Install/2.0/NT45/EN-US/InstMsiW.exe . For Windows NT (without Service Pack 6) use: http://download.microsoft.com/download/platformsdk/wininst/1.1/NT4/EN-US/InstMsi.exe Administrator Privileges ======================== In general, the AQT install needs to be run with administrator privileges. AQT installs and registers a number of components (dlls and ocxs), often these do not get done correctly unless the install is running with administrator privileges. This is particularly true with Windows Vista which has very strict security controls. We recommend you log on with a user with Admininstrator privileges and run the install. For Windows Vista, another options is to: . create a batch file with an msiexec command to run the install. This is outlined in Advanced Install at the bottom. . right-click aqt_install.bat and select Run as Administrator If you wish to run AQT with another user on the PC (eg. a different user from the one that did the install): . log on with that id . run the install This works even for a non-admin user. As the "main" install has already been done, this secondary install just installs icons in Start>Programs and the Desktop. This does not need admin privileges. Upgrading from AQT v7 ===================== If upgrading from an earlier release, you will not need to de-install your existing version AQT. The AQT v8 installation process will remove earlier versions of AQT (including AQT v8 Beta) before installing AQT v8. With AQT v8, the cfg file are moved to their own directory (sub-directory cfg). In addition, workfile created by AQT are now created in sub-directory workfiles. When AQT v8 starts for the first time, it will move all existing cfg and workfiles to these new directories. If you notice any problems in this area you should review the settings for Options > File Locations. Important Note for Users Upgrading from AQT v5/6/7 ================================================== In order to run AQT v8 you need to purchase a Version 8 Upgrade license ($30). When you upgrade to AQT v8, you are given a 30-day grace period for purchasing this license. After the 30 days has expired, AQT v8 will revert to Evaluation mode. You will need to either purchase the Version 8 Upgrade license, or de-install AQT v8 and reinstall AQT v7. Note that AQT v8 has implemented a more secure encryption method for the saved-passwords. Any passwords saved under AQT v8 will not be recognised by AQT v7. Windows 95, 98 and ME ===================== Note that AQT v8 does not run on Windows 95, 98 or ME. If you are using one of these operating systems you will need to run AQT v6. Silent Install ============== To run an unattended install of AQT, enter the following from a command prompt: msiexec /i aqtxxx.msi /qn For more information on this, see file aqt_install.bat, or: http://www.installshield.com/news/newsletter/0212-articles/uilevels.asp and http://msdn.microsoft.com/library/default.asp?url=/library/en-us/msi/setup/command_line_options.asp Uninstall ========= To Uninstall AQT, go Start->Programs->Advanced Query Tool->Uninstall. Alternatively, go Control Panel->Add or Remove Programs. Select Advanced Query Tool and click on Remove. The Uninstall just removes the files that were created during the install. Any other files that were created in the AQT install directory (such as saved-queries, history files plus others) will not be removed. You should delete these if you wish to completely remove AQT from your system. The Uninstall will also not remove any Registry entries. You will need to remove these manually if you wish to completely remove AQT from your system. The registry keys used by AQT are: HKEY_LOCAL_MACHINE\SOFTWARE\Cardett HKEY_CURRENT_USER\Software\VB and VBA Program Settings\Cardett Repair ====== If your install did not complete successfully, you may wish to do a Repair install. This can be done by rerunning the msi file; you will shown a dialog where you can select a number of install options. Select Repair. If you have any other problems or questions on the install process, contact us as support@querytool.com Can't find previous msi file ============================ During the install process, the Windows Installer will uninstall the previous version of AQT. Sometimes it will want to find the *.msi file for the currently-installed version in order to do this uninstall. If you no longer have this *.msi file: a) contact us. We have copies of most (though not all) old msi files b) at a last resort, you can run the "Windows Installer CleanUp Utility" to remove the entries Windows Installer entries for this old release. This will not uninstall the old version of AQT, it will just remove the Windows Installer entries. This utility should be used with caution. It can be downloaded from http://support.microsoft.com/?scid=kb;en-us;290301 Componenents not registered =========================== If your install did not work fully, when you run AQT you may get a message that some components are not present or registered. To correct, try the following: a) install AQT with administrator privileges (as described earlier) b) from the AQT signon window, go Help > "Register AQT Components to Windows". This gives you a dialog where you can "manually" register the components used by AQT c) find file ocx_register_v8.bat in the AQT install directory. Edit this file; read the instructions and ensure the appropriate directory names are specified. Run the file - you should get a bunch of messaging saying "DLLRegisterServer in xxxx succeeded". For Windows Vista it is recommended that you run ocx_regsiter_v8.bat with administrator privileges (right-click and select Run as Administrator). Problems Registering Components =============================== The following are known problems with registering AQT components, and resolutions. a) If you get "RegisterServer failed in srcvw32.dll. Return code is 0x8007005. GetLastError=0x0" the problem is that your userid doesn't have sufficient authority on the Windows registry to perform the operation. We suggest having the registers done by an Admin user. b) Similarly, error code 0x80004005 also indicates insufficient authority to register components. Known Problems ============== a) Windows NT has a bug that can cause "Internal error 2755. 1631". This problem is described in the article http://support.microsoft.com/?kbid=251274 It can be resolved by removing any null values from the registry key HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Environment. Use regedit to remove any null values from this registry key. b) The install fails and gives message "The wizard was interrupted before Advanced Query Tool could be completely installed. Your system has not been modified. To complete installation at another time, please run setup again". This is a problem with the Microsoft Installer that MS provide little useful information on. The following workaround has been found by one user. (i) leave the AQT Install dialog open on your desktop. Do not close this. (ii) go to your TEMP directory which (depending on your version of Windows), may be C:\Documents and Settings\<username