Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. Is it not possible to open M.S. access file?
Forum Updated to NodeBB v4.3 + New Features

Is it not possible to open M.S. access file?

Scheduled Pinned Locked Moved Solved General and Desktop
27 Posts 7 Posters 8.9k Views 2 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.
  • R Offline
    R Offline
    rockon209
    wrote on last edited by rockon209
    #1

    Hello everyone,
    Is it not possible to open M.S. Access file in Qt.
    I tried with SQLITE file and i can open it but not the M.S.Access file.
    Is there any special way to open Microsoft access file

    K 1 Reply Last reply
    0
    • mrjjM Offline
      mrjjM Offline
      mrjj
      Lifetime Qt Champion
      wrote on last edited by
      #2

      Hi
      You must use ODBC to open a ms access file.

      1 Reply Last reply
      1
      • R rockon209

        Hello everyone,
        Is it not possible to open M.S. Access file in Qt.
        I tried with SQLITE file and i can open it but not the M.S.Access file.
        Is there any special way to open Microsoft access file

        K Offline
        K Offline
        koahnig
        wrote on last edited by
        #3

        @rockon209

        See also your other post and the documentation It is an example there.

        I would recommend trying with a small example and a less complicated name for the file path.

        Vote the answer(s) that helped you to solve your issue(s)

        1 Reply Last reply
        2
        • R Offline
          R Offline
          rockon209
          wrote on last edited by
          #4

          @mrjj
          I am using following code
          QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
          db.setDatabaseName("DRIVER={Microsoft Access Driver(*.accdb)};FIL={MS Access};DBQ=C:.........\Database1.accdb");

          if(db.open())
          qDebug() << "oK";
          else
          qDebug() << db.lastError();

          and i am getting the following error
          QSqlError("0", "QODBC3: Unable to connect", "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified")

          @koahnig
          I saved my file on my desktop, i think thats the most easy path and the above code is the simplest i guess.

          1 Reply Last reply
          0
          • hskoglundH Offline
            hskoglundH Offline
            hskoglund
            wrote on last edited by
            #5

            Hi, try using an absolute filepath in the DBQ clause, for example:
            ;DBQ=c:\\myfolder\\Database1.accdb

            1 Reply Last reply
            0
            • R Offline
              R Offline
              rockon209
              wrote on last edited by
              #6

              @hskoglund
              i tried absolute filepath also but i am getting the same error

              1 Reply Last reply
              0
              • hskoglundH Offline
                hskoglundH Offline
                hskoglund
                wrote on last edited by
                #7

                I see. Did you use double backslashes?

                1 Reply Last reply
                0
                • R Offline
                  R Offline
                  rockon209
                  wrote on last edited by
                  #8

                  @hskoglund
                  yes i tried with double backslashes and also with forward slashes. but same error

                  1 Reply Last reply
                  0
                  • hskoglundH Offline
                    hskoglundH Offline
                    hskoglund
                    wrote on last edited by
                    #9

                    Hmm, create a folder called MyFolder on your C: , copy your Database1.accdb file into it and try:

                    db.setDatabaseName("Driver=Microsoft Access Driver (*.mdb, *.accdb); DBQ=C:\\MyFolder\\Database1.accdb;";
                    1 Reply Last reply
                    2
                    • mrjjM Offline
                      mrjjM Offline
                      mrjj
                      Lifetime Qt Champion
                      wrote on last edited by
                      #10

                      Also, did you VERIFY that odbc is available and working ?
                      https://www.isunshare.com/windows-10/5-ways-to-open-odbc-data-source-administrator-in-windows-10.html

                      This might not be related to Qt at all.

                      If you never worked with ODBC before, please study a bit
                      http://www.dummies.com/programming/sql/how-to-use-odbc-to-access-sql-data/

                      1 Reply Last reply
                      2
                      • R Offline
                        R Offline
                        rockon209
                        wrote on last edited by
                        #11

                        @hskoglund

                        I tried what you suggested but getting the same error.

                        @mrjj

                        Yes the odbc is available and wroking.
                        and i just access the the file locally not via any server my file is in the same computer where i am writing the code

                        1 Reply Last reply
                        0
                        • hskoglundH Offline
                          hskoglundH Offline
                          hskoglund
                          wrote on last edited by
                          #12

                          Hi, I googled a bit and found this thread

                          So if you do not have Microsoft Office installed you need to download the driver for MS Access .accdb files

                          Andy314A 1 Reply Last reply
                          2
                          • hskoglundH hskoglund

                            Hi, I googled a bit and found this thread

                            So if you do not have Microsoft Office installed you need to download the driver for MS Access .accdb files

                            Andy314A Offline
                            Andy314A Offline
                            Andy314
                            wrote on last edited by Andy314
                            #13

                            Indeed you must install the Access ODBC driver. The driver is independent from installed Office !
                            (Be aware Windows like to kill this driver after windows-update. So you must reinstall it sometimes.)

                            Then you must look in the ODBC tool from windows to find out the correct driver name. This is the correct for me (is not the same as you use):
                            "DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};"

                            1 Reply Last reply
                            0
                            • R Offline
                              R Offline
                              rockon209
                              wrote on last edited by
                              #14

                              @hskoglund

                              i already tried downloaded and intalled the drivers, even though i have M.S Office installed on my computer. But getting the same error.

                              Andy314A 1 Reply Last reply
                              0
                              • R rockon209

                                @hskoglund

                                i already tried downloaded and intalled the drivers, even though i have M.S Office installed on my computer. But getting the same error.

                                Andy314A Offline
                                Andy314A Offline
                                Andy314
                                wrote on last edited by
                                #15

                                Hi @rockon209
                                which Qt Version do you use?

                                1 Reply Last reply
                                0
                                • R Offline
                                  R Offline
                                  rockon209
                                  wrote on last edited by
                                  #16

                                  @Andy314
                                  I am using Qt 5.7.0

                                  Andy314A 1 Reply Last reply
                                  0
                                  • R rockon209

                                    @Andy314
                                    I am using Qt 5.7.0

                                    Andy314A Offline
                                    Andy314A Offline
                                    Andy314
                                    wrote on last edited by Andy314
                                    #17

                                    Hi @rockon209
                                    the QtCompany had the idea to do not distribute the binarys for the ODBC driver anymore. That was in Version 5.5 and 5.6 I think. I initiated a discussion about it. The result was that the driver should be integrated again. I dont know if this is in 5.7 really the case.

                                    Look if you have in the path like C:\Qt2\5.6\msvc2015\plugins\sqldrivers
                                    the qsqlodbc files.

                                    1 Reply Last reply
                                    0
                                    • R Offline
                                      R Offline
                                      rockon209
                                      wrote on last edited by
                                      #18

                                      @Andy314

                                      yes the file is present in the path.

                                      Andy314A 1 Reply Last reply
                                      0
                                      • R rockon209

                                        @Andy314

                                        yes the file is present in the path.

                                        Andy314A Offline
                                        Andy314A Offline
                                        Andy314
                                        wrote on last edited by
                                        #19

                                        Hello @rockon209,
                                        oh I am happy :-)

                                        Now your Problem:
                                        It must work ! I use it since 1 year.

                                        We must find the error systhematic.
                                        First you should try a connection via the windows Windows-ODBC tool.
                                        I there is something wrong we must not look on Qt.

                                        1 Reply Last reply
                                        0
                                        • R Offline
                                          R Offline
                                          rockon209
                                          wrote on last edited by
                                          #20

                                          @Andy314
                                          How to do that bcoz i new to this database access. I dont know how it works. Could you help me?

                                          Andy314A D 2 Replies 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