Install the PostgreSQL driver for Qt 5

Question

I am running Ubuntu 14.04 (Trusty Tahr). I have installed Qt from the package qt-sdk. I have also installed the following package which should have installed the PostgreSQL driver:

libqt5sql5-psql

My Qt version is:

Qt Creator 3.0.1 based on Qt 5.2.1

When I try to create a Qt db object of type postgres like so:

QSqlDatabase db = QSqlDatabase::addDatabase(“QPSQL”);

I get a lot of errors like so:

/home/bc/projects/qt_test/main.cpp:12: error: stray '\342' in program
     QSqlDatabase db = QSqlDatabase::addDatabase(“QPSQL”);
     ^
/home/bc/projects/qt_test/main.cpp:12: error: 'QPSQL' was not declared in this scope
     QSqlDatabase db = QSqlDatabase::addDatabase(“QPSQL”);

I am obviously not doing something correctly. I don't know what though. Perhaps I am missing a package, or I have misconfigured something.

How can I fix it?

I highly doubt this has anything to do with any specific database. It sounds like you copied/pasted code from somewhere and wound up with non-ascii characters in your code. — MrEricSir
– MrEricSir, Commented Nov 5, 2014 at 20:54
You are absolutely right. If you look closely- the quotes aren't correct. I copy pasted this from the qt documents. — Stanimirovv
– Stanimirovv, Commented Nov 5, 2014 at 20:57
I fixed it and it works now. You did answer my question, so you might as well make this a proper answer so I can select it as an answer and close the issue. — Stanimirovv
– Stanimirovv, Commented Nov 5, 2014 at 20:58
Some (crucial) error messages must have been left out. "“", at least as posted here, is Unicode code point U+201C (LEFT DOUBLE QUOTATION MARK). The UTF-8 sequence is 0xE2 0x80 0x9C (hexadecimal), 342 200 234 (octal), so "error: stray '\342' in program. error: stray '\200' in program. error: stray '\234' in program" is expected in the error output (three errors for this one character alone). — Peter Mortensen
– Peter Mortensen, Commented Apr 25, 2023 at 22:04
This is a very common error when copying code from web pages, PDF documents, through chat (e.g. Skype Chat or Facebook Messenger), etc. The canonical question is Compilation error: stray ‘\302’ in program, etc.. — Peter Mortensen
– Peter Mortensen, Commented Apr 25, 2023 at 22:07

MrEricSir · Accepted Answer · 2014-11-05 21:03:57Z

1

This isn't a database issue: the compiler is telling you that you have non-ASCII characters in your code that it doesn't recognize:

error: stray '\342' in program

Take care of those and you should at least get as far as compiling.

answered Nov 5, 2014 at 21:03

MrEricSir

8,2924 gold badges34 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Simon Warta · Accepted Answer · 2014-11-05 20:59:00Z

0

Use proper quotes, not the fancy ones from some blogs:

QSqlDatabase db = QSqlDatabase::addDatabase("QPSQL");

answered Nov 5, 2014 at 20:59

Simon Warta

11.5k5 gold badges43 silver badges80 bronze badges

Collectives™ on Stack Overflow

Install the PostgreSQL driver for Qt 5

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related