7/13/2006 10:48 AM | |
Joined: 9/27/2005 Last visit: 11/27/2007 Posts: 1398 Rating: (151)
|
I learnt SQL, ADO and VB / VBS / VBA using the internet. Takes a long time and a lot of effort but it's free [:D] I would strongly recommend a training course on SQL, ADO, VB, database fundamentals, etc. However if this is not feasible then here are a few sites to get you started ... Great for fundamentals and examples http://www.w3schools.com/vbscript/default.asp http://www.w3schools.com/sql/default.asp http://www.w3schools.com/ado/default.asp VBA http://msdn.microsoft.com/vba/ VBS http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/c5218612-eb23-4729-817c-65ffd0d41b61.asp Microsoft script repository http://www.microsoft.com/technet/scriptcenter/scripts/default.mspx Only use V6 examples ! http://www.wincc.net/ ... and of course, good old Google Groups http://groups.google.co.uk/grphp?hl=en&tab=wg&q= Like I say, none of these will be exactly what you want. However it should be enough to get you started. The Connectivity Pack is a developers tool and expects you to already know all this. If you don't then you may want to consider DataMonitor instead. DataMonitor requires no scripting knowledge [;)] |
7/13/2006 3:27 PM | |
Joined: 9/27/2005 Last visit: 11/27/2007 Posts: 1398 Rating: (151)
|
Nice code snippet lkkezelf [8)] |
7/14/2006 12:19 PM | |
Posts: 1084 Rating: (72)
|
Hi, Please note that the time of the SQL Server is in UTC time, and could therfore be different then the local time set on your pc ! with regards, Ikkezelf |
7/14/2006 12:48 PM | |
Posts: 54 Rating: (2) |
Yes you are right. I didn't cathc that because I've used statical data. Many thanks. |
7/20/2006 6:16 PM | |
Posts: 54 Rating: (2) |
Any idea why I didn't succeded connecting with CC_ExternalBrowsing ? |
7/21/2006 9:18 AM | |
Joined: 9/27/2005 Last visit: 11/27/2007 Posts: 1398 Rating: (151)
|
Open Start -> Programs -> Microsoft SQL Server -> Enterprise Manager. Expand the tree to see your server and the databases in it. Can you see a CC_ExternalBrowsing database ? |
7/21/2006 10:45 AM | |
Posts: 54 Rating: (2) |
Salma, no there is no CC_ExternalBrowsing database. |
7/21/2006 10:49 AM | |
Joined: 9/27/2005 Last visit: 11/27/2007 Posts: 1398 Rating: (151)
|
That would explain why it does not work [:D] You only get this database when you install the Connectivity Pack Server. You could try installing (or reinstalling if it is already there). |
7/21/2006 10:56 AM | |
Posts: 54 Rating: (2) |
Yes it does. I've installed the connectivity pack client. As I've read in the help it is enough for reading the databases. Is the price different for client / server ? 10x once again |
7/21/2006 11:02 AM | |
Joined: 9/27/2005 Last visit: 11/27/2007 Posts: 1398 Rating: (151)
|
Hi It is the same license for the server and the clients [:D] You install the Connectivity Pack Server and the license on the WinCC machine. You can then install the Connectivity Pack client on any remote computers that need it. You do not need to install a Connectivity Pack license on these remote computers. Salma |
7/21/2006 11:49 AM | |
Posts: 54 Rating: (2) |
Oh I've missed that. Thank you |