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:
- Tests still want test-access.dsn instead of soci_test.dsn that I
specified
- I copied soci_test.dsn into my current directory under the name
test-access.dsn and ran 'ctest -VV -C Debug' Still every test still asks me
for data source and password despite having those specified inside my .DSN file
- I seems that every test ends with an exception (or at least first 2
as I gave up after those two). See log below.
Please advise.
My DSN file
[ODBC]
DRIVER=ODBC Driver 11 for SQL Server
UID=sa
PWD=Master10 <<<<<< Not sure if it's case sensitive so I tried Pwd=Master10
as well
DATABASE=history
WSID=DONUT64
APP=Microsoft(r) Windows(r) Operating System
SERVER=192.168.11.54\SPSQL
Description=soci_test
Test execution log
Constructing a list of tests
Done constructing a list of tests
Checking test dependency graph...
Checking test dependency graph end
test 1
Start 1: soci_odbc_test_access
1: Test command:
C:\Prg\soci-master\build.msvc\bin\Debug\soci_odbc_test_access.exe
"test-access.dsn"
1: Test timeout computed to be: 9.99988e+006
1:
1:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
1: soci_odbc_test_access.exe is a Catch v1.2.1 host application.
1: Run with -? for options
1:
1:
-------------------------------------------------------------------------------
1: Basic functionality
1:
-------------------------------------------------------------------------------
1: C:\Prg\soci-master\tests\common-tests.h(509)
1:
...............................................................................
1:
1: C:\Prg\soci-master\tests\common-tests.h(509): FAILED:
1: {Unknown expression after the reported line}
1: due to unexpected exception with message:
1: Error executing statement: [Microsoft][ODBC Driver 11 for SQL Server][SQL
1: Server]Column, parameter, or variable #6: Cannot find data type number.
(SQL
1: state 42000) while executing "create table soci_test(id integer, val
integer,
1: c char, str varchar(20), sh integer, ul number, d float, num76
numeric(7,6),
1: tm timestamp, i1 integer, i2 integer, i3 integer, name varchar(20))".
1:
1:
-------------------------------------------------------------------------------
1: Use and into
1:
-------------------------------------------------------------------------------
1: C:\Prg\soci-master\tests\common-tests.h(524)
1:
...............................................................................
1:
1: C:\Prg\soci-master\tests\common-tests.h(524): FAILED:
1: {Unknown expression after the reported line}
1: due to unexpected exception with message:
1: Error executing statement: [Microsoft][ODBC Driver 11 for SQL Server][SQL
1: Server]Column, parameter, or variable #6: Cannot find data type number.
(SQL
1: state 42000) while executing "create table soci_test(id integer, val
integer,
1: c char, str varchar(20), sh integer, ul number, d float, num76
numeric(7,6),
1: tm timestamp, i1 integer, i2 integer, i3 integer, name varchar(20))".
1:
Paul
------------------------------------------------------------------------------
_______________________________________________
soci-users mailing list
soci-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/soci-users
