Cannot find dynamic library file

[SpriggsySpriggs]

Have you tried the .\ yet?

[Paolo_Ricardo]

No, because the .dlls are in the program folder and not with the source - which is why I used the absolute paths.

[SpriggsySpriggs]

I guess just keep trying to fiddle with it until it clicks. I am not sure what is wrong with it.

[SMcNeill]

Doesn’t the IDE normally give a file not found type error, if it can’t find the library?  Is there a problem with the EXE not being in the same folder as the bas file?  Or a permission issue?  The picture shows OK in the IDE, so it seems to me that QB64 is finding the dll okay. 

[Paolo_Ricardo]

I put the .dlls in the source directory and used the .\ option. At least I get the same result now - a window opening and closing. No message about missing .dll for the 64 bit version.

The message that shows up briefly is, I think,  "MYSQL Client: " + mysql_get_client_info$ . It's a very short message.

Does this have anything to do with nothing else happening? As far as I'm aware I'm not connected to any database.

PRINT mysql_real_connect(conn, "qb64db2.db.7445102.hostedresource.com", "qb64guest", "QB64forever", "qb64db2", 0, 0, 0)

[Paolo_Ricardo]

@SMcNeill

It was giving a 'missing .dll' message for the 64-bit version but that seems to have disappeared. The compiled programs are in a work folder. I have now put the .dlls in the work folder. The .BAS and .EXE files are in the same folder.

[SpriggsySpriggs]

It could just be crashing since you don't have a database connection (The demo may not fail gracefully AND that server is more than likely not available anymore. I don't remember ever being able to use it in the past.). If you see anything from that client info function then the DLLs are working. The main thing is.... The DLLs should be kept with the compiled executable and the source should usually be a ".\" so that when you distribute it you don't get the message about not finding the DLL. The helper file doesn't need to be distributed (unless you are distributing the source, and I don't think it's even needed for anything other than the SQL Client demo) after you compile because it is then a part of the main executable.

[Paolo_Ricardo]

@SpriggsySpriggs

So ''mysql_real_connect(conn, "qb64db2.db.7445102.hostedresource.com", "qb64guest", "QB64forever", "qb64db2", 0, 0, 0)'' is no longer available - and that was the reason for  the problems?

OK, so, apart from the non-functioning SQL Client code, are there any tutorials available on integrating QB64 with MySQL?

Would I be correct in assuming that MYSQL.BM and MYSQL.BI provide a full implementation of MySQL's declarations/functions/subs?

I am quite determined to learn QB64 and MySQL so thanks for your help so far and for any further information.

[SpriggsySpriggs]

It isn't that the demo is non-functioning. It's that the server that was used in the demo is no longer available. Just make a localhost server in MySQL Workbench and do your testing there. That's what I do.

My MYSQL.BI and MYSQL.BM do not provide full implementation but I do occasionally check the MySQL C API pages to see what new function can be added. I think that all the useful ones are there right now (A lot of functions that aren't implemented yet can be replicated by simply doing a query rather than a DLL call). If you ever need help with figuring out how to use some of the functions then don't hesitate to either add a new reply to this post or send me a PM. I do still have plans on making a dedicated post and video on how to do the entire MySQL setup. All the way from getting MySQL Workbench to running code with super complex queries.

[Paolo_Ricardo]

@SpriggsySpriggs

OK, thanks.