WMI - InfoPath - SQL

[msnews.mircrosoft.com]

I am charged with creating an infopath form to server as our Server Birth
Certificate. The plan is as follows

As script will run after the server is built and query using wmi things like
RAM,HDD,OS,Shares,Services,etcc.. This information will be stored in a sql
database. A form would then be opened by the engineer when he/she is
completing the documentation. I would like for the engineer to type in the
server name -hit a button - and have the fields in the form populated with
data from the sql db.

I have the db built, the fields in the form tied to the db, but I don't know
how to write the button script to go 'fill in the data'. Any thoughts, any
better ways to do this.

Shaun

 

[SBFF]

(imho)
I have found that using InfoPath SP1, the InfoPath SDK and Visual Studio
..NET made programming InfoPath buttons a whole lot simpler. The scripting
capabilities that came with InfoPath (pre sp1) was for the birds.
Once you have sp1 and the infopath sdk installed, you should be able to get
into the event handler for the button and it should pop you into VStudio.
Intellisense, F1 help and step-though-debugging in VS.Net is pretty nice.
If you use InfoPath's DataAdapters to query your db, you won't have to use a
strong certificate to sign your doc, but, if you are willing to get a code
signing certificate, then you can use all of the ADO.NET stuff, etc. and you
will have more options/flexibility for coding your docs.
Good luck.
- SBFF -