News:

Welcome on our forum!

Main Menu
Menu

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Show posts Menu

Messages - Transistor

#1
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!
#2
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.