Results 1 to 4 of 4

Thread: Frustrated with ODBC

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    May 2006
    Posts
    70
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows
    Thanks
    12
    Thanked 4 Times in 2 Posts

    Default Frustrated with ODBC

    I'm trying to develop an app for Windows using the QODBC driver to connect to Microsoft SQL Server. I'm using mingw to compile. I am doing a lot of my actual development under Linux with Mysql but then I want to port my application to run on windows.

    I'm using basic Qt classes to connect to the database, QSqlTableModel, QSqlQuery, QTableView, and QDataWidgetMapper. I'm doing nothing fancy and it works perfectly with Mysql.

    But it seems like only a small subset of classes that actually work with ODBC. I initially tried to use QSqlQuery using the bind values method and that fails.
    Using table views and table models seem to work but now that I'm trying to use QDataWidgetMapper I get a ton of errors about being "unable to bind variable".

    [edit] The actual error i'm getting (when QDataWidgetMapper tries to save the data to the database is:
    QODBCResult::exec: unable to bind variable: [Microsoft][ODBC SQL Server Driver]Optional feature not implemented

    Is anyone actually using Microsoft Sql Server via ODBC on Windows with any success?
    Last edited by darkadept; 1st April 2008 at 16:54.

Similar Threads

  1. remote ODBC data source
    By mchara in forum Qt Programming
    Replies: 7
    Last Post: 10th December 2007, 11:39
  2. Deploying debug Qt application - failed to load ODBC driver
    By sureshbabu in forum Installation and Deployment
    Replies: 1
    Last Post: 1st November 2007, 13:35
  3. Fun with ODBC and Oracle
    By KaptainKarl in forum Installation and Deployment
    Replies: 4
    Last Post: 27th July 2007, 22:42
  4. Connecting to an ODBC Data Source
    By kikapu in forum Newbie
    Replies: 9
    Last Post: 25th June 2007, 13:18
  5. Can't install Qt4.1 with SQL Support for ODBC in Windows XP
    By danieltruchsess in forum Installation and Deployment
    Replies: 1
    Last Post: 5th February 2006, 11:02

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
  •  
Qt is a trademark of The Qt Company.