• <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 楊粼波 閱讀(1638) 評論(0)  編輯 收藏 引用

            性做久久久久久久久久久| 国产精品久久久久久久久鸭| 国产韩国精品一区二区三区久久| 午夜精品久久久久久久久| 97久久超碰国产精品2021| 国产精品久久久久影院色| 麻豆精品久久精品色综合| 一级A毛片免费观看久久精品| 久久人人爽人人爽人人片AV麻烦| 亚洲精品国产字幕久久不卡| 国产亚洲精久久久久久无码| 国产午夜精品理论片久久| 伊人久久大香线蕉亚洲| 久久午夜综合久久| 久久99免费视频| 人妻少妇久久中文字幕一区二区 | 欧美午夜A∨大片久久 | 四虎影视久久久免费观看| 亚洲va久久久噜噜噜久久男同| 国产精品激情综合久久| 国产精品视频久久久| 伊人精品久久久久7777| 一本大道加勒比久久综合| 亚洲综合久久综合激情久久| 老男人久久青草av高清| 91麻豆国产精品91久久久| 狠狠久久亚洲欧美专区| 亚洲AV无码久久精品色欲| 亚洲国产成人久久一区WWW| 免费观看成人久久网免费观看| 亚洲狠狠婷婷综合久久蜜芽| 武侠古典久久婷婷狼人伊人| 99精品久久久久久久婷婷| 国产成人精品久久一区二区三区| 久久精品国产亚洲AV不卡| 久久一区二区三区免费| 国内精品久久久久久麻豆| 国产精品免费久久| 久久精品亚洲乱码伦伦中文| 久久精品国产亚洲Aⅴ蜜臀色欲| 热99re久久国超精品首页|