odbc

Discussion about communication protocols (configuration, functions, hardware required).
pangya
Posts: 30
Joined: Thu Oct 29, 2015 8:10 am

odbc

Postby pangya » Mon Nov 16, 2015 3:31 am

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

User avatar
admin
Site Admin
Posts: 322
Joined: Tue Nov 17, 2009 1:18 pm

Re: odbc

Postby admin » Mon Nov 16, 2015 8:07 am

Hi,
can you post your test application?

Regards

pangya
Posts: 30
Joined: Thu Oct 29, 2015 8:10 am

Re: odbc

Postby pangya » Mon Nov 16, 2015 9:41 am

Yes, Here the program that i working.

best regard
Attachments
inverter hitachi.rar
project1
(61.11 KiB) Downloaded 126 times

User avatar
admin
Site Admin
Posts: 322
Joined: Tue Nov 17, 2009 1:18 pm

Re: odbc

Postby admin » Mon Nov 16, 2015 11:36 am

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
Posts: 30
Joined: Thu Oct 29, 2015 8:10 am

Re: odbc

Postby pangya » Wed Nov 18, 2015 6:34 am

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

User avatar
admin
Site Admin
Posts: 322
Joined: Tue Nov 17, 2009 1:18 pm

Re: odbc

Postby admin » Thu Nov 19, 2015 4:57 pm

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 153 times

pangya
Posts: 30
Joined: Thu Oct 29, 2015 8:10 am

Re: odbc

Postby pangya » Fri Nov 20, 2015 3:52 am

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

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

thx.


Return to “Protocols”

Who is online

Users browsing this forum: No registered users and 2 guests