Database access PG2
In the SV4.0 I was using the ActiveX control "Microsoft ADO Data Control 6.0" and the "Microsoft Data Grid Control 6.0" for database access in visual basic.
Now I tried to use the same database access in a SV5.1FP4 system on PG2. No visual basic installed! But if I edit the ActiveX Control in the PG2 in SV5.1, I have no opportunity to select the "Microsoft ADO Data Control 6.0". It same that this ActiveX is not installed.
Does this ActiveX (MS ADO) comes along with the VisuaBasic installation?
If yes, how can I access the database, if I don't install VisualBasic?
The possibilities to interface "the outside" is very limited in PG2 compared to VB6.
I believe you need to develop an own aspect system that exposes what you need as OPC properties, or replace your current database design with something that offers an OPC interface. Development of custom aspect systems requires substantial skills and support is not included in regular license of 800xA.
The VB programming interface was quite useful but left a lot of fault and error handling to the programmer - bad VB code could easily block the workplace and make it freeze up. VB6 is "end of life" from Microsoft and several multi CPU/thread problems remain unsolved by them - PG2 was hence developed to replace VB6.
Ask for a quotation from ABB's Consult IT group - maybe they can assist you with this development of an interface to your database.
800xA do support web page aspects; maybe you can develop your interface as a web page?
All of those Active-X controls were part of the VB6 installation. Thats why you cant find them now.
As Stefan suggests, your best bet is probably to develop a web page interface to your database. Also, you can directly open most MS applications like Word, Excel and Access inside your workplace. By default applications usually open in a separate window, but you can get these applications to open in a base display by playing with the view classes for the Aspect
If your database is MS Access, then you can generate web pages directly. But I agree these are not great. However they should work fine.
If you have some other database like MySQL, MS SQL or more complicated requirements from an MS Access database then we have had some good success using a PhP framework, called Yii (http://www.yiiframework.com/) , to create a fully functioned Web interface to databases. The advantage of this approach is that there is nothing extra to install on the 800xA system - everything is contained in the database web application. However, it is not a trivial exercise, takes some pretty specialised programming, and might be more effort that is required in your case. However, IMHO its probably easier than programming a Custom Aspect System. ( And Yii is free too :) )