Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. International
  3. Italian
  4. Problema con QPSQL
Forum Updated to NodeBB v4.3 + New Features

Problema con QPSQL

Scheduled Pinned Locked Moved Solved Italian
4 Posts 2 Posters 1.0k Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • F Offline
    F Offline
    fermatqt
    wrote on last edited by fermatqt
    #1

    ciao!

    sto cercando di connettere una mia applicazione ad un db PostgreSQL installato su un altro pc:

    void MainWindow::on_pushButton_clicked() {
        QSqlDatabase db = QSqlDatabase::addDatabase("QPSQL");
        db.setHostName("192.168.1.31");
        db.setDatabaseName("test");
        db.setUserName("postgres");
        db.setPassword("postgres");
        bool ok = db.open();
    
        if (ok) {
            QSqlQuery query("SELECT * FROM persone");
            while (query.next()) {
                qWarning() << query.value(0).toString();
                qWarning() << query.value(1).toString();
                qWarning() << query.value(2).toString();
                qWarning() << query.value(3).toString();
            }
    
            qDebug() << query.lastError().text();
        }
    }
    

    quando avvio il programma, ottengo questo errore:

    QSqlDatabase: QPSQL driver not loaded
    QSqlDatabase: available drivers: QIBASE QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7 QTDS QTDS7
    

    ho provato a leggere un pò in giro, ma trovo solo errori riguardanti windows.
    invece la mia applicazione la sto facendo su linux.
    ovviamente non ho installato postgresql anche qui, sarebbe inutile.

    qualche idea al riguardo??

    1 Reply Last reply
    0
    • F Offline
      F Offline
      fermatqt
      wrote on last edited by
      #2

      vi aggiungo anche questa informazione:

      # ls -l /usr/lib/qt/plugins/sqldrivers/
      totale 480
      -rwxr-xr-x 1 root root 100184 14 gen 20.51 libqsqlibase.so
      -rwxr-xr-x 1 root root  67408 14 gen 20.51 libqsqlite.so
      -rwxr-xr-x 1 root root  75600 14 gen 20.51 libqsqlmysql.so
      -rwxr-xr-x 1 root root  96080 14 gen 20.51 libqsqlodbc.so
      -rwxr-xr-x 1 root root  79696 14 gen 20.51 libqsqlpsql.so
      -rwxr-xr-x 1 root root  59216 14 gen 20.51 libqsqltds.so
      

      mi sembra ci sia la libreria!

      1 Reply Last reply
      0
      • VRoninV Offline
        VRoninV Offline
        VRonin
        wrote on last edited by
        #3

        usa ldd su libqsqlpsql. probabilmente ti manca qualche libreria interna a postgre. Sospetto numero 1: ti manca libpq

        "La mort n'est rien, mais vivre vaincu et sans gloire, c'est mourir tous les jours"
        ~Napoleon Bonaparte

        On a crusade to banish setIndexWidget() from the holy land of Qt

        1 Reply Last reply
        0
        • F Offline
          F Offline
          fermatqt
          wrote on last edited by
          #4

          si era quello!

          su arch linux si chiama libpqxx.
          installato quello funziona tutto.
          grazie!!

          1 Reply Last reply
          0

          • Login

          • Login or register to search.
          • First post
            Last post
          0
          • Categories
          • Recent
          • Tags
          • Popular
          • Users
          • Groups
          • Search
          • Get Qt Extensions
          • Unsolved