×

Discussion Board

Results 1 to 14 of 14
  1. #1
    Registered User
    Join Date
    Jun 2010
    Posts
    4

    Postgres database driver problem

    Hello! I posted a thread few day ago of how to connect with my symbian phone to a database. I read the qt sql class reference and I tried to implement on the phone. The problem now is that I'm using a postgres database and QtCreator returns " QSqlDatabase: QPSQL driver not loaded, QSqlDatabase: available drivers: QSQLITE"

    Is there a a way to load QPSQL driver on a s60 3rd 3.2 phone? Or the only database driver supported is QSQLITE?

    Thank you

  2. #2
    Super Contributor
    Join Date
    Oct 2008
    Location
    INDIA
    Posts
    2,326

    Re: Postgres database driver problem

    Hi,luisr
    Currently QSql class is available for database integration with SQL.

    See this below link in which the supported modules are listed with meaning :

    Modules

    Best regards,
    RaHuL

  3. #3
    Registered User
    Join Date
    Jun 2010
    Posts
    4

    Re: Postgres database driver problem

    Thank you for your reply. I read all QSql class and tried to implement it but my problem is still there. QSQLite is the only database driver reported by the phone.
    Is there really a way to connect to a postgres database with QSql from a symbian phone?

  4. #4
    Nokia Developer Champion
    Join Date
    Nov 2009
    Location
    Minnesota, USA
    Posts
    3,209

    Re: Postgres database driver problem

    I believe you'll have to write your own driver, or find one someone else has built.

  5. #5
    Registered User
    Join Date
    Jun 2010
    Location
    Nantes, France
    Posts
    37

    Re: Postgres database driver problem

    I am facing the same problem with MySQL for Symbian. It doesn't seem to be supported. But how to connect my application to a remote sql server ? I have looked for a symbian mysql client but haven't found one so far. Could this third party library integrated in a Qt project ?

    Are there any plans to support anything more than just SQlite ? This connectivity is vital for my application and I wasn't aware of this lack under symbian. I think differences between platform features should be more highlighted on Qt's website.

    Has anybody ever tried to write its own driver ? Is it doable with QSqlDriver class ?

    Thanks

  6. #6
    Super Contributor
    Join Date
    Oct 2008
    Location
    INDIA
    Posts
    2,326

    Re: Postgres database driver problem

    Hi, Guilo

    For your SQL related query go here : http://doc.trolltech.com/4.5/qtsql.html


    But how to connect my application to a remote sql server ?
    Create your data base using QSqlDatabase class and then put them in one link by server.

    Now access that page by opening the page from browser, means connect your mobile with that server page.

    Best regards,
    RaHuL

  7. #7
    Registered User
    Join Date
    Jun 2010
    Location
    Nantes, France
    Posts
    37

    Re: Postgres database driver problem

    I am sorry, I am not sure to understand :

    Create your data base using QSqlDatabase class
    Ok, this is already done. My application works fine on Simulator, connecting to the remote MySQL. The problem is that when I compile for Symbian, there will be no driver allowing my application to connect to the remote MySQL server. Please tell me if I am wrong.

    and then put them in one link by server.
    I don't get you on that point.

    Thanks for sharing.
    Last edited by Guilo19; 2010-06-28 at 13:43.

  8. #8
    Registered User
    Join Date
    Mar 2009
    Posts
    16

    Re: Postgres database driver problem

    Qt for Symbian only supports the SQLite database at this point. Qt in general has more database backends, but relies on client libraries which are not available for Symbian.

  9. #9
    Registered User
    Join Date
    Jun 2010
    Location
    Nantes, France
    Posts
    37

    Re: Postgres database driver problem

    Yeah for sure but I have seen many applications on symbian connecting to a remote server. Isn't there a library, not necessarily Qt-related to connected to a remote server. And if yes, is it possible to integrate it in Qt Creator

  10. #10
    Super Contributor
    Join Date
    Oct 2008
    Location
    INDIA
    Posts
    2,326

    Re: Postgres database driver problem

    Hi, Guilo19
    There are two articles available in the Qt wiki one is adding data to the webpage and one is retrieving it .
    Just check this it may help you.

    http://wiki.forum.nokia.com/index.ph...WebKit,_and_Qt
    http://wiki.forum.nokia.com/index.ph...WebKit,_and_Qt

    Best regards,
    RaHuL

  11. #11
    Registered User
    Join Date
    Jun 2010
    Location
    Nantes, France
    Posts
    37

    Re: Postgres database driver problem

    Thanks for the links but it may not suit all my needs. I have checked about PAMP which contains a port of MySQL to Symbian. But trouble is that is has been compiled with armv5 and winscw only. So there is no chance to have this running on Symbian with Qt ?

    And what about this ? http://www.oracle.com/technology/sof...0gsymbian.html

  12. #12
    Nokia Developer Champion
    Join Date
    Nov 2009
    Location
    Minnesota, USA
    Posts
    3,209

    Re: Postgres database driver problem

    If you've got a Symbian implementation it's not too hard to implement the "glue" that will allow access from Qt.

  13. #13
    Registered User
    Join Date
    Mar 2009
    Posts
    16

    Re: Postgres database driver problem

    I agree with Dan. Please create a suggestion with a pointer to the sources at http://bugreports.qt.nokia.com.

  14. #14
    Registered User
    Join Date
    Jun 2010
    Location
    Nantes, France
    Posts
    37

    Re: Postgres database driver problem

    Does anybody know about a kind of "proxy" server that I could connect trough http, sending requests ? That server would run next to my remote SQL server and relay the queries and answers. It would be another way to achieve mysql (or postegre maybe) queries on symbian.

Similar Threads

  1. Problems querying a postgres database from a servlet
    By Orquidea10 in forum Mobile Java General
    Replies: 16
    Last Post: 2009-04-16, 18:08
  2. PAMP with php and postgres
    By tftd in forum Mobile Web Server
    Replies: 4
    Last Post: 2008-10-23, 21:50
  3. DKU-5 Cable Data Driver Problem
    By madfenix in forum General Development Questions
    Replies: 1
    Last Post: 2006-12-11, 17:05
  4. Replies: 0
    Last Post: 2003-10-23, 16:04
  5. Printer driver UI - problem
    By vvv121 in forum Symbian
    Replies: 2
    Last Post: 2002-11-20, 10:19

Posting Permissions

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