Closed Melandr closed 2 years ago
Hi Melandr, can you provide few more details:
I will appreciate if you can find time to document exactly the steps you took so that it will be easy to test and fix.
Thank you for using wxDatabase
Добрый день!
- Какие библиотеки должен поддерживать wxDatabse? MySQL? Постгрес? ODBC? Собирал для ODBC, но думаю может стоит добавить MySql и Sqllite. В первую очередь необходимо сделать подключение к MS SQL (следовательно ODBC)
- Как вы создали Makefile из CMake? Makefile создавал через Cmake gui for Windows
- Какую версию MingW вы использовали, и ссылку для ее загрузки, если вы ее помните MinGW ставил вместе с CodeBlocks https://sourceforge.net/projects/codeblocks/files/latest/download
![]()
Hi, unfortunately do not know Russians. I will try to follow screenshots/Google translate and see where the issue is but if you can write in english it will be great!
Since you want to use MSSQL, did you check FreeTDS. It is supported by wxDatabase thanks to @manyleaves
Since the library doesn't even build, I will have to fix that!
Hi! I will try to answer in English, although the translation will be via Google Translate
вс, 31 окт. 2021 г. в 08:49, Stefano D. Mtangoo @.***>:
Hi, unfortunately do not know Russians. I will try to follow screenshots/Google translate and see where the issue is but if you can write in english it will be great!
— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/mtangoo/wxDatabase/issues/25#issuecomment-955646654, or unsubscribe https://github.com/notifications/unsubscribe-auth/AJ3OGDSGSEHVARR2E5RXZUTUJTRIJANCNFSM5G42JJHQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.
wxWidgets 3.0.5 (7zip) Cmake: 3.22 rc2 MinGW: TDM: tdm64-gcc-10.3.0-2
mingw32-make -f makefile.gcc SHARED=1 UNICODE=1 BUILD=debug
(Note you can put release instead of debug)C:/Libraries/wxDatabase
) and build to its build folder (eg. C:/Libraries/wxDatabase/build
)WXWIN
value should point to your wxWidgets. Then add itGenerating done
. In your build directory there should be build files generated.mingw32-make
It should build fine thenNote: You must update to the latest master. I would be happy to see feedback from your usage and any issue you encounter
Thanks for your help. As soon as possible, when I follow your instructions, I will answer you by email. I also wanted to ask what you need to download for using not only ODBC, but also SQLLite and MySQL
вс, 31 окт. 2021 г. в 12:28, Stefano D. Mtangoo @.***>:
Note: You must update to the latest master. I would be happy to see feedback from your usage and any issue you encounter
— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/mtangoo/wxDatabase/issues/25#issuecomment-955673967, or unsubscribe https://github.com/notifications/unsubscribe-auth/AJ3OGDUYJXJX7BKE3WLJRXTUJUK43ANCNFSM5G42JJHQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.
For ODBC with Windows you do not download anything. WIndows servers I believe comes with ODBC drivers. MySQL - MySQL ODBC driver if you want to use ODBC. But if you install MariaDB connector C it should work fine SQLite comes bundled. Just enable it in the CMake file and enjoy the music
Note: SQLite bundled is not the latest but I plan to update it in foreseeable future!
Good day!
According to your instructions, I downloaded the specified versions of
wxWidgets, Smake, MinGW. Launched building the library with the following
keys mingw32-make -f makefile.gcc SHARED = 1 UNICODE = 1 MONOLITHIC = 1
BUILD = release
The library was not fully compiled, gave the following error
../../src/msw/mediactrl_am.cpp: In member function 'void
wxAMMediaEvtHandler :: On
ActiveX (wxActiveXEvent &) ':
../../src/msw/mediactrl_am.cpp:2234:10: error: narrowing conversion of
'42949666
87 'from' unsigned int 'to' long int '[-Wnarrowing]
2234 | case 0xfffffd9f: // readystatechange in IActiveMovie2 and
IMediaPlay
er
| ^ ~~~~~
makefile.gcc: 7136: recipe for target 'gcc_mswudll \
monodll_mediactrl_am.o' failed
mingw32-make: *** [gcc_mswudll \ monodll_mediactrl_am.o] Error 1
вс, 31 окт. 2021 г. в 12:53, Stefano D. Mtangoo @.***>:
Note: SQLite bundled is not the latest but I plan to update it in foreseeable future!
— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/mtangoo/wxDatabase/issues/25#issuecomment-955677431, or unsubscribe https://github.com/notifications/unsubscribe-auth/AJ3OGDXI64EHWF3OBBJOU23UJUNZ5ANCNFSM5G42JJHQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.
The library is not being built. These were the same problems https://aur.archlinux.org/packages/mingw-w64-wxmsw/
пн, 1 нояб. 2021 г. в 13:23, Андрей Мельниченко @.***>:
Good day! According to your instructions, I downloaded the specified versions of wxWidgets, Smake, MinGW. Launched building the library with the following keys mingw32-make -f makefile.gcc SHARED = 1 UNICODE = 1 MONOLITHIC = 1 BUILD = release The library was not fully compiled, gave the following error ../../src/msw/mediactrl_am.cpp: In member function 'void wxAMMediaEvtHandler :: On ActiveX (wxActiveXEvent &) ': ../../src/msw/mediactrl_am.cpp:2234:10: error: narrowing conversion of '42949666 87 'from' unsigned int 'to' long int '[-Wnarrowing] 2234 | case 0xfffffd9f: // readystatechange in IActiveMovie2 and IMediaPlay er | ^
~~~~~ makefile.gcc: 7136: recipe for target 'gcc_mswudll \ monodll_mediactrl_am.o' failedmingw32-make: *** [gcc_mswudll \ monodll_mediactrl_am.o] Error 1
вс, 31 окт. 2021 г. в 12:53, Stefano D. Mtangoo @.***
:
Note: SQLite bundled is not the latest but I plan to update it in foreseeable future!
— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/mtangoo/wxDatabase/issues/25#issuecomment-955677431, or unsubscribe https://github.com/notifications/unsubscribe-auth/AJ3OGDXI64EHWF3OBBJOU23UJUNZ5ANCNFSM5G42JJHQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.
Good evening! I wanted to clarify whether it matters with which keys wxWidgets is built? If I use the version of the compiler in conjunction with CodeBlocks, the build is successful. And if I use the tdm64-gcc-10.3.0-2.exe compiler, then the build fails.
пн, 1 нояб. 2021 г. в 15:12, Андрей Мельниченко @.***>:
The library is not being built. These were the same problems https://aur.archlinux.org/packages/mingw-w64-wxmsw/
пн, 1 нояб. 2021 г. в 13:23, Андрей Мельниченко @.***>:
Good day! According to your instructions, I downloaded the specified versions of wxWidgets, Smake, MinGW. Launched building the library with the following keys mingw32-make -f makefile.gcc SHARED = 1 UNICODE = 1 MONOLITHIC = 1 BUILD = release The library was not fully compiled, gave the following error ../../src/msw/mediactrl_am.cpp: In member function 'void wxAMMediaEvtHandler :: On ActiveX (wxActiveXEvent &) ': ../../src/msw/mediactrl_am.cpp:2234:10: error: narrowing conversion of '42949666 87 'from' unsigned int 'to' long int '[-Wnarrowing] 2234 | case 0xfffffd9f: // readystatechange in IActiveMovie2 and IMediaPlay er | ^
~~~~~ makefile.gcc: 7136: recipe for target 'gcc_mswudll \ monodll_mediactrl_am.o' failedmingw32-make: *** [gcc_mswudll \ monodll_mediactrl_am.o] Error 1
вс, 31 окт. 2021 г. в 12:53, Stefano D. Mtangoo @.***
:
Note: SQLite bundled is not the latest but I plan to update it in foreseeable future!
— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/mtangoo/wxDatabase/issues/25#issuecomment-955677431, or unsubscribe https://github.com/notifications/unsubscribe-auth/AJ3OGDXI64EHWF3OBBJOU23UJUNZ5ANCNFSM5G42JJHQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.
Build wxWidgets without MONOLITHIC option But wxDatabase is not going to [image: mono.jpg][image: cmake.jpg][image: gcc.jpg]
пн, 1 нояб. 2021 г. в 20:59, Андрей Мельниченко @.***>:
Good evening! I wanted to clarify whether it matters with which keys wxWidgets is built? If I use the version of the compiler in conjunction with CodeBlocks, the build is successful. And if I use the tdm64-gcc-10.3.0-2.exe compiler, then the build fails.
пн, 1 нояб. 2021 г. в 15:12, Андрей Мельниченко @.***>:
The library is not being built. These were the same problems https://aur.archlinux.org/packages/mingw-w64-wxmsw/
пн, 1 нояб. 2021 г. в 13:23, Андрей Мельниченко @.***
:
Good day! According to your instructions, I downloaded the specified versions of wxWidgets, Smake, MinGW. Launched building the library with the following keys mingw32-make -f makefile.gcc SHARED = 1 UNICODE = 1 MONOLITHIC = 1 BUILD = release The library was not fully compiled, gave the following error ../../src/msw/mediactrl_am.cpp: In member function 'void wxAMMediaEvtHandler :: On ActiveX (wxActiveXEvent &) ': ../../src/msw/mediactrl_am.cpp:2234:10: error: narrowing conversion of '42949666 87 'from' unsigned int 'to' long int '[-Wnarrowing] 2234 | case 0xfffffd9f: // readystatechange in IActiveMovie2 and IMediaPlay er | ^
~~~~~ makefile.gcc: 7136: recipe for target 'gcc_mswudll \ monodll_mediactrl_am.o' failedmingw32-make: *** [gcc_mswudll \ monodll_mediactrl_am.o] Error 1
вс, 31 окт. 2021 г. в 12:53, Stefano D. Mtangoo < @.***>:
Note: SQLite bundled is not the latest but I plan to update it in foreseeable future!
— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/mtangoo/wxDatabase/issues/25#issuecomment-955677431, or unsubscribe https://github.com/notifications/unsubscribe-auth/AJ3OGDXI64EHWF3OBBJOU23UJUNZ5ANCNFSM5G42JJHQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.
Take a look at the error being thrown. long int is 4 bytes, and SQLLEN on a 64 bit system is 8 bytes. Therefore, there is no implicit conversion of a 4-byte pointer to an 8-byte pointer.
вт, 2 нояб. 2021 г. в 07:02, Андрей Мельниченко @.***>:
Build wxWidgets without MONOLITHIC option But wxDatabase is not going to [image: mono.jpg][image: cmake.jpg][image: gcc.jpg]
пн, 1 нояб. 2021 г. в 20:59, Андрей Мельниченко @.***>:
Good evening! I wanted to clarify whether it matters with which keys wxWidgets is built? If I use the version of the compiler in conjunction with CodeBlocks, the build is successful. And if I use the tdm64-gcc-10.3.0-2.exe compiler, then the build fails.
пн, 1 нояб. 2021 г. в 15:12, Андрей Мельниченко @.***
:
The library is not being built. These were the same problems https://aur.archlinux.org/packages/mingw-w64-wxmsw/
пн, 1 нояб. 2021 г. в 13:23, Андрей Мельниченко @.***
:
Good day! According to your instructions, I downloaded the specified versions of wxWidgets, Smake, MinGW. Launched building the library with the following keys mingw32-make -f makefile.gcc SHARED = 1 UNICODE = 1 MONOLITHIC = 1 BUILD = release The library was not fully compiled, gave the following error ../../src/msw/mediactrl_am.cpp: In member function 'void wxAMMediaEvtHandler :: On ActiveX (wxActiveXEvent &) ': ../../src/msw/mediactrl_am.cpp:2234:10: error: narrowing conversion of '42949666 87 'from' unsigned int 'to' long int '[-Wnarrowing] 2234 | case 0xfffffd9f: // readystatechange in IActiveMovie2 and IMediaPlay er | ^
~~~~~ makefile.gcc: 7136: recipe for target 'gcc_mswudll \ monodll_mediactrl_am.o' failedmingw32-make: *** [gcc_mswudll \ monodll_mediactrl_am.o] Error 1
вс, 31 окт. 2021 г. в 12:53, Stefano D. Mtangoo < @.***>:
Note: SQLite bundled is not the latest but I plan to update it in foreseeable future!
— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/mtangoo/wxDatabase/issues/25#issuecomment-955677431, or unsubscribe https://github.com/notifications/unsubscribe-auth/AJ3OGDXI64EHWF3OBBJOU23UJUNZ5ANCNFSM5G42JJHQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.
Hi Melandr, the wxMediaCtrl error is indeed issue in wxWidgets. You can see suggested fix in wxWidgets forum. Just copy that error and paste on the forum to see thread about it and suggestion by DoubleMax to fix it. I don't have time to search it right now.
Take a look at the error being thrown. long int is 4 bytes, and SQLLEN on a 64 bit system is 8 bytes. Therefore, there is no implicit conversion of a 4-byte pointer to an 8-byte pointer. You surely didn't update to latest version. Make sure you update your local copy to match latest version with a fix run:
git pull --rebase
And another question, which version of wxWidgets would you recommend building - 3.0.5 or 3.1.5?
вт, 2 нояб. 2021 г. в 10:56, Stefano D. Mtangoo @.***>:
Hi Melandr, the wxMediaCtrl error is indeed issue in wxWidgets. You can see suggested fix in wxWidgets forum. Just copy that error and paste on the forum to see thread about it and suggestion by DoubleMax to fix it. I don't have time to search it right now.
Take a look at the error being thrown. long int is 4 bytes, and SQLLEN on a 64 bit system is 8 bytes. Therefore, there is no implicit conversion of a 4-byte pointer to an 8-byte pointer. You surely didn't update to latest version. Make sure you update your local copy to match latest version with a fix run: git pull --rebase
— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/mtangoo/wxDatabase/issues/25#issuecomment-957235326, or unsubscribe https://github.com/notifications/unsubscribe-auth/AJ3OGDWVFRVHJHMKUXPLLWLUJ6RTRANCNFSM5G42JJHQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.
And another question, which version of wxWidgets would you recommend building - 3.0.5 or 3.1.5?
If you have no constraints in your project, I suggest you with the latest development, which is 3.1.5 If you project will be release some future time like 1yr later, I suggest you use latest master trunk
Did you resolve your problem?
Many thanks! after your corrections, the library was built without errors
Glad that your issue was resolved! Please if you find anything not working, don't hesitate to open an issu, PR or both. Wish you success!
Goodnight! The example in the library is compiled, but precompilation is used. do not tell me which header files need to be included, without using precompilation?
вт, 2 нояб. 2021 г. в 18:32, Stefano D. Mtangoo @.***>:
Glad that your issue was resolved! Please if you find anything not working, don't hesitate to open an issu, PR or both. Wish you success!
— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub https://github.com/mtangoo/wxDatabase/issues/25#issuecomment-957923299, or unsubscribe https://github.com/notifications/unsubscribe-auth/AJ3OGDXLUMSYVXZPTLDTPHLUKAHCRANCNFSM5G42JJHQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.
What dependencies do you need to include in the CodeBlocks project in order to compile the example in the library?
ср, 3 нояб. 2021 г. в 00:14, Андрей Мельниченко @.***>:
Goodnight! The example in the library is compiled, but precompilation is used. do not tell me which header files need to be included, without using precompilation?
вт, 2 нояб. 2021 г. в 18:32, Stefano D. Mtangoo @.***
:
Glad that your issue was resolved! Please if you find anything not working, don't hesitate to open an issu, PR or both. Wish you success!
— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub https://github.com/mtangoo/wxDatabase/issues/25#issuecomment-957923299, or unsubscribe https://github.com/notifications/unsubscribe-auth/AJ3OGDXLUMSYVXZPTLDTPHLUKAHCRANCNFSM5G42JJHQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.
Or is it necessary to specify the complete project structure as in the example? [image: проект.jpg]
ср, 3 нояб. 2021 г. в 00:27, Андрей Мельниченко @.***>:
What dependencies do you need to include in the CodeBlocks project in order to compile the example in the library?
ср, 3 нояб. 2021 г. в 00:14, Андрей Мельниченко @.***>:
Goodnight! The example in the library is compiled, but precompilation is used. do not tell me which header files need to be included, without using precompilation?
вт, 2 нояб. 2021 г. в 18:32, Stefano D. Mtangoo @.***
:
Glad that your issue was resolved! Please if you find anything not working, don't hesitate to open an issu, PR or both. Wish you success!
— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub https://github.com/mtangoo/wxDatabase/issues/25#issuecomment-957923299, or unsubscribe https://github.com/notifications/unsubscribe-auth/AJ3OGDXLUMSYVXZPTLDTPHLUKAHCRANCNFSM5G42JJHQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.
Can you open new issue if there is something else? Also Github does not show images that you send by replying email. Writing reply directly to Github will be best way to solve that!
I'm trying to build wxDatabase for the MinGW compiler. Below is the build log with an error. what am I doing wrong? Thank you all in advance for your help!
c:\Library\wxDatabase\build>mingw32-make -f makefile WX_SHARED=1 WX_MONOLITHIC=1 WX_UNICODE=1 WX_DEBUG=0 WX_DIR="c:\Library\wxwidgets" [ 5%] Building CXX object CMakeFiles/wxdatabase.dir/src/base/dbconf.cpp.obj [ 10%] Building CXX object CMakeFiles/wxdatabase.dir/src/base/wxprec.cpp.obj [ 15%] Building CXX object CMakeFiles/wxdatabase.dir/src/base/xmlconf.cpp.obj [ 21%] Building CXX object CMakeFiles/wxdatabase.dir/src/database/database.cpp.obj [ 26%] Building CXX object CMakeFiles/wxdatabase.dir/src/database/error_reporter.cpp.obj [ 31%] Building CXX object CMakeFiles/wxdatabase.dir/src/database/prepared_statement.cpp.obj [ 36%] Building CXX object CMakeFiles/wxdatabase.dir/src/database/query_parser.cpp.obj [ 42%] Building CXX object CMakeFiles/wxdatabase.dir/src/database/resultset.cpp.obj [ 47%] Building CXX object CMakeFiles/wxdatabase.dir/src/database/string_converter.cpp.obj [ 52%] Building CXX object CMakeFiles/wxdatabase.dir/src/database/wxprec.cpp.obj [ 57%] Building CXX object CMakeFiles/wxdatabase.dir/src/database/odbc/odbc_database.cpp.obj [ 63%] Building CXX object CMakeFiles/wxdatabase.dir/src/database/odbc/odbc_inteface.cpp.obj [ 68%] Building CXX object CMakeFiles/wxdatabase.dir/src/database/odbc/odbc_param.cpp.obj C:\Library\wxDatabase\src\database\odbc\odbc_param.cpp: In member function 'SQLLEN* wxOdbcParameter::GetParameterLengthPtr()': C:\Library\wxDatabase\src\database\odbc\odbc_param.cpp:255:11: error: cannot convert 'long int*' to 'SQLLEN*' {aka 'long long int*'} in return return &m_nBufferLength; ^~~~~~~~~~~~~~~ mingw32-make[2]: *** [CMakeFiles\wxdatabase.dir\build.make:256: CMakeFiles/wxdatabase.dir/src/database/odbc/odbc_param.cpp.obj] Error 1 mingw32-make[1]: *** [CMakeFiles\Makefile2:84: CMakeFiles/wxdatabase.dir/all] Error 2 mingw32-make: *** [makefile:135: all] Error 2