Unable to build database from Generic Recordset (NI)

[Kiebach]

I seemed to have lost the ability to build the TestStand database using the 'Build .SQL File' button on the Schema tab of the Database options window.  

I was in process of creating a custom Recordset based on the 'Generic Recordset (NI)' but now I cannot even build the stock 'Generic Recordset (NI)' Database.

In an effort to see If I may have a corrupt copy of the 'Generic Recordset (NI) schema,I have already tried using the 'Reload NI Schema...' button to reload the '2012 or Later' recordset. But, the sql file created to build the database tables still produces an unusable database.

This is the method I used to create the database:

1. I used Access 2010 to create a blank database using the 2002-2003 file format. (Note: using to 2000 file Format produces the same anomaly)
2. Logging Options are set to use 'Access' Database Management System and 'Microsoft Jet 4.0 OLE DB Provider'
3. Data Link Options: Set the UDL to the empty database, Testing the Connection indicates connection is good.
4. I then used the 'Build .sql File' button on the schema tab to create the tables in the empty database.

The problem in the database appears to be related to the 'PROP_RESULT' Table being created with the 'DATA' column data type set to 'double' instead of the 'string' data type defined in the schema.

I have attached the exported 'Generic Recordset (NI)' schema and the associated sql file TestStand Generated to build the database tables.

Thanx in advance for any assistance....

[D-Cubed]

Hi Kiebach,

Please send in a screenshot of the database options so I can have a better idea of what might be happening with your unusable Build .SQL File button.  Can you also send in a copy of your default .ini file?  It should be located at the following path: C:\Program Files\National Instruments\TestStand 2012\Components\Models\TestStandModels\Database\TestStandDatabaseSchemasDef.ini. 

What happens when you try to load this .ini file?

Warm Regards,

[Kiebach]

Attached files:

TestStandDatabaseSchemasDef.ini 

     - Requested file from TestStand Directory

Generic Record Set from TestStandDatabaseSchemasDef.sql

     - Sql File create by 'Build SQL File" button using "Generic Recordset" from "TestStandDatabaseSchemasDef.ini"

     - Still build database tables with "PROP_RESULT//DATA Column set to numeric instead of string.

Generic Recordset (NI).sql

     - Sql file created by 'Build SQL File" button using "Generic Recordset (NI)" after performing "Reload NI Schema..."

     - Note it is exactly the same as "Generic Record Set from TestStandDatabaseSchemasDef.sql"

Generic Recordset Database.mdb

     - Database created by SQL commands

Screen shots of all schema tabs from data base options

[D-Cubed]

Thank you for attaching those.  What happens when you use the SQL files which ship with TestStand?  You can find them in the following directory: C:\Program Files\National Instruments\TestStand 2012\Components\Models\TestStandModels\Database\ .

Warm Regards,