Database logging example with Access does not work.

[CBPetrovic]

Using the example sequence to illustrate logging results to a database, I am get the following error when I attempt to use the Access database engine:

UUT Result: Error, An error occurred calling 'LogOneResult' in 'ITSDBLog' of 'zNI TestStand Database Logging' An error occurred while setting a column value. Statement: UUT_RESULT. Column: ID Description: Command text was not set for the command object. Number: -2147217908 NativeError: 0 SQLState: Reported by: Microsoft JET Database Engine Source: TSDBLog [Error Code: -2147217908, User-defined error code.]

The same sequence when configured to use a SQL database works perfectly.

The application must use Access.

/cbp

[Captain_Jack]

What version of TestStand are you using for this?

-Jack

[CBPetrovic]

Ultimately, 2.0, but for testing, I've been using 4.1.

/cbp

[CBPetrovic]

Isolated to a case of Operator Headspace.

Had I been more diligent when re-reading, I'd have seen the direction to use "Access Create Generic Recordset Result Tables.sql."

Using this set of scripts created tables with the correct attributes.

/cbp