I have copied the libmySQL.dll in my project, but it still gives the error "A6mySQL - no valid ACKNEX DLL".. What other plugins did you have to copy, and where?

Hmm ... sounds strange.

What I found until now, that single DLL shouls be enough.

At the moment, I can think of two possibilities:
1) maybe some standard Libary is used, that is still missing on your system? Like the mfc*.dlls?
2) I found multiple libmysql.dll on my system. One direktly inside the bin directory (which should be the right one) and then unter "embedded". Don't know, what is that for.

I would try to install mysql 4.1 server on the system. That should solve the problem. When you install the mysql 4.1 server using the installer, you can tell the installation to insert the bin directory to your path. Then you must not copy any lib - the system finds all on its own.

Hope that works for you. I checked the Project of the a6mysqlk.dll and found no need for other libs. So mybe your libmysql.dll is the wrong one or this lib has another dependency, that is not matched.

With kind regards,

Konrad Neitzel

Some points, I can explain:

1) There are some Libaries from Microsoft that were commonly used. One Library is "Microsoft Foundation Classes" short MFC. They exist in multiple version. Most commonly used are 4.2, 7.0 and the newest is 7.1 I think.
When a product uses them, they will normaly install it through a redistribution-pack from microsoft. They install under system32 directroy. (So it is ok)

2) That error message from conitec simple means, that the DLL cannot be used. This could be, because the DLL is not valid or that some requirements are not available. The a6mysql.dll needs the libmysql.dll. My own DLL, that I am writing at the moment, needs 2 Libs (pthreads and HawkNL).

When you look at the MFC-DLLs, you will see, that the version is available inside the name. mfc42* (4.2) mfc70* (7.0) and so on.
The libmysql.dll has no version in it's name, but you can be sure, that there are different versions available. And you got another installer than me. So I think, that you are using a different Version than me and the author.

I am using mysql-4.1.10-win32.zip from mysql.com. So maybe it works for you with this DLL.

Destop: Could you add the libmysql.dll in your zip File? So that all requirements are met with your distribution? Thank you in advance!

I hope, that this helps a little. If you want, I can send you my libmysql.dll (1MB only unzipped).

With kind regards,

Konrad

libmysql.dll is now included in the archive.
There is no need for the MFC dll, as this project is not MFC, it is plain win32.

Heya ... thank you for your quick reaction! That was really quick!

I am getting into this dll now and have the basics sorted out (INSERT, UPDATE, DELETE)

What I need to do moving forward is to run a SELECT query to get a result:

"SELECT FROM `player_index` WHERE `name` = 'player'"

I then need to simply see if this returns a row or does not. Basically it is to see if the player exists in the database prior to creating him/her. If exists then ask for passwd, if doesn't exist then start player creation.

What dll functions can I use to do this that are in this dll? I am looking at mySQL_GetStr but cannot figure it out!

Thanks for any help,

Andy

To check if your player is already created or not, I would use this SQL order:
"SELECT count(*) FROM player_index WHERE name='player'"
And then check the result with mySQL_GetVal(0, 0), if you got a 0, MySQL didnt found your player.

Or, use the mySQL_RowNumber() - Return the number of row in the result dataset.

Destop

Thanks Destop,

Things are falling into place nicely. Thanks again for this contribution

AndyH