database logging

[tsiltu]

Hi,

I am trying to log the results of a sequence to the ms access database. I have successfully  generated the datasource , the database and the database tables. But unfortunately at the end of the squence execution I get the error in the attachment. Can anyone help me?

Thank you

[Antonio Lie]

tsiltu:

I would recommend to use 'Microsoft Jet 4.0 OLE DB Provider' as your OLE DB Provider.
How did you create your tables?

Are you using the Generic Recordset (NI) schema?

You can determine whether the statement and conlumn information for the selected schema matches the tables and columns in the database by going to the Schema tab in the Database options dialog. You have to click on the Validate button.
Try to validate your data source and verify that you do not have differences.

Hope it helps.

Antonio Lie

Message Edited by Antonio Lie (NI) on 03-27-2007 08:47 AM

[tsiltu]

Hi,

 The problem is solved after selecting 'Microsoft Jet 4.0 OLE DB Provider' as my OLE DB Provider.

Thank you very much.

Tugba Siltu