>>> I did as it was suggested in the resolution for the issue #396 by >>> adding >>> -DSOCI_ODBC_TEST_MSSQL_CONNSTR="FILEDSN=C:/Users/Paul/Documents/soci_test.dsn" >>> to cmake command line and doing a clean build but this did not fix >>> the original problem: >>> >> >> What makes you think that it not solve you problem? >> >> cmake .. >> -DSOCI_ODBC_TEST_MSSQL_CONNSTR="FILEDSN=C:/Users/Paul/Documents/soci_test.dsn" >> >> will set SOCI_ODBC_TEST_MSSQL_CONNSTR to specified DSN file. You'll >> see it if run cmake from cmd console. >> >> Could you please run after build is completed >> >> ctest -R mssql > > Also, you can run the test executable directly > > soci_odbc_test_mssql FILEDSN=C:/Users/Paul/Documents/soci_test.dsn > > BTW, > Have you tried to tweak the soci_test.dsn and choose different driver? > Have you tried to test your soci_test.dsn with alternative clients, perhaps > simple Python+pyodbc?
Below is the log from the command you suggested: soci_odbc_test_mssql FILEDSN=C:/Users/Paul/Documents/soci_test.dsn I just tried the .dsn file with another client (the one I'm working on) that does very heavy db communication and it seems to connect to db and work just fine (I replaced default db name from history to main though). I tried ODBC driver "SQL Server" which has version 6.03.9600.16384 but the output seems to be identical to the original "ODBC Driver 11 for SQL Server" (version 2014.120.2000.08). ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ soci_odbc_test_mssql.EXE is a Catch v1.2.1 host application. Run with -? for options ------------------------------------------------------------------------------- MS SQL long string ------------------------------------------------------------------------------- C:\Prg\soci-master\tests\odbc\test-odbc-mssql.cpp(23) ............................................................................... C:\Prg\soci-master\tests\odbc\test-odbc-mssql.cpp(23): FAILED: due to unexpected exception with message: Error binding input parameter #1: [Microsoft][ODBC Driver 11 for SQL Server]Invalid precision value (SQL state HY104) while executing "insert into soci_test(long_text) values(:str)" with :str="Line #0 Line #1 Line #2 Line #3 Line #4 Line #5 Line #6 Line #7 Line #8 Line #9 Line #10 Line #11 Line #12 Line #13 Line #14 Line #15 Line #16 Line #17 Line #18 Line #19 Line #20 Line #21 Line #22 Line #23 Line #24 Line #25 Line #26 Line #27 Line #28 Line #29 Line #30 Line #31 Line #32 Line #33 Line #34 Line #35 Line #36 Line #37 Line #38 Line #39 Line #40 Line #41 Line #42 Line #43 Line #44 Line #45 Line #46 Line #47 Line #48 Line #49 Line #50 Line #51 Line #52 Line #53 Line #54 Line #55 Line #56 Line #57 Line #58 Line #59 Line #60 Line #61 Line #62 Line #63 Line #64 Line #65 Line #66 Line #67 Line #68 Line #69 Line #70 Line #71 Line #72 Line #73 Line #74 Line #75 Line #76 Line #77 Line #78 Line #79 Line #80 Line #81 Line #82 Line #83 Line #84 Line #85 Line #86 Line #87 Line #88 Line #89 Line #90 Line #91 Line #92 Line #93 Line #94 Line #95 Line #96 Line #97 Line #98 Line #99 Line #100 Line #101 Line #102 Line #103 Line #104 Line #105 Line #106 Line #107 Line #108 Line #109 Line #110 Line #111 Line #112 Line #113 Line #114 Line #115 Line #116 Line #117 Line #118 Line #119 Line #120 Line #121 Line #122 Line #123 Line #124 Line #125 Line #126 Line #127 Line #128 Line #129 Line #130 Line #131 Line #132 Line #133 Line #134 Line #135 Line #136 Line #137 Line #138 Line #139 Line #140 Line #141 Line #142 Line #143 Line #144 Line #145 Line #146 Line #147 Line #148 Line #149 Line #150 Line #151 Line #152 Line #153 Line #154 Line #155 Line #156 Line #157 Line #158 Line #159 Line #160 Line #161 Line #162 Line #163 Line #164 Line #165 Line #166 Line #167 Line #168 Line #169 Line #170 Line #171 Line #172 Line #173 Line #174 Line #175 Line #176 Line #177 Line #178 Line #179 Line #180 Line #181 Line #182 Line #183 Line #184 Line #185 Line #186 Line #187 Line #188 Line #189 Line #190 Line #191 Line #192 Line #193 Line #194 Line #195 Line #196 Line #197 Line #198 Line #199 Line #200 Line #201 Line #202 Line #203 Line #204 Line #205 Line #206 Line #207 Line #208 Line #209 Line #210 Line #211 Line #212 Line #213 Line #214 Line #215 Line #216 Line #217 Line #218 Line #219 Line #220 Line #221 Line #222 Line #223 Line #224 Line #225 Line #226 Line #227 Line #228 Line #229 Line #230 Line #231 Line #232 Line #233 Line #234 Line #235 Line #236 Line #237 Line #238 Line #239 Line #240 Line #241 Line #242 Line #243 Line #244 Line #245 Line #246 Line #247 Line #248 Line #249 Line #250 Line #251 Line #252 Line #253 Line #254 Line #255 Line #256 Line #257 Line #258 Line #259 Line #260 Line #261 Line #262 Line #263 Line #264 Line #265 Line #266 Line #267 Line #268 Line #269 Line #270 Line #271 Line #272 Line #273 Line #274 Line #275 Line #276 Line #277 Line #278 Line #279 Line #280 Line #281 Line #282 Line #283 Line #284 Line #285 Line #286 Line #287 Line #288 Line #289 Line #290 Line #291 Line #292 Line #293 Line #294 Line #295 Line #296 Line #297 Line #298 Line #299 Line #300 Line #301 Line #302 Line #303 Line #304 Line #305 Line #306 Line #307 Line #308 Line #309 Line #310 Line #311 Line #312 Line #313 Line #314 Line #315 Line #316 Line #317 Line #318 Line #319 Line #320 Line #321 Line #322 Line #323 Line #324 Line #325 Line #326 Line #327 Line #328 Line #329 Line #330 Line #331 Line #332 Line #333 Line #334 Line #335 Line #336 Line #337 Line #338 Line #339 Line #340 Line #341 Line #342 Line #343 Line #344 Line #345 Line #346 Line #347 Line #348 Line #349 Line #350 Line #351 Line #352 Line #353 Line #354 Line #355 Line #356 Line #357 Line #358 Line #359 Line #360 Line #361 Line #362 Line #363 Line #364 Line #365 Line #366 Line #367 Line #368 Line #369 Line #370 Line #371 Line #372 Line #373 Line #374 Line #375 Line #376 Line #377 Line #378 Line #379 Line #380 Line #381 Line #382 Line #383 Line #384 Line #385 Line #386 Line #387 Line #388 Line #389 Line #390 Line #391 Line #392 Line #393 Line #394 Line #395 Line #396 Line #397 Line #398 Line #399 Line #400 Line #401 Line #402 Line #403 Line #404 Line #405 Line #406 Line #407 Line #408 Line #409 Line #410 Line #411 Line #412 Line #413 Line #414 Line #415 Line #416 Line #417 Line #418 Line #419 Line #420 Line #421 Line #422 Line #423 Line #424 Line #425 Line #426 Line #427 Line #428 Line #429 Line #430 Line #431 Line #432 Line #433 Line #434 Line #435 Line #436 Line #437 Line #438 Line #439 Line #440 Line #441 Line #442 Line #443 Line #444 Line #445 Line #446 Line #447 Line #448 Line #449 Line #450 Line #451 Line #452 Line #453 Line #454 Line #455 Line #456 Line #457 Line #458 Line #459 Line #460 Line #461 Line #462 Line #463 Line #464 Line #465 Line #466 Line #467 Line #468 Line #469 Line #470 Line #471 Line #472 Line #473 Line #474 Line #475 Line #476 Line #477 Line #478 Line #479 Line #480 Line #481 Line #482 Line #483 Line #484 Line #485 Line #486 Line #487 Line #488 Line #489 Line #490 Line #491 Line #492 Line #493 Line #494 Line #495 Line #496 Line #497 Line #498 Line #499 Line #500 Line #501 Line #502 Line #503 Line #504 Line #505 Line #506 Line #507 Line #508 Line #509 Line #510 Line #511 Line #512 Line #513 Line #514 Line #515 Line #516 Line #517 Line #518 Line #519 Line #520 Line #521 Line #522 Line #523 Line #524 Line #525 Line #526 Line #527 Line #528 Line #529 Line #530 Line #531 Line #532 Line #533 Line #534 Line #535 Line #536 Line #537 Line #538 Line #539 Line #540 Line #541 Line #542 Line #543 Line #544 Line #545 Line #546 Line #547 Line #548 Line #549 Line #550 Line #551 Line #552 Line #553 Line #554 Line #555 Line #556 Line #557 Line #558 Line #559 Line #560 Line #561 Line #562 Line #563 Line #564 Line #565 Line #566 Line #567 Line #568 Line #569 Line #570 Line #571 Line #572 Line #573 Line #574 Line #575 Line #576 Line #577 Line #578 Line #579 Line #580 Line #581 Line #582 Line #583 Line #584 Line #585 Line #586 Line #587 Line #588 Line #589 Line #590 Line #591 Line #592 Line #593 Line #594 Line #595 Line #596 Line #597 Line #598 Line #599 Line #600 Line #601 Line #602 Line #603 Line #604 Line #605 Line #606 Line #607 Line #608 Line #609 Line #610 Line #611 Line #612 Line #613 Line #614 Line #615 Line #616 Line #617 Line #618 Line #619 Line #620 Line #621 Line #622 Line #623 Line #624 Line #625 Line #626 Line #627 Line #628 Line #629 Line #630 Line #631 Line #632 Line #633 Line #634 Line #635 Line #636 Line #637 Line #638 Line #639 Line #640 Line #641 Line #642 Line #643 Line #644 Line #645 Line #646 Line #647 Line #648 Line #649 Line #650 Line #651 Line #652 Line #653 Line #654 Line #655 Line #656 Line #657 Line #658 Line #659 Line #660 Line #661 Line #662 Line #663 Line #664 Line #665 Line #666 Line #667 Line #668 Line #669 Line #670 Line #671 Line #672 Line #673 Line #674 Line #675 Line #676 Line #677 Line #678 Line #679 Line #680 Line #681 Line #682 Line #683 Line #684 Line #685 Line #686 Line #687 Line #688 Line #689 Line #690 Line #691 Line #692 Line #693 Line #694 Line #695 Line #696 Line #697 Line #698 Line #699 Line #700 Line #701 Line #702 Line #703 Line #704 Line #705 Line #706 Line #707 Line #708 Line #709 Line #710 Line #711 Line #712 Line #713 Line #714 Line #715 Line #716 Line #717 Line #718 Line #719 Line #720 Line #721 Line #722 Line #723 Line #724 Line #725 Line #726 Line #727 Line #728 Line #729 Line #730 Line #731 Line #732 Line #733 Line #734 Line #735 Line #736 Line #737 Line #738 Line #739 Line #740 Line #741 Line #742 Line #743 Line #744 Line #745 Line #746 Line #747 Line #748 Line #749 Line #750 Line #751 Line #752 Line #753 Line #754 Line #755 Line #756 Line #757 Line #758 Line #759 Line #760 Line #761 Line #762 Line #763 Line #764 Line #765 Line #766 Line #767 Line #768 Line #769 Line #770 Line #771 Line #772 Line #773 Line #774 Line #775 Line #776 Line #777 Line #778 Line #779 Line #780 Line #781 Line #782 Line #783 Line #784 Line #785 Line #786 Line #787 Line #788 Line #789 Line #790 Line #791 Line #792 Line #793 Line #794 Line #795 Line #796 Line #797 Line #798 Line #799 Line #800 Line #801 Line #802 Line #803 Line #804 Line #805 Line #806 Line #807 Line #808 Line #809 Line #810 Line #811 Line #812 Line #813 Line #814 Line #815 Line #816 Line #817 Line #818 Line #819 Line #820 Line #821 Line #822 Line #823 Line #824 Line #825 Line #826 Line #827 Line #828 Line #829 Line #830 Line #831 Line #832 Line #833 Line #834 Line #835 Line #836 Line #837 Line #838 Line #839 Line #840 Line #841 Line #842 Line #843 Line #844 Line #845 Line #846 Line #847 Line #848 Line #849 Line #850 Line #851 Line #852 Line #853 Line #854 Line #855 Line #856 Line #857 Line #858 Line #859 Line #860 Line #861 Line #862 Line #863 Line #864 Line #865 Line #866 Line #867 Line #868 Line #869 Line #870 Line #871 Line #872 Line #873 Line #874 Line #875 Line #876 Line #877 Line #878 Line #879 Line #880 Line #881 Line #882 Line #883 Line #884 Line #885 Line #886 Line #887 Line #888 Line #889 Line #890 Line #891 Line #892 Line #893 Line #894 Line #895 Line #896 Line #897 Line #898 Line #899 Line #900 Line #901 Line #902 Line #903 Line #904 Line #905 Line #906 Line #907 Line #908 Line #909 Line #910 Line #911 Line #912 Line #913 Line #914 Line #915 Line #916 Line #917 Line #918 Line #919 Line #920 Line #921 Line #922 Line #923 Line #924 Line #925 Line #926 Line #927 Line #928 Line #929 Line #930 Line #931 Line #932 Line #933 Line #934 Line #935 Line #936 Line #937 Line #938 Line #939 Line #940 Line #941 Line #942 Line #943 Line #944 Line #945 Line #946 Line #947 Line #948 Line #949 Line #950 Line #951 Line #952 Line #953 Line #954 Line #955 Line #956 Line #957 Line #958 Line #959 Line #960 Line #961 Line #962 Line #963 Line #964 Line #965 Line #966 Line #967 Line #968 Line #969 Line #970 Line #971 Line #972 Line #973 Line #974 Line #975 Line #976 Line #977 Line #978 Line #979 Line #980 Line #981 Line #982 Line #983 Line #984 Line #985 Line #986 Line #987 Line #988 Line #989 Line #990 Line #991 Line #992 Line #993 Line #994 Line #995 Line #996 Line #997 ... message truncated due to excessive size =============================================================================== test cases: 45 | 44 passed | 1 failed assertions: 1530 | 1529 passed | 1 failed ------------------------------------------------------------------------------ Monitor Your Dynamic Infrastructure at Any Scale With Datadog! Get real-time metrics from all of your servers, apps and tools in one place. SourceForge users - Click here to start your Free Trial of Datadog now! http://pubads.g.doubleclick.net/gampad/clk?id=241902991&iu=/4140 _______________________________________________ soci-users mailing list soci-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/soci-users
