WinXp下,启动navicat后,点击菜单栏时,出现access violation a
上周五帮同事在Windows下安装NavicatPremium客户端,打开该软件,访问其菜单栏下的【查看】菜单出错,见下图1: 图1 出现此问题的原因是内存访问越界,说白了,就是说它访问了不该访问的存储区。 其实,这个问题在我的Windows上也存在,不过因它能满足我的正
上周五帮同事在Windows下安装Navicat Premium客户端,打开该软件,访问其菜单栏下的【查看】菜单出错,见下图1:
图1
出现此问题的原因是内存访问越界,说白了,就是说它访问了不该访问的存储区。
其实,这个问题在我的Windows上也存在,不过因它能满足我的正常需求,倒也没有引起我的重视。一开始,我一直以为是程序兼容性问题,后来在同事那以兼容模式运行该软件,问题没有得到解决。后来想是和内存使用有关,我便抱着试试看的想法,进行了如下操作:
1.桌面→我的电脑→右击选中“属性”,见下图2:
图2
2.执行步骤1,会打开如图3所示页面,见图3:
图3
那么,什么是数据执行保护呢?见图4
图4
3.了解以上内容后,选择“为下列程序之外的所有程序启用 DEP”,然后把图1报错信息中的程序“Navicat.exe”(在Windows的路径)添加进来,见图5
4.第3步骤执行完后,如图6所示
图6
5.点击图6中的【应用】按钮,系统要求重启Windows操作系统,按系统提示重启操作系统。
注:在重启操作系统后,打开【查看】功能,内存访问越界问题消失。但这并未从根本上解决问题,因为【工具】、【窗口】两功能按钮依然存在。网上有帖子说:遇到内存越界问题,最好重新注册下Windows的动态链接库,首先“开始”—“cmd”,在打开的dos窗口中运行“for %1 in (%windir%\system32\*.dll) do regsvr32.exe /s %1”。
果真,按照这个方法我对动态链接库进行了重新注册,等重新注册后,再次重启Navicat Premium客户端,内存访问越界彻底消失。
总结:水是有源的,树是有根的,“navicat.exe”访问内存越界也是有原因的,为什么重新注册动态链接库问题就会解决,关于这个问题有时间还是要研究下。
补充:navicat运行一段时间后,也会间歇性出现访问内存越界问题,再次对动态链接库进行重新注册,内存访问越界问题消失。经过一段时间的观察,发现内存访问越界问题一直在反复,原因很可能与动态链接库的变化有关。持续观察中……
经过一段时间的运行,发现将Navicat premium版本升级到10.1.7后,以上现象不再复发

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics











Navicat Keygen Patch is a key generator that activates Navicat Premium, allowing you to use the full functionality of the software without purchasing a license. How to use: 1) Download and install Keygen Patch; 2) Start Navicat Premium; 3) Generate the serial number and activation code; 4) Copy the key; 5) Activate Navicat Premium, and Navicat Premium can be activated.

How to check if Navicat is activated: View the Registration Information section in the "About Navicat" of the Help menu: Activated: Show valid registration information (name, organization, expiration date) Not activated: Show "Not Registered" or "Register Information Not Available" Check the activation icon in the toolbar: The green icon indicates that the active observation trial period countdown: The trial version will show the countdown at startup, the activated version will not view feature limitations: The trial version may limit advanced features, and the activated version will unlock all functions

How to import SQL files using Navicat? Open Navicat and connect to the database. Open the SQL Editor. Import SQL files. Set import options (optional). Perform import. Check the import results.

You can use Navicat to create a stored procedure, the steps are as follows: Open the database object list and expand the "Procedures" node. Right-click the Procedures node and select Create Procedure. Enter the stored procedure name and body and set the parameters (if required). Select Compile in the File menu to compile the stored procedure. By executing a query or using "E in the "Procedures" list

Export query results with Navicat can be performed step by step: 1. Select the data to export 2. Select the export format: CSV, Excel, XML, or JSON 3. Configure the export options: Select columns, separators, and filters 4. Select the save location 5. Start exporting 6. Verify the results

Steps to perform SQL in Navicat: Connect to the database. Create a SQL Editor window. Write SQL queries or scripts. Click the Run button to execute a query or script. View the results (if the query is executed).

Navicat provides rollback functionality to undo database changes. The rollback steps are as follows: Connect the database to expand the database to be rolled back in the object browser. Right-click the table and select "Rolleepback" to select the rollback time point. Click "OK"

To resolve errors when Navicat runs SQL files, follow these steps: 1. Check for SQL syntax errors; 2. Make sure the database connection is established; 3. Check file encoding; 4. Adjust server settings; 5. Check temporary space; 6. Disable certain plugins; 7. Contact Navicat Support if necessary.
