On 09/08/2013 03:21 PM, Zippy Dufus wrote:
Hello again,

After a two year hiatus, I now need to use my favorite database tool TOra again.  But you changed the toolchain, arrrrrrgh!  (-;
Well autohell tool are hard to maintain. ksh93 and m4 are tool archaic and even-thought it is not really multi-platform.
CMAKE is simply better.

No matter.  I pulled the last SVN revision (4600) on the old tool chain and managed to cross-compile a mingw64 Windows 64bit build on a Fedora19 virtual machine with qt-4.8 and qscintilla 2.7.3 snapshot. [chest thumping!]  Too bad that I don't have the bleeding edge TOra code included!
What is your target platform? Where you compile sources and where do you want to use them?

Few months ago we had problems when SF migrated your repository and kept the original one open for commits. We had to sync these manually.
The latest source codes can be obtained from:
https://svn.code.sf.net/p/tora/code/branches/tora2_1_x           - Tora2 branch. Latest commit 4758
https://svn.code.sf.net/p/tora/code/trunk/tora                          - Tora3 branch (no release yet)  Latest commit 4813

For both you have to re-checkout sources. (svn update does not work)

Personally I never used cross-compile for Tora. On Windows I use Visual Studio Express (with the debugger of course).
Did you try to compile for Windows directly on Windows? MSVC Express is "freely" download-able and CMAKE directly generated  project files.
This approach is described in README.WINDOWS file (Tora3 version)


Additionally, this build includes ODBC support now that F19 ships the qt odbc mingw64 dll.  However, it took some research to determine that all I needed to do was add "set QT_PLUGIN_PATH=%TORA_DIR%\plugins" to my tora64.bat file.
So you're using QODBC (Qt ODBC wrapper) to connect to MS SQL server no Linux (on Windows)?
I now need ODBC because I will be working with MSSQL Server.  My Linux 4600 build also works fine with ODBC using the FreeTDS driver.

Questions:
  1. Is the code base stable enough for me to starting hacking?   I'm using revision 4817 and I am getting the error below.   Maybe I am missing something in my environment?
I would say it's very stable. But so far it works only with Oracle. Some core components were rewritten, especially: threading, locking and connection providers.
Partially Tora3 alse supports MySQL - through QMYSQL QT wrapper.
  1. I know nothing of cmake (yet).  Do you think it will be possible to use it to cross-compile to Windows?  Any hints where to start?
I think cmake supports Xcompilation, but I never used that. I use Xcompile it only for kernels and other low level stuff.
Moreover MSVC has very good compiler and debugger.
  1. With the ODBC connection, all the tools except the SQL Editor tool and Project Manager are disabled.  Is there a easy way to enable them with little or no code changes?  I am "imagining" that I could use the brilliant Edit SQL feature and override certain queries which support my workflows with their native MSSQL equivalents.  Would the TOra programming know the difference if the result set was identical?  The Schema Browser is of particular interest if only to review table layouts.  Does this sound feasible?
Yes. But unfortunately the "Project Manager" (aka TemplateEditor) is not so far supported in Tora3 version.
I had to put a lot of code into folder "obsolete" to make things working. So you have to recompile Tora each time you modify the SQL :(

In your opinion which option is more feasible for MSSQL support on Linux/Windows?
- use QSql through QODBC through FreeTDS
- use FreeTDS directly without any wrappers

For Oracle the OCI is used directly. It is very laborious. But on the other hand, is supports lot of Oracle's specific features
and there are no problems with QT's internal locking. (See QSQLDatabase docs. toQMySqlConnectionSub)

Keep up the excellent work!  You have made a lot of my co-workers happy over the years too.

Cheers!


[ 36%] Generating qrc_tora.cxx
Scanning dependencies of target tora
[ 36%] Building CXX object src/CMakeFiles/tora.dir/core/main.cpp.o
In file included from /home/tora/Linux/Tora3/tora/src/core/toconnectionprovider.h:44:0,
                 from /home/tora/Linux/Tora3/tora/src/core/main.cpp:44:
/home/tora/Linux/Tora3/tora/src/core/toconnection.h:277:26: error: ‘QMenu’ has not been declared
     void connectionsMenu(QMenu*);
                          ^

Should be fixed now.

Ivan