Urgent - Data sent to ODBC when first created

#1

hi all
i m using SQL Server 2008 R2 ,
created database,table successfully,
created ODBC in windows successfully,
connected ODBC in Orginization window,
written button script like below:
HRD_DID=‘FF02’
HRD_STN=‘F3’
HRD_BAR=‘SFSFFFSF’
HRD_D3=12.82
HRD_D4=12.82
HRD_D5=626
HRD_D6=656
HRD_D7=13.82
HRD_D8=12.82
HRD_D9=12.82
HRD_D10=12.81
HRD_D11=4
HRD_RESULT=1
HRD_Data.AddRecord(0)

run successfully first time when odbc added to scada. when i restart the application in development mode or direct run time, then data is no sent to database.

when i delete ODBC and adding same ODBC again then data is being sent to database repeatedly.

so why i need to re-add ODBC after delete it. can anyone suggest me the solution.

thanks in advance

#2

Hello @Kanwar_Lodhi!

Are you following the same steps from the article below?
http://kb.elipse.com.br/en-us/questions/5335
Which Elipse SCADA version are you using?

Best regards,

#3

Yes dear i used all the steps according to the link u sent.

and i m using v.2.9 of elipse scada

and i tested all the procedures/commands for log in MS Access .mdb file through same ODBC connectivity steps as given in elips user manual is running well but only thing i had to do is to include Autonumber key and sent incremental number through script command like below.

HRD_ID=HRD_Data.GetTotalNumberOfRecords()
HRD_DID=“FF02”
HRD_STN=“F3”
HRD_BAR=“SFSFFFSF”
HRD_D3=12.82
HRD_D4=12.82
HRD_D5=626
HRD_D6=656
HRD_D7=13.82
HRD_D8=12.82
HRD_D9=12.82
HRD_D10=12.81
HRD_D11=4
HRD_RESULT=1
HRD_Data.AddRecord(0)

and removed autonumber increment from mdb file table.
so in case of MS Access it works fine.

Thanks for your kind response

Lodhi