diff options
| author | Bill King <bill.king@nokia.com> | 2009-04-15 03:22:48 (GMT) |
|---|---|---|
| committer | Bill King <bill.king@nokia.com> | 2009-04-15 03:26:55 (GMT) |
| commit | 3eb4aacf07c77876c6ce68e9746906424934433b (patch) | |
| tree | b9536bb5134c3ad315d37caf9258c9ebcf32c970 /src/sql/drivers/odbc/qsql_odbc.cpp | |
| parent | e3462ae7868c679bc88dc01de85ca39454651ff7 (diff) | |
| download | Qt-3eb4aacf07c77876c6ce68e9746906424934433b.zip Qt-3eb4aacf07c77876c6ce68e9746906424934433b.tar.gz Qt-3eb4aacf07c77876c6ce68e9746906424934433b.tar.bz2 | |
Fixes an issue with FreeTDS and quoting.
Microsofts SQL Server odbc driver calls SET QUOTED_IDENTIFIER_ON,
but freetds doesn't, so any quoting fails. This fixes that issue.
Reviewed-by: abcd
Diffstat (limited to 'src/sql/drivers/odbc/qsql_odbc.cpp')
| -rw-r--r-- | src/sql/drivers/odbc/qsql_odbc.cpp | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/src/sql/drivers/odbc/qsql_odbc.cpp b/src/sql/drivers/odbc/qsql_odbc.cpp index 71b1b2a..d6423ae 100644 --- a/src/sql/drivers/odbc/qsql_odbc.cpp +++ b/src/sql/drivers/odbc/qsql_odbc.cpp @@ -55,6 +55,7 @@ #include <qvarlengtharray.h> #include <qvector.h> #include <QDebug> +#include <QSqlQuery> QT_BEGIN_NAMESPACE @@ -1800,6 +1801,10 @@ bool QODBCDriver::open(const QString & db, d->checkHasMultiResults(); setOpen(true); setOpenError(false); + if(d->isMSSqlServer) { + QSqlQuery i(createResult()); + i.exec(QLatin1String("SET QUOTED_IDENTIFIER ON")); + } return true; } |