on 11-27-2007 2:48 AM
Hi all,
I'm really newbie in Tags but i'm with the following problem:
I'm trying to access value from a specified data range in a Tag that returns just string to me, but I can't use the HistoryEvent Mode like I was doing for Tag Queries that return me number, I would like to know how to retrieve "non-current" string data from a Tag Query.
Thanks in advance.
Pedro Sena
Pedro,
Why can't you use HistoryEvent mode?
Sam
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sam, is this that you are looking for? :
Connector InSQL
ConnectorID
ConnectorType TAG
DatePrefix '
DateSuffix '
DaysRetention 7
Description ---
Enabled T
InternalDateFormat MM-dd-yyyy HH:mm:ss
JDBCDriver com.inet.tds.TdsDriver
MaxRetryCount 5
Name Alicorp_InSQL
PoolMax 100
PoolSize 1
RetryInterval 60000
ServerPackage com.sap.xmii.Illuminator.connectors.InSQL
ServerURL jdbc:inetdae:aliargsql1:1433?database=Runtime&sql7=true
Timeout 15
UseCount 256
UseOLEDB true
UserName wwAdmin
ValidationQuery SELECT GETDATE()
WaitTime 30
Tnx
Pedro,
From what I hear around the office, string are not supported via the Tag Query interface since they are handled differently on the InSQL side. Instead you can write the OLEDB sql query against the system to get the information. Create an IDBC SQL Type connection to the system and use your query from SQL Analyzer you mentioned earlier to get the data you need.
Hope this helps.
Sam
User | Count |
---|---|
4 | |
4 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.