Wonderware Guru's Please
- Thread starter PhilipW
- Start date
jshiepe
Member
Serafin,
This may be a shot in the dark, but I noticed in your screenshot of your bindlist configuration, you called the bindlist "MyBind", but in your SQLSelect, you call it "MyBindList". Is this just a typo?
This may be a shot in the dark, but I noticed in your screenshot of your bindlist configuration, you called the bindlist "MyBind", but in your SQLSelect, you call it "MyBindList". Is this just a typo?
Yeah, it was a typo.
Actually, now that you mention it I know that the application is using the bindlist properly, because the column name is shown in the logger.
Should I use an specific data type for the tag in the bindlist? I am using Memory Int because the column that I am trying to access is integer.
Should I be using "I/O Int" types?
Actually, now that you mention it I know that the application is using the bindlist properly, because the column name is shown in the logger.
Should I use an specific data type for the tag in the bindlist? I am using Memory Int because the column that I am trying to access is integer.
Should I be using "I/O Int" types?
jshiepe
Member
Something doesn't seem right about this line in the logger:
WWSQL Error>> Select SELECT MyColumn FROM MyTable WHERE MyPrimaryKey = 1
I would think it should say:
WWSQL Error>> Select SELECT consecutivo FROM MyTable WHERE id_entrada = 1
Not sure why it would have 'MyColumn' for the column name rather than the actual column.
One other thing to check is to make sure that the tag you created to store the value is Read/Write. It should be a Memory Integer type, so that part is OK.
Running out of ideas, but maybe we'll stumble on something soon.
WWSQL Error>> Select SELECT MyColumn FROM MyTable WHERE MyPrimaryKey = 1
I would think it should say:
WWSQL Error>> Select SELECT consecutivo FROM MyTable WHERE id_entrada = 1
Not sure why it would have 'MyColumn' for the column name rather than the actual column.
One other thing to check is to make sure that the tag you created to store the value is Read/Write. It should be a Memory Integer type, so that part is OK.
Running out of ideas, but maybe we'll stumble on something soon.
jshiepe
Member
Had another thought. When you set up your DSN, did you set it up with the a login name and password that has the permissions to SELECT from the table? You had said that you ran the query successfully from another external tool, so was wondering if you were logged in through that tool with the same user you set in your DSN.
Sorry, once again, for the confusion.
I used the names "MyColumn", "MyPrimaryKey" and "MyTable" as example; they are not the actual names that I am using. The problem is not there.
Actually, the query from the external tool was ran using the same DSN (therefore the same user), so I should be able to perform the SELECT.
I believe that the problem is in my Wonderware app (I am not configuring correctly something), considering that I am getting the same error when I try to retrieve data from an Access database. In the bindlist configuration says that I should introduce the "Tagname.FieldName", but I am just introducing the tagname. Should I add the field?
NOTE: I tried the exact same query that I got in the Wonderware logger from the external tool and it was successful at retrieving the required data.
I used the names "MyColumn", "MyPrimaryKey" and "MyTable" as example; they are not the actual names that I am using. The problem is not there.
Actually, the query from the external tool was ran using the same DSN (therefore the same user), so I should be able to perform the SELECT.
I believe that the problem is in my Wonderware app (I am not configuring correctly something), considering that I am getting the same error when I try to retrieve data from an Access database. In the bindlist configuration says that I should introduce the "Tagname.FieldName", but I am just introducing the tagname. Should I add the field?
NOTE: I tried the exact same query that I got in the Wonderware logger from the external tool and it was successful at retrieving the required data.
jshiepe
Member
Issue may be with MDAC version. You should be at version 2.5 SP2 or later. MDAC downloads at:
http://msdn.microsoft.com/en-us/data/aa937730
http://msdn.microsoft.com/en-us/data/aa937730
I solved the issue. It was with the MDAC version as jshiepe suggested. I struggled a little bit in order to be able to update the MDAC but now I'm all done.
Matt, I know that NT is so old; but unfortunately we are stuck with it at the moment. We will get rid of it in a few months =).
Thank you very much for your help!
Matt, I know that NT is so old; but unfortunately we are stuck with it at the moment. We will get rid of it in a few months =).
Thank you very much for your help!
6 years and still no actual education or training on wonderware.
Still need a tutor of some sort..
jshiepe
Member
Well... honestly, you can't expect a 7 year old link to be any good.
Call over to Logic, ask for Dave. They can hook you up with WW training. They run regular training sessions - been working with them for years...
Matthias von Zorn
Member
Wonderware Training
There is always the official classes.
http://www.wonderwarenorth.com/training/index.asp
http://wonderwarepacwest.com/region?return=training
And others too.
The other option is to just try it and ask questions here on what you get stuck on.
matthias
There is always the official classes.
http://www.wonderwarenorth.com/training/index.asp
http://wonderwarepacwest.com/region?return=training
And others too.
The other option is to just try it and ask questions here on what you get stuck on.
matthias
I don't think you guys are understanding him, I am in the same boat, I too have to try to learn this on my own, I understand there are official classes, however, the company feels that expense is not warranted. However, I am being told the same thing, learn it on my own.
So what are those of us to do, if we cannot afford out of our pocket and yet the companies that hired us, will not spend the change to send us to those official schools.
I don't even know what a Indirect Tag is, does or how to make one, but im suppose to figure it out?
So what are those of us to do, if we cannot afford out of our pocket and yet the companies that hired us, will not spend the change to send us to those official schools.
I don't even know what a Indirect Tag is, does or how to make one, but im suppose to figure it out?
The WonderWare manuals are pretty good. I've been "doing" WW for almost 20 years and have never been to a class myself. The manuals, trial-and-error and the lot all still work.
I assume you're in the KC area too - contact the guys at Logic. They are good to work with and will likely have some information they can share with you.
I assume you're in the KC area too - contact the guys at Logic. They are good to work with and will likely have some information they can share with you.
Similar Topics
Some upgrading questions....
I have clients that want to upgrade to the latest Wonderware 2012 R2 aka 10.6 version, running on windows 7. Some of...
Hi guys,
I have experience with PLC to Excel etc...just starting on using intouch scada screens.
I have an Excel sheet that uses mainly...
Hello everyone,
Recently, my Archestra IDE shut down while I was editing. After restarting the IDE, I noticed warning symbols under my opened...
Good morning all.
I'm working on a rehab where they had a standalone InTouch 2014 HMI that they called a SCADA, but it's really basic stuff. The...
Hi,
We are setting up an Aveva Plant SCADA node with the intention to connect it to a Wonderware Historian node.
Everywhere I look online I see...