contact
support
Download
order
news
AGG Software Forums
November 25, 2024, 09:50:20 PM
Welcome,
Guest
. Please
login
or
register
.
Did you miss your
activation email?
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
News
: Welcome on our forum!
Home
Help
Search
Login
Register
AGG Software Forums
>
Online Help Center
>
Data loggers and plug-ins
>
TCP/IP Logger SQL errors - passing ":P0, :P1, etc." instead of values.
Pages: [
1
]
« previous
next »
Print
Author
Topic: TCP/IP Logger SQL errors - passing ":P0, :P1, etc." instead of values. (Read 15530 times)
Transistor
Newbie
Karma: +0/-0
Posts: 2
TCP/IP Logger SQL errors - passing ":P0, :P1, etc." instead of values.
«
on:
April 15, 2014, 11:12:19 PM »
App: Advanced TCP/IP Logger.
Data export module: odbcexport.dll
The problem: "Data have been processed with errors." / "Writing to database temporarily disabled."
ODBC: Connection to SQL Server on a local server.
I've used the OPC data logger in a previous application so I know the basics. I'd say I'm very close to getting this app to work.
I have error logging configured as below:
Configure -> Modules -> Data Export -> odbcexport.dll -> Setup -> Errors Handling -> Reconnect and write a message to log file.
Here's what shows up in my log:
5/04/14 21:29:11 [192.168.31.151:9000,192.168.31.131:9000] SQLSVR. SQL:
INSERT INTO "Results" ("Date", "Time", "MachineID", "Product", "Weight")
VALUES (:P0, :P1, :P2, :P3, :P4)
Where are all the ":Px" values coming from? They should be the parsed data that I can see on the main window.
Many thanks.
«
Last Edit: April 15, 2014, 11:48:17 PM by Transistor
»
Logged
Arthur Grasin
Tech. Support
Administrator
Hero Member
Karma: +0/-0
Posts: 806
Re: TCP/IP Logger SQL errors - passing ":P0, :P1, etc." instead of values.
«
Reply #1 on:
April 16, 2014, 06:28:00 AM »
You should bind your columns with the parser variables on the "Binding" page. In the OPC logger the parser is built-in and you don't need to configure it. In the TCP logger you may configure the ASCII Data Parser. Please, visit the Tutorials section:
http://www.aggsoft.com/tcpip-data-logger/tutorials.htm
Logged
Transistor
Newbie
Karma: +0/-0
Posts: 2
Re: TCP/IP Logger SQL errors - passing ":P0, :P1, etc." instead of values.
«
Reply #2 on:
April 16, 2014, 06:17:01 PM »
Thanks for the reply. I had completed the bind but seemed to have an error in the Date and Time fields. For some reason these caused the error message but when I removed these fields it works OK.
As it turns out I don't need Date and Time as I'm have another field in the database called InsertTime which defaults to GETDATE(). This is better in my application as the server clock is much more likely to be accurate than my weigh scales!
Logged
Pages: [
1
]
Print
« previous
next »
Jump to:
Please select a destination:
-----------------------------
News & Feedbacks
-----------------------------
=> News and Updates
=> Site Comments
-----------------------------
Online Help Center
-----------------------------
=> Advanced Serial Port Monitor
=> Data loggers and plug-ins
=> Data loggers ActiveX
=> Advanced USB Port Monitor
=> Virtual Null Modem
=> Software for DNC and CNC
=> Other questions
-----------------------------
Development
-----------------------------
=> Feature Requests
Loading...