odbc

[pangya]

hi

i'm trying to make a project with record to access database, so it's using odbc client to connect and write to access database.

i have tried the example with name ODBCAppendRecord.zip.

yes, the example work.

when i tried connect my project with odbc it's have error.
the ODBC client have error " too few parameter. expected 1".

but when i swap the mdb file (i using access 2010) from the example project with the content modified to my project it's work. there is no error, while my new generate mdb file still have the error even with the same table content.

do the odbc client in winlog can't generate a new file for database ?

BTW the OS i'm using is Windows 7 64-bit

[admin]

Hi,
can you post your test application?

Regards

[pangya]

Yes, Here the program that i working.

best regard

[admin]

Hi,
try to change type of TanggalDanWaktu from Date/Time to string. I think that the date time format or sintax isn't correct.

Regards

[pangya]

hi,

i have tried change the data type for TanggalDanWaktu to text/string, i don't think that's the problem.

the data for frequency , current and watt_hour while in the gates status changed ( for tag sampling and tag for odbc)
but the tag for odbc status change to KO,and resulting to can't write to mdb(access file).

the error that appeared in odbc client are : "too few parameter. expected 1"

regards

[admin]

Dear Sir,
I modify your SQL syntax because there is some error.
Now works fine on my system.

Regards

inverter hitachi.zip

(83.97 KiB) Downloaded 181 times

[pangya]

yeah, after i modify the syntax in odbc client, its work.

forgot to specify the same syntax in mdb to query statement

thx.