MS-ACCESS CONNECTION ISSUE

[satish]

I am logging data from daqfactory to Ms-access but getting error:

C1011 Could not create table for logging. Msg:  syntax error in create table statement.

my logging information:

logging method: odbc database

data source: abc

Table name: SET_0659A

 i have some confusion in sql buttion query  please send some dummy or refrence program for help.. and solve my problem as soon as possible.

 

 

Untitled (2).ctl

TRIAL.mdb

[AzeoTech]

The problem is that while SQL is somewhat of a standard, different publishers use different names for their data types.  By default, DAQFactory uses "DATE" for date/time, "DOUBLE" for numbers, and "TEXT" for strings.  This works with MySQL, the most common database.  However, it appears you are using Access.  Access I believe uses DATETIME instead of DATE, VARCHAR instead of TEXT and DOUBLE for numbers.  So, when you click on the sql button in the logging set, you can change the names given there to match what your database needs.

 

 

[satish]

Dear sir 

Connection issue solved but still facing some issue in data logging and getting some error

C1012 failed to access table for logging. Msg: syntax error (missing operrator) in query expression 'AD_CH1[0]'.

[AzeoTech]

Are you using an export set?  Did you name your field with [0]?

[satish]

no i am using logging set.

and my field name is AD_CH1 ONLY.

[AzeoTech]

I'd have to see your .ctl document.