ODBC driver on Symbian

**zoxter001** · 2010-12-20, 13:49

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

**skumar_rao** · 2010-12-20, 17:00

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.

**zoxter001** · 2010-12-20, 17:31

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

**divanov** · 2010-12-20, 19:40

http://www.easysoft.com/developer/li...s/qt/odbc.html

**zoxter001** · 2010-12-20, 20:49

Originally Posted by divanov

http://www.easysoft.com/developer/li...s/qt/odbc.html

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?

**skumar_rao** · 2010-12-21, 06:54

Originally Posted by zoxter001

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.

**zoxter001** · 2010-12-21, 07:49

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'.

**jakoskin** · 2010-12-21, 07:59

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.

**skumar_rao** · 2010-12-21, 08:02

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.

Discussion Board

Thread: ODBC driver on Symbian

Thread Tools

Search Thread

Display

Similar Threads

MySQL driver installation on Qt 4.7.0

can't load MySql driver

Can I modify a driver of Symbian?

Symbian client connect to MySQL server

symbian driver

Posting Permissions