• <ins id="pjuwb"></ins>
    <blockquote id="pjuwb"><pre id="pjuwb"></pre></blockquote>
    <noscript id="pjuwb"></noscript>
          <sup id="pjuwb"><pre id="pjuwb"></pre></sup>
            <dd id="pjuwb"></dd>
            <abbr id="pjuwb"></abbr>

            牽著老婆滿街逛

            嚴以律己,寬以待人. 三思而后行.
            GMail/GTalk: yanglinbo#google.com;
            MSN/Email: tx7do#yahoo.com.cn;
            QQ: 3 0 3 3 9 6 9 2 0 .

            Accessing SQLite databases in C++ using SOCI

            轉載自:http://jameswynn.com/2009/10/accessing-sqlite-databases-in-c-using-soci/

            I recently decided to use SOCI and SQLite at work and found that neither there is not a super straight forward path for setting this up. As of SOCI version 3.0.0 there is no support for Visual Studio 2008, so I had to convert and fix a few bugs resulting from that. There were some path issues as well. Also they don't package the SQLite interface with SOCI so you have to checkout the repo to get access to it. After getting that there are still a few snags, not to mention actually setting up SQLite as a library.

            [Updated: 10/13/2009]
            After writing this article the SOCI team has resolved some of these issues, so some of these steps are no longer necessary.

            Step 1: Setup SQLite

            Step 1.1

            Download the SQLite 3.6.18 source and library files.

            Step 1.2:

            Unarchive the SQLite archives into a directory, mine will be c:\usr\sqlite3

            Step 1.3:

            Create the sqlite3.lib file by using Visual Studio's lib command:

            LIB /DEF:sqlite3.def


            Step 2: Setup SOCI

            Step 2.1:

            Download the head of SOCI's git repository

            Step 2.2:

            Decompress the file into another directory, mine will be c:\usr\soci

            Step 2.3:

            Soci requires stdint.h but Visual Studio 2008 does not provide it, so simply download pstdint.h and rename it to stdint.h in the soci\src\core directory.

            Step 2.4:

            Open the directory soci\build and copy msvc80 to msvc90.

            Now open the msvc90\dll directory.

            Through Visual Studio 2008, open the soci_dll.sln file and allow it to convert it with the default parameters.

            Step 2.5: Build SOCI's Core and SQLite3

            SOCI's core project should build without errors, but the sqlite project will have several.

            Step 2.6: Fixing Build Errors

            Now SOCI's core project should build without errors, but the sqlite3 project will definitely fail. It will give two specific errors:

            fatal error C1083: Cannot open include file: 'sqlite3.h': No such file or directory

            and

            error C3163: '_vsnprintf': attributes inconsistent with previous declaration

            Both are relatively easy to fix.

            Step 2.6.1: Fixing SQLite3 include paths

            In Visual Studio, navigate to View->Property Manager, then in the pane that shows up, expand the sqlite3 project, then expand "Debug | Win32" then "soci_dll" then double-click on the "soci" object. Select "User Macros" on the sheet you find there.

            Find SQLITE3_INCLUDE_DIR and SQLITE_LIB_DIR and change them to the directory created earlier, "c:\usr\sqlite3"

            Step 2.6.2: Fixing _vsnprintf

            [Update 10/13/2009]
            This step is no longer needed.

            Expand the core project and look for soci-platform.h and find a line that says "HAVE_VSNPRINTF"

            This is redefining something that VS2008 provides already and confuses the hell out of the compiler. Just comment it out, or change it to look like:

            // Define if you have the vsnprintf variants.
            #if _MSC_VER < 1500
            #    define HAVE_VSNPRINTF 
            1
            #    define vsnprintf _vsnprintf
            #endif

            Step 2.7 Building SOCI's sqlite3_test project

            This project will be riddled with errors unless you have boost installed. I personally don't use it, so had to comment out large chunks of common-tests.h.  Specifically, comment out the area at the top where it includes the boost headers. Also comment out the contents of test26, test28 and test30.

            Also add this line at the bottom of soci-platform.h:

            #undef SOCI_USE_BOOST

             

            Finished

            Now you should have a working copy of SOCI 3.0.0 with SQLite3 support in Visual Studio 2008. Congratulations!


            posted on 2009-11-27 13:47 楊粼波 閱讀(1641) 評論(0)  編輯 收藏 引用

            久久乐国产精品亚洲综合| 久久久久久无码Av成人影院 | 国产精品久久久久久久久免费| 欧美精品九九99久久在观看| 亚洲欧美日韩中文久久| 久久精品中文騷妇女内射| 亚洲国产精品久久久久婷婷老年| 一本色综合久久| 99久久夜色精品国产网站| 伊人久久大香线蕉综合网站| 久久国产乱子伦免费精品| 久久99国产一区二区三区| 欧美噜噜久久久XXX| 久久精品夜色噜噜亚洲A∨| 久久精品aⅴ无码中文字字幕不卡 久久精品aⅴ无码中文字字幕重口 | 久久精品国产99久久丝袜| 精品国产99久久久久久麻豆| 色欲久久久天天天综合网精品| 97久久精品午夜一区二区| 一本一道久久a久久精品综合 | 国产精品成人99久久久久| 久久午夜无码鲁丝片秋霞| 波多野结衣中文字幕久久| 亚洲伊人久久综合中文成人网| 久久久久亚洲Av无码专| 青青草原综合久久大伊人| 国产精品午夜久久| 成人a毛片久久免费播放| 精品一区二区久久| 日本欧美久久久久免费播放网| 亚洲国产日韩欧美综合久久| 精品综合久久久久久88小说| 狠狠色丁香婷婷久久综合不卡| 亚洲∧v久久久无码精品| 国产免费久久精品99re丫y| 国产精品久久久香蕉| 无码人妻久久一区二区三区蜜桃 | 久久A级毛片免费观看| 欧美午夜精品久久久久免费视| 欧美一区二区三区久久综 | 精品久久久久久99人妻|