SAPIEN Technologies

Here is a simple bootstrap for creating a new database from vbs:     sPath = "E:ProjectsscriptsMSAccess"     sDBName = "MyDB.mdb"     dbLangGeneral = ";LANGID=0x0409;CP=1252;COUNTRY=0"     Dim app As Access.Application     Set app = CreateObject("Access.Application...

Suggestion: Create a template database using MSAccess. Place query in template file. Make a copy of the template to a new name and inject the data into a pre-existing table or tables that the query will use. You can also automate teh whole reporting process in MSAccess and just use data from an exte...

Great - glad to help. That one threw me fo a loop when reading in unicode files. That's when I found the KB and tested the incremental read method.

Your should work woth readline and a Ctrl-Z except if you are MUI.

Bill Just decided to check some of my systems. MPS Reports (%windir%MPSReports) no longer use much scrip and what is used is vbscript. Note that MPSReports is a good place to see how MS collects information about a platforms oinstallation status and state using a completely stand-alone commandline p...

The MS product analysis tools use jscript for some components and versions. YOu can download the tools at ms downloads I believe. From teh MS installer packages ( search %windir% for "*.js" you;ll find a ton of scripts. function ErrorSkipBtnHandler(){ if (InActivation_AppMode()) { window.e...

Agreed.

It's interesting to note that for a very large number of internal scripts MS uses JScript. They also have a pretty good set of JS functionlibraries that are used in many products.

Bill Yes I agree mostly. JScript is much better for designing complex code structures and has great support for exception handling. The biggest drawback for many admins is a lack of any formal training in programming. JScript is a more technical language by design and does require a fairly long and ...

Ctrl-Z.

That is the text tream end-of-stream trigger. You probably won't get it if you are doing paste as paset uses a different method for feeding the clipboard to the console.

reading = true
While reding line = WScript.StdIn.ReadLine()
if line = "some end value" Then
reading = false
End If
input = input & lineWend
depends on exact format of the input stream.

This apears to be a usual issue with TS. You have moved the user profile under TS sessions. The profile crates a temporary file folder under teh user temp folder. The TS session does not completely delete the ftemporary files when the session terminates. Look at teh TS session settings and be sure t...