Current Tag Query

[Former Member]

Newbie Tag query questions, two questions in one here -

1) We are able to pull multiple tags within a history query, but when we try a Current query it only pulls back one tag. Why doesnt it return the other tags within the Current?

2) We have been seeing odd error message occasionally, "SQLGetData: Conversion Character to Timestamp.". We thought it was the DateTime config but that is set up correctly.

Any thoughts?

[jcgood25 · Accepted solution]

Brian - glad to see you made it back from AT&T park in one piece...

1) Is this just any pair of tags, or just certain combinations?

2) Does your ODBC System DSN have any of the advanced settings checked besides Read-Only? (specifically the Timestamp sent as Character one).

1/2) Are any of your tag meta queries failing when it sends the initial request for description and scaling ranges, etc?

Regards,

Jeremy

[Former Member · Accepted solution]

You are right on with the ODBC settings, completely forgot to make those setting changes on the new server. Once we did that, we were getting multiple tags back within a Current Tag Query.

But we did get a new error and it is the same error as Ranga had in his posting:

"Char to Double" --- we're off to regulate on the IP21 team. mount up.

[jcgood25 · Accepted solution]

Good luck - Brian 'Walker Texas Ranger' Holden

[salvatore_castro]

Brian,

1) Did you test the queries as XML? Maybe the values are not supported data types, what types are the Tags defined as?

2) Are you using an ODBC connection? This error is typically associated with that. What is the scenario for ODBC?

-Sam