×

Discussion Board

Results 1 to 9 of 9
  1. #1
    Registered User
    Join Date
    Oct 2010
    Posts
    10

    ODBC driver on Symbian

    Hello, I have another question

    I am developing an application for Symbian (OS v9.4, Series 60 rel. 5), QT creator is on Win7. I need to connect remotely to a MSSQL database. For desktop app debugging, I can do that by placing odbc dlls in SDK's directory, but I don't know how to connect when compiling the application to a cell phone (N97 mini). Can the odbc dlls somehow be "included" in the .sis file so that the phone "knows" how to connect, or is there a better way to do that? The error that QT creator reports (when the project is directly compiled onto the phone from creator) is:
    [Qt Message] QSqlDatabase: QODBC driver not loaded
    [Qt Message] QSqlDatabase: available drivers: QSQLITE

    A detailed explanation would be much appreciated
    Last edited by divanov; 2010-12-20 at 15:14.

  2. #2
    Super Contributor
    Join Date
    Mar 2004
    Location
    Singapore
    Posts
    9,968

    Re: ODBC driver on Symbian

    reason being that by default the Qt For Symbian only generates QSQLITE driver. If you really want to user other drivers you can generate them using configuration flags while compiling from Qt sources.

  3. #3
    Registered User
    Join Date
    Oct 2010
    Posts
    10

    Re: ODBC driver on Symbian

    Would you like to write down configuration flags that I have to use in my symbian application, please?

  4. #4
    Super Contributor
    Join Date
    Oct 2009
    Posts
    4,326

  5. #5
    Registered User
    Join Date
    Oct 2010
    Posts
    10

    Re: ODBC driver on Symbian

    On this site I need to purcase "ODBC Driver for SQL Server 7.0, 2000, 2005, 2008 and Express", but is there any "less expensive" solution to my problem with SQL Server ODBC Driver?

    I've been compiling my project with:

    in .pro file:

    Code:
    QTPLUGIN+=qsqlodbc
    and in main.cpp file:

    Code:
    #include <QtPlugin>
    Q_IMPORT_PLUGIN(qsqlodbc)
    but it still doesn't work?!

    It makes this error:
    Code:
    undefined reference to 'qt_plugin_instance_qsqlodbc'.
    Any suggestions?

  6. #6
    Super Contributor
    Join Date
    Mar 2004
    Location
    Singapore
    Posts
    9,968

    Re: ODBC driver on Symbian

    Quote Originally Posted by zoxter001 View Post
    Would you like to write down configuration flags that I have to use in my symbian application, please?
    if you run configure --help

    -plugin-sql-<driver> Enable SQL <driver> as a plugin to be linked to at run
    time.
    Available values for <driver>:
    mysql
    psql
    oci
    odbc
    tds
    db2
    + sqlite
    sqlite2
    ibase
    (drivers marked with a '+' have been detected as
    available on this system)
    then you can added the required driver generate the corressponding driver.

  7. #7
    Registered User
    Join Date
    Oct 2010
    Posts
    10

    Re: ODBC driver on Symbian

    I've wrote configuration -plugin-sql-odbc in cmd.exe and I get this error:

    Code:
    Creating qmake...
    execute: File or path is not found (mingw32-make)
    Do I need to compile my program with full path of mingw32-make and which parameters I need to add? Or is there another way to resolve this problem out?

    Full output after writing configuration -plugin-sql-odbc in cmd.exe:

    Code:
    C:\Qt\4.7.1-symbian>configure -plugin-sql-odbc
    Which edition of Qt do you want to use ?
    Type 'c' if you want to use the Commercial Edition.
    Type 'o' if you want to use the Open Source Edition.
    o
    
    This is the Qt for Windows Open Source Edition.
    
    You are licensed to use this software under the terms of
    the GNU Lesser General Public License (LGPL) version 2.1
    or the GNU General Public License (GPL) version 3.
    
    Type '3' to view the GNU General Public License version 3 (GPLv3).
    Type 'L' to view the Lesser GNU General Public License version 2.1 (LGPLv2.1).
    Type 'y' to accept this license offer.
    Type 'n' to decline this license offer.
    
    Do you accept the terms of the license?
    y
    All the required DirectShow/Direct3D files couldn't be found.
    Make sure you have either the platform SDK AND the DirectShow SDK or the Windows
     SDK installed.
    If you have the DirectShow SDK installed, please make sure that you have run the
     <path to SDK>\SetEnv.Cmd script.
    vmr9.h not found
    dshow.h not found
    strmiids.lib not found
    dmoguids.lib not found
    msdmo.lib not found
    d3d9.h not found
    Environment:
        INCLUDE=
          Unset
        LIB=
          Unset
        PATH=
          C:\Qt\2010.05\bin
          C:\Qt\2010.05\qt\bin
          C:\Qt\2010.05\mingw\mingw32\bin
          C:\Perl\site\bin
          C:\Perl\bin
          C:\Program Files\Nokia\PC Connectivity Solution\
          C:\Program Files\Common Files\Microsoft Shared\Windows Live
          C:\Windows\system32
          C:\Windows
          C:\Windows\System32\Wbem
          C:\Windows\System32\WindowsPowerShell\v1.0\
          C:\Program Files\Windows Live\Shared
          C:\Program Files\Microsoft SQL Server\100\Tools\Binn\
          C:\Program Files\Microsoft SQL Server\100\DTS\Binn\
          C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\
          C:\Program Files\Common Files\Symbian\tools
          C:\Program Files\CSL Arm Toolchain\bin
          C:\AppServ\Apache2.2\bin
          C:\AppServ\php5
          C:\AppServ\MySQL\bin
    You are licensed to use this software under the terms of the GNU GPL version 3.Y
    ou are licensed to use this software under the terms of the Lesser GNU LGPL vers
    ion 2.1.
    See C:/Qt/4.7.1-symbian3
    
     or C:/Qt/4.7.1-symbianL
    
    Configuration:
        minimal-config
        small-config
        medium-config
        large-config
        full-config
        build_all
        debug
    Qt Configuration:
        release
        debug
        zlib
        png
        accessibility
        qt3support
        opengl
        s60
        ipv6
        script
        scripttools
        xmlpatterns
        multimedia
        audio-backend
        declarative
        native-gestures
        svg
        minimal-config
        small-config
        medium-config
        large-config
        full-config
    
    QMAKESPEC...................win32-g++ (detected)
    Architecture................windows
    Maketool....................mingw32-make
    Debug symbols...............yes
    Link Time Code Generation...no
    Accessibility support.......yes
    STL support.................yes
    Exception support...........yes
    RTTI support................yes
    MMX support.................yes
    3DNOW support...............no
    SSE support.................yes
    SSE2 support................yes
    IWMMXT support..............no
    OpenGL support..............yes
    OpenVG support..............no
    OpenSSL support.............no
    QtDBus support..............no
    QtXmlPatterns support.......yes
    Phonon support..............no
    QtMultimedia support........yes
    WebKit support..............yes
    Declarative support.........yes
    Declarative debugging.......yes
    QtScript support............yes
    QtScriptTools support.......yes
    Graphics System.............raster
    Qt3 compatibility...........yes
    
    Third Party Libraries:
        ZLIB support............qt
        GIF support.............plugin
        TIFF support............plugin
        JPEG support............plugin
        PNG support.............yes
        MNG support.............plugin
        FreeType support........no
    
    Styles:
        Windows.................yes
        Windows XP..............no
        Windows Vista...........no
        Plastique...............yes
        Cleanlooks..............yes
        Motif...................yes
        CDE.....................yes
        Windows CE..............no
        Windows Mobile..........no
        S60.....................no
    
    Sql Drivers:
        ODBC....................plugin
        MySQL...................no
        OCI.....................no
        PostgreSQL..............no
        TDS.....................no
        DB2.....................no
        SQLite..................plugin (qt)
        SQLite2.................no
        InterBase...............no
    
    Sources are in..............C:\Qt\4.7.1-symbian
    Build is done in............C:\Qt\4.7.1-symbian
    Install prefix..............C:\Qt\4.7.1-symbian
    Headers installed to........C:/Qt/4.7.1-symbian/include
    Libraries installed to......C:/Qt/4.7.1-symbian/lib
    Plugins installed to........C:/Qt/4.7.1-symbian/plugins
    Imports installed to........C:/Qt/4.7.1-symbian/imports
    Binaries installed to.......C:/Qt/4.7.1-symbian/bin
    Docs installed to...........C:/Qt/4.7.1-symbian/doc
    Data installed to...........C:/Qt/4.7.1-symbian
    Translations installed to...C:/Qt/4.7.1-symbian/translations
    Examples installed to.......C:/Qt/4.7.1-symbian/examples
    Demos installed to..........C:/Qt/4.7.1-symbian/demos
    
    Creating qmake...
    execute: File or path is not found (mingw32-make)
    execute: File or path is not found (mingw32-make)
    Cleaning qmake failed, return code -1
    
    
    C:\Qt\4.7.1-symbian>

    And in my QT program there is still error:
    Code:
    undefined reference to 'qt_plugin_instance_qsqlodbc'.
    Last edited by zoxter001; 2010-12-21 at 08:00.

  8. #8
    Regular Contributor
    Join Date
    Sep 2008
    Posts
    286

    Re: ODBC driver on Symbian

    ODBC driver has not been ported for Symbian. You would need to first port it or make a suggestion for Nokia to port it.
    I doubt there will be enough people to support this use case so your best bet is to make the port yourself.
    Then comes the next part, how did you think it would handle the Phone - PC connection?

    I'd recommend to go with SQLite or find some other alternative way to get to the data.

  9. #9
    Super Contributor
    Join Date
    Mar 2004
    Location
    Singapore
    Posts
    9,968

    Re: ODBC driver on Symbian

    you have to use the Qt For Symbian console and you need the all the headers that are required,

    Note: I have not compiled ODBC driver for Symbian so donot know what all the problems / missing files you might encouter.

Similar Threads

  1. MySQL driver installation on Qt 4.7.0
    By mavi85bmn in forum [Archived] Qt SDKs and Tools
    Replies: 5
    Last Post: 2011-01-06, 17:25
  2. can't load MySql driver
    By mani_lachi in forum [Archived] Qt SDKs and Tools
    Replies: 7
    Last Post: 2009-12-17, 09:28
  3. Can I modify a driver of Symbian?
    By blueskiff in forum Symbian
    Replies: 2
    Last Post: 2006-09-12, 05:19
  4. Symbian client connect to MySQL server
    By taiffu in forum Symbian Networking & Messaging (Closed)
    Replies: 1
    Last Post: 2006-02-05, 17:42
  5. symbian driver
    By -James in forum Symbian
    Replies: 2
    Last Post: 2004-05-02, 06:40

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
×