Recent content by richardii

Hello I'm trying to do silent install on an x86 VM with the following commands: net use G: "\\cristienas\Uranus\Windows\x86\NetWorker Clients\Version 7.6 SP3\networkr" /user:STROUD\<user> <password> "G:\setup.exe" /s /v"/qn /L*v """%TEMP%\networker_install.log""" The log shows failure: MSI (s)...

It's a bug in Windows 2000 - XP does it OK.

I have some vbscript for copying a file - it works fine when I double-click it. However, if I try to put it under control of the Scheduled Tasks (in Windows 2000) - the task runs indefinitely (and is never successful). I've tried recoding the vbscript (as a shell call and using .CopyFile). Same...

It was messed up around the 'go's I removed those and placed all the syntax on one line, it ran through fine and created the job. In fact all I wanted to do was run an existing job (so it was much easier then I thought :) Thanks.

I'm executing it through a bat file command: ISQL -u <user> -P <password> -d <Database> -i <the script above> -o <the log file above> It appears I can log on OK, but I see the syntax errors. Unfortunately I can't use QA to execute it (it has to be done from a Virtual PC without SQL Server...

I'm generating some TSQL from the Enterprise Manager and being warned that I have GO set as my TSQL batch separator. I can't change it though (the option is greyed out). I tried changing it in SQL Query Analyzer (no effect). How can I change the TSQL batch separator? Or can I 'repair' my TSQL...

Thanks very much - that first excellent link did the trick. I used ReadBinaryFile(cFileToSearch) to read it and RSBinaryToString(xBinary) to convert to a string. It's fast (5 seconds).

The idea of searching by line is a good one - and in fact all I'm interested in is whether the string occurs (not how many times). I've done that and it works fine - the problem comes if the file is binary (I then get the message &quot;Input past end of file&quot;). Big text files are fine...

That's interesting. Nearly *all* of the time is spent reading the string in.

It was taking about 3-4 minutes to find 3 occurences in a 1,230 KB file, which did not compare with a UNIX grep at all well! I've not tried the Instr() approach.

Thanks - I've given up on this approach. It will &quot;work&quot; as long as the file is text - but it's too slow.

I'm using this code to find a string in a file. It works fine as long as the file is NOT a large binary file!! Unfortunately that's exactly what I want to look in. Any ideas what the problem might be/solution. Thanks in anticipation. Option Explicit Dim objRegExpr Dim FSO, TF, inp Dim...

This is just an example, the following code moves through the table called tbl and uses the field TABLE_NAME to step through each table's name (linking them to the database). You could adapt this as the key bit is the loop. Private Sub Command0_Click() Dim db As DAO.Database Dim rsTable As...

Remove duplicates from a table TEST. Step1: SELECT DISTINCT Tests.* INTO Tests_1 FROM Tests; Step2: DELETE Tests.* FROM Tests; Step3: INSERT INTO Tests SELECT Tests_1.* FROM Tests_1; Then get rid of the temp table tests_1: DoCmd.DeleteObject acTable, &quot;tests_1&quot;

I found WinZip's command line extension quite useful (then you're not limited to 8 char names): Dim myObjFSO Set myObjFSO = CreateObject(&quot;scripting.filesystemobject&quot;) CheckFolder &quot;C:\source&quot; Sub CheckFolder(strPath) Dim objFolder Dim objFile Dim objSubdirs...