Page 1 of 2 12 LastLast
Results 1 to 20 of 39

Thread: Regading Driver to connect Postgresql Database

  1. #1
    Join Date
    Feb 2009
    Posts
    39
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

    Default Regading Driver to connect Postgresql Database

    Hi to all,


    I am facing problem while connecting postgresql database in windows environment. I have experience in Linux and i successfully working. but in windows im facing lots of problems. plz can any one resolve my problem.

    Waiting for your replies and suggestions.

    Regards,

    Narasimha Raju. Naidu

  2. #2
    Join Date
    Aug 2008
    Location
    Ukraine, Krivoy Rog
    Posts
    1,963
    Thanked 370 Times in 336 Posts
    Qt products
    Qt3 Qt4 Qt5
    Platforms
    MacOS X Unix/X11 Windows

    Default Re: Regading Driver to connect Postgresql Database

    what kind of problems do you have?
    Qt Assistant -- rocks!
    please, use tags [CODE] & [/CODE].

  3. #3
    Join Date
    Feb 2009
    Posts
    39
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

    Default Re: Regading Driver to connect Postgresql Database

    Hi,

    thanks for your reply. I am getting the following error:
    QSqlDatabase: QPSQL driver not loaded
    QSqlDatabase: available drivers: QSQLITE QODBC3 QODBC

    how can you resolve my problem?? I am working on windows....


    Regards,

    Narasimha Raju. Naidu

  4. #4
    Join Date
    Aug 2008
    Location
    Ukraine, Krivoy Rog
    Posts
    1,963
    Thanked 370 Times in 336 Posts
    Qt products
    Qt3 Qt4 Qt5
    Platforms
    MacOS X Unix/X11 Windows

    Default Re: Regading Driver to connect Postgresql Database

    you need to build PSQL driver. read this building of PSQL driver.
    Qt Assistant -- rocks!
    please, use tags [CODE] & [/CODE].

  5. #5
    Join Date
    Feb 2009
    Posts
    39
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

    Default Re: Regading Driver to connect Postgresql Database

    Hi,

    Thanks for your reply.

    I gone through the link very early. but i failed to build becoz,
    in the following command there is no folder like [ms] in my postgresql lib directory

    cd %QTDIR%\src\plugins\sqldrivers\psql
    qmake "INCLUDEPATH+=C:\psql\include" "LIBS+=C:\psql\lib\[ms]\libpq.lib" psql.pro
    nmake


    and also i am getting nmake unknown command

    is it possible to resolve my problem????

    waiting for your reply

    Regards,

    Narasimha Raju. Naidu

  6. #6
    Join Date
    Aug 2008
    Location
    Ukraine, Krivoy Rog
    Posts
    1,963
    Thanked 370 Times in 336 Posts
    Qt products
    Qt3 Qt4 Qt5
    Platforms
    MacOS X Unix/X11 Windows

    Default Re: Regading Driver to connect Postgresql Database

    looks like you use MinGW, right?
    Qt Assistant -- rocks!
    please, use tags [CODE] & [/CODE].

  7. #7
    Join Date
    Aug 2008
    Location
    Ukraine, Krivoy Rog
    Posts
    1,963
    Thanked 370 Times in 336 Posts
    Qt products
    Qt3 Qt4 Qt5
    Platforms
    MacOS X Unix/X11 Windows

    Default Re: Regading Driver to connect Postgresql Database

    try to do this
    cd %QTDIR%\src\plugins\sqldrivers\psql
    qmake "INCLUDEPATH+=%PSQLDIR%\psql\include" "LIBS+=%PSQLDIR%\lib\libpq.lib" psql.pro
    mingw32-make
    Qt Assistant -- rocks!
    please, use tags [CODE] & [/CODE].

  8. #8
    Join Date
    Feb 2009
    Posts
    39
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

    Default Re: Regading Driver to connect Postgresql Database

    Hi,
    Thanks for your reply.
    I did according to your instructions. I got the following result with errors
    -------------------------------
    C:\Qt\4.3.4\src\plugins\sqldrivers\psql>mingw32-make
    mingw32-make -f Makefile.Release
    mingw32-make[1]: Entering directory `C:/Qt/4.3.4/src/plugins/sqldrivers/psql'
    g++ -c -O2 -frtti -fexceptions -mthreads -Wall -DUNICODE -DQT_LARGEFILE_SUPPORT
    -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_DLL -DQT_NO_DEBUG -DQT_PLUGIN
    -DQT_SQL_LIB -DQT_CORE_LIB -DQT_THREAD_SUPPORT -I"..\..\..\..\include\QtCore" -
    I"..\..\..\..\include\QtCore" -I"..\..\..\..\include\QtSql" -I"..\..\..\..\inclu
    de\QtSql" -I"..\..\..\..\include" -I"c:\Program" -I"Files\PostgreSQL\8.3\include
    " -I"c:\Qt\4.3.4\include\ActiveQt" -I"tmp\moc\release_shared" -I"." -I"..\..\..\
    ..\mkspecs\win32-g++" -o tmp\obj\release_shared\main.o main.cpp
    g++ -c -O2 -frtti -fexceptions -mthreads -Wall -DUNICODE -DQT_LARGEFILE_SUPPORT
    -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_DLL -DQT_NO_DEBUG -DQT_PLUGIN
    -DQT_SQL_LIB -DQT_CORE_LIB -DQT_THREAD_SUPPORT -I"..\..\..\..\include\QtCore" -
    I"..\..\..\..\include\QtCore" -I"..\..\..\..\include\QtSql" -I"..\..\..\..\inclu
    de\QtSql" -I"..\..\..\..\include" -I"c:\Program" -I"Files\PostgreSQL\8.3\include
    " -I"c:\Qt\4.3.4\include\ActiveQt" -I"tmp\moc\release_shared" -I"." -I"..\..\..\
    ..\mkspecs\win32-g++" -o tmp\obj\release_shared\qsql_psql.o ..\..\..\sql\drivers
    \psql\qsql_psql.cpp
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:57:22: libpq-fe.h: No such file or direc
    tory
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In function `QSqlError qMakeError(const
    QString&, QSqlError::ErrorType, const QPSQLDriverPrivate*)':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:147: error: `PQerrorMessage' undeclared
    (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:147: error: (Each undeclared identifier
    is reported only once for each function it appears in.)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `bool QPSQLResultPri
    vate:rocessResults()':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:157: error: `PQresultStatus' undeclared
    (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:158: error: `PGRES_TUPLES_OK' undeclared
    (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:161: error: `PQntuples' undeclared (firs
    t use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:163: error: `PGRES_COMMAND_OK' undeclare
    d (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `void QPSQLResult::c
    leanup()':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:241: error: `PQclear' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual bool QPSQLR
    esult::fetchLast()':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:269: error: `PQntuples' undeclared (firs
    t use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual QVariant QP
    SQLResult::data(int)':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:274: error: `PQnfields' undeclared (firs
    t use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:278: error: `PQftype' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:280: error: `PQgetvalue' undeclared (fir
    st use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:281: error: `PQgetisnull' undeclared (fi
    rst use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:343: error: `PQunescapeBytea' undeclared
    (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual bool QPSQLR
    esult::isNull(int)':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:357: error: `PQgetvalue' undeclared (fir
    st use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:358: error: `PQgetisnull' undeclared (fi
    rst use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual bool QPSQLR
    esult::reset(const QString&)':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:370: error: `PQexec' undeclared (first u
    se this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual int QPSQLRe
    sult::numRowsAffected()':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:381: error: `PQcmdTuples' undeclared (fi
    rst use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual QVariant QP
    SQLResult::lastInsertId() const':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:387: error: `Oid' undeclared (first use
    this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:387: error: expected `;' before "id"
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:388: error: `id' undeclared (first use t
    his function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:388: error: `InvalidOid' undeclared (fir
    st use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual QSqlRecord
    QPSQLResult::record() const':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:400: error: `PQnfields' undeclared (firs
    t use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:404: error: `PQfname' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:407: error: `PQftype' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:408: error: `PQfsize' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:409: error: `PQfmod' undeclared (first u
    se this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In function `bool setEncodingUtf8(PGcon
    n*)':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:427: error: `PQexec' undeclared (first u
    se this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:428: error: `PQresultStatus' undeclared
    (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:429: error: `PQclear' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:430: error: `PGRES_COMMAND_OK' undeclare
    d (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In function `void setDatestyle(PGconn*)
    ':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:435: error: `PQexec' undeclared (first u
    se this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:436: error: `PQresultStatus' undeclared
    (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:437: error: `PGRES_COMMAND_OK' undeclare
    d (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:438: error: `PQerrorMessage' undeclared
    (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:439: error: `PQclear' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In function `QPSQLDriver::Protocol getP
    SQLVersion(PGconn*)':
    .
    .
    .

    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual bool QPSQLD
    river::rollbackTransaction()':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:648: error: `PQexec' undeclared (first u
    se this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:649: error: `PQresultStatus' undeclared
    (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:649: error: `PGRES_COMMAND_OK' undeclare
    d (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:652: error: `PQclear' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual QString QPS
    QLDriver::formatValue(const QSqlField&, bool) const':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:920: error: `PQescapeBytea' undeclared (
    first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual bool QPSQLD
    river::isOpen() const':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:946: error: `PQstatus' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:946: error: `CONNECTION_OK' undeclared (
    first use this function)
    mingw32-make[1]: *** [tmp/obj/release_shared/qsql_psql.o] Error 1
    mingw32-make[1]: Leaving directory `C:/Qt/4.3.4/src/plugins/sqldrivers/psql'
    mingw32-make: *** [release] Error 2
    C:\Qt\4.3.4\src\plugins\sqldrivers\psql>
    -----------------------------------
    Waiting for your reply...
    Regards,
    Narasimha Raju. Naidu

  9. #9
    Join Date
    Aug 2008
    Location
    Ukraine, Krivoy Rog
    Posts
    1,963
    Thanked 370 Times in 336 Posts
    Qt products
    Qt3 Qt4 Qt5
    Platforms
    MacOS X Unix/X11 Windows

    Default Re: Regading Driver to connect Postgresql Database

    looks like you didn't specify path to includes and lib for PostgreSQL.
    Qt Assistant -- rocks!
    please, use tags [CODE] & [/CODE].

  10. #10
    Join Date
    Feb 2009
    Posts
    39
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

    Default Re: Regading Driver to connect Postgresql Database

    No. Just i did not copied becoz reply will allow only 10000 characters only.

    Now i am sending including that one also


    C:\Qt\4.3.4\src\plugins\sqldrivers\psql>qmake "INCLUDEPATH+=c:\Program Files\Pos
    tgreSQL\8.3\include" "LIBS+=c:\Program Files\PostgreSQL\8.3\lib\libpq.dll" psql.
    pro

    C:\Qt\4.3.4\src\plugins\sqldrivers\psql>mingw32-make
    mingw32-make -f Makefile.Release
    mingw32-make[1]: Entering directory `C:/Qt/4.3.4/src/plugins/sqldrivers/psql'
    g++ -c -O2 -frtti -fexceptions -mthreads -Wall -DUNICODE -DQT_LARGEFILE_SUPPORT
    -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_DLL -DQT_NO_DEBUG -DQT_PLUGIN
    -DQT_SQL_LIB -DQT_CORE_LIB -DQT_THREAD_SUPPORT -I"..\..\..\..\include\QtCore" -
    I"..\..\..\..\include\QtCore" -I"..\..\..\..\include\QtSql" -I"..\..\..\..\inclu
    de\QtSql" -I"..\..\..\..\include" -I"c:\Program" -I"Files\PostgreSQL\8.3\include
    " -I"c:\Qt\4.3.4\include\ActiveQt" -I"tmp\moc\release_shared" -I"." -I"..\..\..\
    ..\mkspecs\win32-g++" -o tmp\obj\release_shared\qsql_psql.o ..\..\..\sql\drivers
    \psql\qsql_psql.cpp
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:57:22: libpq-fe.h: No such file or direc
    tory
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In function `QSqlError qMakeError(const
    QString&, QSqlError::ErrorType, const QPSQLDriverPrivate*)':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:147: error: `PQerrorMessage' undeclared
    (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:147: error: (Each undeclared identifier
    is reported only once for each function it appears in.)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `bool QPSQLResultPri
    vate:rocessResults()':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:157: error: `PQresultStatus' undeclared
    (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:158: error: `PGRES_TUPLES_OK' undeclared
    (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:161: error: `PQntuples' undeclared (firs
    t use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:163: error: `PGRES_COMMAND_OK' undeclare
    d (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `void QPSQLResult::c
    leanup()':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:241: error: `PQclear' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual bool QPSQLR
    esult::fetchLast()':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:269: error: `PQntuples' undeclared (firs
    t use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual QVariant QP
    SQLResult::data(int)':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:274: error: `PQnfields' undeclared (firs
    t use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:278: error: `PQftype' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:280: error: `PQgetvalue' undeclared (fir
    st use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:281: error: `PQgetisnull' undeclared (fi
    rst use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:343: error: `PQunescapeBytea' undeclared
    (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual bool QPSQLR
    esult::isNull(int)':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:357: error: `PQgetvalue' undeclared (fir
    st use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:358: error: `PQgetisnull' undeclared (fi
    rst use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual bool QPSQLR
    esult::reset(const QString&)':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:370: error: `PQexec' undeclared (first u
    se this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual int QPSQLRe
    sult::numRowsAffected()':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:381: error: `PQcmdTuples' undeclared (fi
    rst use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual QVariant QP
    SQLResult::lastInsertId() const':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:387: error: `Oid' undeclared (first use
    this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:387: error: expected `;' before "id"
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:388: error: `id' undeclared (first use t
    his function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:388: error: `InvalidOid' undeclared (fir
    st use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual QSqlRecord
    QPSQLResult::record() const':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:400: error: `PQnfields' undeclared (firs
    t use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:404: error: `PQfname' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:407: error: `PQftype' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:408: error: `PQfsize' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:409: error: `PQfmod' undeclared (first u
    se this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In function `bool setEncodingUtf8(PGcon
    n*)':
    .
    .
    .
    .
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual void QPSQLD
    river::close()':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:596: error: `PQfinish' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual bool QPSQLD
    river::beginTransaction()':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:614: error: `PQexec' undeclared (first u
    se this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:615: error: `PQresultStatus' undeclared
    (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:615: error: `PGRES_COMMAND_OK' undeclare
    d (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:616: error: `PQclear' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual bool QPSQLD
    river::commitTransaction()':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:631: error: `PQexec' undeclared (first u
    se this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:632: error: `PQresultStatus' undeclared
    (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:632: error: `PGRES_COMMAND_OK' undeclare
    d (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:633: error: `PQclear' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual bool QPSQLD
    river::rollbackTransaction()':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:648: error: `PQexec' undeclared (first u
    se this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:649: error: `PQresultStatus' undeclared
    (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:649: error: `PGRES_COMMAND_OK' undeclare
    d (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:652: error: `PQclear' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual QString QPS
    QLDriver::formatValue(const QSqlField&, bool) const':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:920: error: `PQescapeBytea' undeclared (
    first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual bool QPSQLD
    river::isOpen() const':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:946: error: `PQstatus' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:946: error: `CONNECTION_OK' undeclared (
    first use this function)
    mingw32-make[1]: *** [tmp/obj/release_shared/qsql_psql.o] Error 1
    mingw32-make[1]: Leaving directory `C:/Qt/4.3.4/src/plugins/sqldrivers/psql'
    mingw32-make: *** [release] Error 2

    C:\Qt\4.3.4\src\plugins\sqldrivers\psql>

    Regards

    Narasimha Raju. Naidu

  11. #11
    Join Date
    Aug 2008
    Location
    Ukraine, Krivoy Rog
    Posts
    1,963
    Thanked 370 Times in 336 Posts
    Qt products
    Qt3 Qt4 Qt5
    Platforms
    MacOS X Unix/X11 Windows

    Default Re: Regading Driver to connect Postgresql Database

    this is wrong
    LIBS+=c:\Program Files\PostgreSQL\8.3\lib\libpq.dll
    I mean libpq.dll must be libpq.a for creation this lib you need apply dlltool (which is located in bin dir of mingw) for libpq.dll.
    Qt Assistant -- rocks!
    please, use tags [CODE] & [/CODE].

  12. #12
    Join Date
    Feb 2009
    Posts
    39
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

    Default Re: Regading Driver to connect Postgresql Database

    Thanks for finding error. I found dlltool at bin directory of MinGW.

    now what should i do.

    Regards

    Narasimha Raju. Naidu

  13. #13
    Join Date
    Aug 2008
    Location
    Ukraine, Krivoy Rog
    Posts
    1,963
    Thanked 370 Times in 336 Posts
    Qt products
    Qt3 Qt4 Qt5
    Platforms
    MacOS X Unix/X11 Windows

    Default Re: Regading Driver to connect Postgresql Database

    this should help you
    edit: link updated.
    Qt Assistant -- rocks!
    please, use tags [CODE] & [/CODE].

  14. #14
    Join Date
    Feb 2009
    Posts
    39
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

    Default Re: Regading Driver to connect Postgresql Database

    Hi,

    Thanks for your replies and references. I did according to the instruction in the link. it successfully generated libpq.a file.

    What should i do now.....

    Waiting for your reply


    Regards,

    Narasimha Raju. Naidu

  15. #15
    Join Date
    Aug 2008
    Location
    Ukraine, Krivoy Rog
    Posts
    1,963
    Thanked 370 Times in 336 Posts
    Qt products
    Qt3 Qt4 Qt5
    Platforms
    MacOS X Unix/X11 Windows

    Default Re: Regading Driver to connect Postgresql Database

    do this
    qmake "INCLUDEPATH+=%POSTGRESQLDIR%\include" "LIBS+=%POSTGRESQLDIR%\lib\libpq.a" psql.pro
    mingw32-make
    that's all.
    PS. I forgot, for successfully launching application with PSQL driver you need to add PostgreSQL's bin directory to your PATH variable.
    Qt Assistant -- rocks!
    please, use tags [CODE] & [/CODE].

  16. #16
    Join Date
    Feb 2009
    Posts
    39
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

    Default Re: Regading Driver to connect Postgresql Database

    thanks for your reply. i did according to your instructions but i got the following result



    C:\Qt\4.3.4\src\plugins\sqldrivers\psql>qmake "INCLUDEPATH+=C:\Program Files\Pos
    tgreSQL\8.3\include" "LIBS+=c:\Program Files\PostgreSQL\8.3\lib\libpq.a" psql.pr
    o

    C:\Qt\4.3.4\src\plugins\sqldrivers\psql>mingw32-make
    mingw32-make -f Makefile.Release
    mingw32-make[1]: Entering directory `C:/Qt/4.3.4/src/plugins/sqldrivers/psql'
    g++ -c -O2 -frtti -fexceptions -mthreads -Wall -DUNICODE -DQT_LARGEFILE_SUPPORT
    -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_DLL -DQT_NO_DEBUG -DQT_PLUGIN
    -DQT_SQL_LIB -DQT_CORE_LIB -DQT_THREAD_SUPPORT -I"..\..\..\..\include\QtCore" -
    I"..\..\..\..\include\QtCore" -I"..\..\..\..\include\QtSql" -I"..\..\..\..\inclu
    de\QtSql" -I"..\..\..\..\include" -I"c:\Program" -I"Files\PostgreSQL\8.3\include
    " -I"c:\Qt\4.3.4\include\ActiveQt" -I"tmp\moc\release_shared" -I"." -I"..\..\..\
    ..\mkspecs\win32-g++" -o tmp\obj\release_shared\qsql_psql.o ..\..\..\sql\drivers
    \psql\qsql_psql.cpp
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:57:22: libpq-fe.h: No such file or direc
    tory
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In function `QSqlError qMakeError(const
    QString&, QSqlError::ErrorType, const QPSQLDriverPrivate*)':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:147: error: `PQerrorMessage' undeclared
    (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:147: error: (Each undeclared identifier
    is reported only once for each function it appears in.)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `bool QPSQLResultPri
    vate:rocessResults()':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:157: error: `PQresultStatus' undeclared
    (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:158: error: `PGRES_TUPLES_OK' undeclared
    (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:161: error: `PQntuples' undeclared (firs
    t use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:163: error: `PGRES_COMMAND_OK' undeclare
    d (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `void QPSQLResult::c
    leanup()':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:241: error: `PQclear' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual bool QPSQLR
    esult::fetchLast()':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:269: error: `PQntuples' undeclared (firs
    t use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual QVariant QP
    SQLResult::data(int)':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:274: error: `PQnfields' undeclared (firs
    t use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:278: error: `PQftype' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:280: error: `PQgetvalue' undeclared (fir
    st use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:281: error: `PQgetisnull' undeclared (fi
    rst use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:343: error: `PQunescapeBytea' undeclared
    (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual bool QPSQLR
    esult::isNull(int)':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:357: error: `PQgetvalue' undeclared (fir
    st use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:358: error: `PQgetisnull' undeclared (fi
    rst use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual bool QPSQLR
    esult::reset(const QString&)':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:370: error: `PQexec' undeclared (first u
    se this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual int QPSQLRe
    sult::numRowsAffected()':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:381: error: `PQcmdTuples' undeclared (fi
    rst use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual QVariant QP
    SQLResult::lastInsertId() const':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:387: error: `Oid' undeclared (first use
    this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:387: error: expected `;' before "id"
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:388: error: `id' undeclared (first use t
    his function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:388: error: `InvalidOid' undeclared (fir
    st use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual QSqlRecord
    QPSQLResult::record() const':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:400: error: `PQnfields' undeclared (firs
    t use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:404: error: `PQfname' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:407: error: `PQftype' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:408: error: `PQfsize' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:409: error: `PQfmod' undeclared (first u
    se this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In function `bool setEncodingUtf8(PGcon
    n*)':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:427: error: `PQexec' undeclared (first u
    se this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:428: error: `PQresultStatus' undeclared
    (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:429: error: `PQclear' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:430: error: `PGRES_COMMAND_OK' undeclare
    d (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In function `void setDatestyle(PGconn*)
    ':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:435: error: `PQexec' undeclared (first u
    se this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:436: error: `PQresultStatus' undeclared
    (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:437: error: `PGRES_COMMAND_OK' undeclare
    d (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:438: error: `PQerrorMessage' undeclared
    (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:439: error: `PQclear' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In function `QPSQLDriver::Protocol getP
    SQLVersion(PGconn*)':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:444: error: `PQexec' undeclared (first u
    se this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:445: error: `PQresultStatus' undeclared
    (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:446: error: `PGRES_COMMAND_OK' undeclare
    d (first use this function)
    .
    .
    .

    ..\..\..\sql\drivers\psql\qsql_psql.cpp:576: error: `PQfinish' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual void QPSQLD
    river::close()':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:596: error: `PQfinish' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual bool QPSQLD
    river::beginTransaction()':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:614: error: `PQexec' undeclared (first u
    se this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:615: error: `PQresultStatus' undeclared
    (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:615: error: `PGRES_COMMAND_OK' undeclare
    d (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:616: error: `PQclear' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual bool QPSQLD
    river::commitTransaction()':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:631: error: `PQexec' undeclared (first u
    se this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:632: error: `PQresultStatus' undeclared
    (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:632: error: `PGRES_COMMAND_OK' undeclare
    d (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:633: error: `PQclear' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual bool QPSQLD
    river::rollbackTransaction()':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:648: error: `PQexec' undeclared (first u
    se this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:649: error: `PQresultStatus' undeclared
    (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:649: error: `PGRES_COMMAND_OK' undeclare
    d (first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:652: error: `PQclear' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual QString QPS
    QLDriver::formatValue(const QSqlField&, bool) const':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:920: error: `PQescapeBytea' undeclared (
    first use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp: In member function `virtual bool QPSQLD
    river::isOpen() const':
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:946: error: `PQstatus' undeclared (first
    use this function)
    ..\..\..\sql\drivers\psql\qsql_psql.cpp:946: error: `CONNECTION_OK' undeclared (
    first use this function)
    mingw32-make[1]: *** [tmp/obj/release_shared/qsql_psql.o] Error 1
    mingw32-make[1]: Leaving directory `C:/Qt/4.3.4/src/plugins/sqldrivers/psql'
    mingw32-make: *** [release] Error 2

    C:\Qt\4.3.4\src\plugins\sqldrivers\psql>

    Regards,

    Narasimha Raju

  17. #17
    Join Date
    Aug 2008
    Location
    Ukraine, Krivoy Rog
    Posts
    1,963
    Thanked 370 Times in 336 Posts
    Qt products
    Qt3 Qt4 Qt5
    Platforms
    MacOS X Unix/X11 Windows

    Default Re: Regading Driver to connect Postgresql Database

    are you sure that this path "C:\Program Files\PostgreSQL\8.3\include" is corrent? is libpq-fe.h located in "C:\Program Files\PostgreSQL\8.3\include"?
    Qt Assistant -- rocks!
    please, use tags [CODE] & [/CODE].

  18. #18
    Join Date
    Feb 2009
    Posts
    39
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

    Default Re: Regading Driver to connect Postgresql Database

    yes all are correct but still i am getting same errors

  19. #19
    Join Date
    Aug 2008
    Location
    Ukraine, Krivoy Rog
    Posts
    1,963
    Thanked 370 Times in 336 Posts
    Qt products
    Qt3 Qt4 Qt5
    Platforms
    MacOS X Unix/X11 Windows

    Default Re: Regading Driver to connect Postgresql Database

    ok, try to make the next:
    >cd %QTDIR%\src\plugins\sqldrivers\psql
    >SET POSTGREDIR="C:\Program Files\PostgreSQL\8.3"
    >SET INCLUDE=%POSTGREDIR%\include;%INCLUDE%
    >SET LIB=%POSTGREDIR%\lib;%LIB%
    >qmake
    >mingw32-make
    Qt Assistant -- rocks!
    please, use tags [CODE] & [/CODE].

  20. #20
    Join Date
    Feb 2009
    Posts
    39
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows

    Default Re: Regading Driver to connect Postgresql Database

    hi i did according to your instructions. I got the following out put



    C:\Qt\4.3.4\src\plugins\sqldrivers\psql>mingw32-make
    mingw32-make -f Makefile.Release
    mingw32-make[1]: Entering directory `C:/Qt/4.3.4/src/plugins/sqldrivers/psql'
    C:/Qt/4.3.4/bin/moc.exe -DUNICODE -DQT_LARGEFILE_SUPPORT -DQT_NO_CAST_TO_ASCII -
    DQT_NO_CAST_FROM_ASCII -DQT_DLL -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE
    _LIB -DQT_THREAD_SUPPORT -I"..\..\..\..\include\QtCore" -I"..\..\..\..\include\Q
    tCore" -I"..\..\..\..\include\QtSql" -I"..\..\..\..\include\QtSql" -I"..\..\..\.
    .\include" -I"c:\Qt\4.3.4\include\ActiveQt" -I"tmp\moc\release_shared" -I"." -I"
    C:\Program Files\PostgreSQL\8.3\include" -I"%INCLUDE%" -I"..\..\..\..\mkspecs\wi
    n32-g++" -D__GNUC__ -DWIN32 ..\..\..\sql\drivers\psql\qsql_psql.h -o tmp\moc\rel
    ease_shared\moc_qsql_psql.cpp
    moc: Too many input files specified
    Usage: moc [options] <header-file>
    -o<file> write output to file rather than stdout
    -I<dir> add dir to the include path for header files
    -E preprocess only; do not generate meta object code
    -D<macro>[=<def>] define macro, with optional definition
    -U<macro> undefine macro
    -i do not generate an #include statement
    -p<path> path prefix for included file
    -f[<file>] force #include, optional file name
    -nw do not display warnings
    -v display version of moc
    mingw32-make[1]: *** [tmp/moc/release_shared/moc_qsql_psql.cpp] Error 1
    mingw32-make[1]: Leaving directory `C:/Qt/4.3.4/src/plugins/sqldrivers/psql'
    mingw32-make: *** [release] Error 2

    C:\Qt\4.3.4\src\plugins\sqldrivers\psql>


    Regards,

    Narasimha Raju. Naidu

Similar Threads

  1. Replies: 5
    Last Post: 28th August 2006, 15:36

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Digia, Qt and their respective logos are trademarks of Digia Plc in Finland and/or other countries worldwide.