Page 1 of 1

odbc

Posted: Mon Nov 16, 2015 3:31 am
by 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

Re: odbc

Posted: Mon Nov 16, 2015 8:07 am
by admin
Hi,
can you post your test application?

Regards

Re: odbc

Posted: Mon Nov 16, 2015 9:41 am
by pangya
Yes, Here the program that i working.

best regard

Re: odbc

Posted: Mon Nov 16, 2015 11:36 am
by 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

Re: odbc

Posted: Wed Nov 18, 2015 6:34 am
by 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

Re: odbc

Posted: Thu Nov 19, 2015 4:57 pm
by 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 151 times

Re: odbc

Posted: Fri Nov 20, 2015 3:52 am
by pangya
yeah, after i modify the syntax in odbc client, its work.

forgot to specify the same syntax in mdb to query statement :(

thx.