wxWidgets Discussion Forum

No, DatabaseLayer should work with ANSI/Unicode or GUI/Base builds. I've mainly been in bugfix mode on DatabaseLayer lately and since there haven't been many ODBC issue reports, I haven't spent a lot of time in the ODBC backend. The ODBC backend was contributed by Scott Fant and a couple of other pr...

I'm partial to DatabaseLayer. We're still working on getting it to work with the latest FreeTDS release for MS SQL Server support though. With ODBC (using any of the libraries, not just DatabaseLayer), make you test the ANSI/UNICODE carefully on the Linux side. iODBC and unixODBC have different leve...

There's a 1-line change between 1.7.1 and 1.7.5 that seems to correct the issue. In MysqlPreparedStatementParameter.cpp at line 84 the code "m_pBind->length = &m_Data.nBufferLength;" seems to be causing the issue. If you remove that line, does it fix your issue?

The reason that I only mentioned it on Linux is that I only had access to a Linux machine for testing at the time. Interestingly, I don't think any of this memory corruption issue exists on the 1.7.1 release of DatabaseLayer. (On the other hand, an 8-byte memory leak may exist.) I'll try comparing t...

I'm still working on determing where the issue is in the DatabaseLayer code (most likely the parameter code). During my testing, I was able to find another change that fixed segmentation faults on Linux. The lines that add % signs into the string and call SetParamString could be changed into m_prepS...

Sorry, the view creation part of the test.sql script didn't work for me (not enough permissions for the user). I had forgotten about that when I changed the SQL into a join. I was finally able to get a potential heap corruption issue. This is the main issue that you were talking about, right? It loo...

Yes, I did try the code that you posted. I needed to make a couple of modifications, but otherwise it worked fine. The first modification was that all places where a wxString was used for a %s parameter in a wxPrintf call, the c_str() function of the wxString needs to be used. The other modification...

Have you tried the same code in any other environments? I'm currently using 32bit Ubuntu. I'll try again with a debug/ansi build of wxWidgets.

Also, that wxDebug line can probably be removed. It was added when I was working on removing all memory leaks from the MySQL backend code.

Try wrapping the PrepareStatement in a try catch block. Printing out the value of the exception's GetErrorString() should help debug the issue.

The deb packages contain some .svn directories. Will this cause any problems?

Thanks for a great IDE!

Here's a test program I tried to write to a small program to investigate the issue. Unfortunately, I wasn't able to get the crash to occur. I've attached the code to this thread. I guessed at some of the code in the DatabaseManager class. Are there any changes that you can make to the sample program...

You should probably stick with m_pDB->CloseResultSet(m_pResultSet); instead of m_pResultSet->Close(); so that m_pDB (or m_prepSearchBuddies) doesn't keep a bad pointer to the result set and try to clean it up later. Can you see which line in RunQueryWithResults is the last line called? What database...

Hopefully `mysql_config --libs` would take care of adding all the library dependencies to the build command. mysql_config and libmysqld.a should both be provided in the libmysqlclient15-dev package. Is that installed on your machine? If so, then maybe just removing the "-lmysqld" from the ...

If you do a "mkdir gccgtk2_dll" it should create the directory and build for you. I'll work on getting output directory creation in the build scripts.

Is there a "gccgtk2_dll" directory under the "build" directory? There may also need to be one under the "lib" directory.