I'm using Djuggler Builder Trial V3.2.1 and WAMP server 2.0i.

Error: Access violation at address 04128564 in module 'dbxmys.dll'. Read of address 000000

in the SQL Query for Records action.

Both Connection to MySQL and insert data with SQL Query Direct work fine.

Same error occur in example script 156.djs

Any idea about this problem?

Thanks.

Do you have mySQL installed on the system that is running Djuggler?

At first I thought dbxmys.dll is provided by MySQL and not included in the WAMP package, so I install MySQL Server 5.1. But the problem stays.

Later I found out that the file is in the Djuggler install folder. I add the installation path to the PATH of the system, just in case. Still no luck.

I also used the dbxmys.dll from other version of Djuggler, effort in vain.

So, I came here to ask for help.

Could you try your script on another computer, just to see if it's releated to your pc specific.

Same error pop up.

I tried other two computers with WinXP, and VMWare with an image of WinXP and newly installed Win 7 (yes, I downloaded them), all fail in the example script 156.djs.

BTW, for those system without a MySQL installed, I need to copy the claimed missing libmysql.dll to the djuggler folder before I can run Connect to MySQL. But on the computer I'm working with, I don't need to do so.

Anything else I can do?

Problem solved.

Looks like the version comparability caused the problem. The version of libmySQL.dll need to be old enough to work with djuggler. I use the one downloaded form here,

http://downloads.mysql.com/archives...hp&v=5.2.1

You need to copy libmySQL.dll to the djuggler install folder if the computer is running an non-compatible version of MySQL server, or not running any MySQL server at all.

Now, at least the 156.djs runs successfully.

Glad that it works! Thanks for your efforts.

The problem was that the current version of Djuggler/dbxmys.dll doens't work with MySQL 5. That is why you needed to downgrade. We have updated the components we use for accessing MySQL and the next release of Djuggler will be compatible with MySQL 5.