I'm receiving GPS location messages and I need to interpret the messages accurately in order log the messages to an MS SQL dB. As an example, I am receiving messages like the following:
79$PKNDS,170221,V,2503.7197,N,12138.4115,E,,408.5,130111,3.5,W00,U10349,207,00,*04
80$PKNDS,181511,A,4557.6866,N,06638.5490,W,000.0,000.0,071011,18.9,W00,U10359,207,00,*14
81$PKNDS,181516,A,4557.6753,N,06638.5472,W,000.0,000.0,071011,18.9,W00,U10352,207,00,*1D
I want to log directly via ODBC to SQL and I have most of this sorted out however I am having a problem binding the data fields to the correct dB cells. Can anyone help me figure out the bindings?
79$PKNDS,170221,V,2503.7197,N,12138.4115,E,,408.5,130111,3.5,W00,U10349,207,00,*04
80$PKNDS,181511,A,4557.6866,N,06638.5490,W,000.0,000.0,071011,18.9,W00,U10359,207,00,*14
81$PKNDS,181516,A,4557.6753,N,06638.5472,W,000.0,000.0,071011,18.9,W00,U10352,207,00,*1D
I want to log directly via ODBC to SQL and I have most of this sorted out however I am having a problem binding the data fields to the correct dB cells. Can anyone help me figure out the bindings?