Diary of technical happenstance, simple Internet accessible scratchpad, and brain dump to save myself later
Friday, June 25, 2004
Repartee for Windows database checks
vmailos2 dbchk /f as a database cleanup tool. Note: if running 7.47, verify Q version is 703pr15 or later. Without a PRN update from Active Voice support, bad things will happen associated with leftover Y2K issues.
vmailos2 filedump /e /nXXX /d where XXX is the record number associated with error in upgchk.log. You can manually remove these bad records (i.e. FAX_LIB on non fax enabled systems).
Thursday, June 24, 2004
Arcserve 7 for Novell Database Damage
a) At the server console, perform ASTOP
b) From a Workstation, rename the DATABASE directory which is in the ARCSERVE directory
c) Make a copy of the EMPTYDB directory and rename it to DATABASE (you effectively have a fresh blank database now)
d) Perform ASTART at the server console
e) Merge the backup tape back into the database.
f) Once this is completed, perform the restore as the tape contents will be in the new database
Subsequent backups should merge into the database as normal, previous backups will have to be merged back in.  If the tape contents are ot merging into the database for any reason, you can tweak BTrieve - post your NetWare version and Service Pack and I can post tweaks you can try
Pasted from http://tek-tips.com/gviewthread.cfm/pid/478/qid/854451
Monday, June 21, 2004
Repartee for Windows Message Order
Modifyin the message stack (i.e. subscribers then message box) will be available on 2.3.
This was available on OS/2 via MSGORDER after shutdown at command line.
Sunday, June 20, 2004
VB6 run-time error 713
Execute regsvr32 msbind.dll in X:\WINNT\System32.
Problem solved. Not sure what caused it, but the .net and Excel ideas seem relevant.
Wednesday, June 16, 2004
Repartee for Win200 and Fujitsu F9600
Assuming 4 digit PBX extensions and 7 digit SMDI extensions, you must edit the Serial_Fujitsu.ini file as follows:
DefaultExtLen= 7
SwsDefaultExtLen= 7
MinExtLen= 4
MaxExtLen= 7
MaxLampExtLen= 7
If you are stunting direct transfers to the voicemail server using forwarded 5 digit virtual lines on the 9600, you need to use Extension Remapping on the server.
Example:
Where actual MLDTs / SLTs are 1XXX, virtual lines are 31XXX, use remapping entries 31* and 1*.
Monday, June 14, 2004
Repartee for Win2000 and Iwatsu ADIX
If you wish to retain this simplicity behind a Repartee for Windows, you need to edit the AVANALOG.AVD file.
Add the lines:
Data36= 9I DIRECT
Data37= F NOANSWER
Data38= 9 OPENING
Data39= 77xxx OPENING
to the [ADIX] field.
Data 36 prompts for a password when retrieving messages, Data 37 plays greetings associated with forwarding extensions, Data 38 plays the default opening greeting for extensions dialing the voicemail system, and Data 39 sends all trunk calls to the opening greeting as well when 77 is used in the ADIX as a trunk call packet.
Be careful to retain the spaces between fields in the AVANALOG.AVD file. The above example should be used as reference for the data, not the format. I suggest you copy and paste Data 35 and edit it appropriately.
Thursday, June 10, 2004
Stop 0x0A messages installing and running XP
Short story is the VIA chipsets were the problem. You can get the latest 4in1 drivers here:
ViaArena
Tuesday, June 01, 2004
Dreamweaver MX ASP record update form
When Dreamweaver builds arrays of form fields and values, it seems to use a single quote ( ' ) SQL delimiter in all circumstances. Updating dates requires a pound ( # ) delimiter.
The following is Dreamweaver sample output:
This won't work if the field is a date format:
MM_fieldsStr = "myDate|value"
MM_columnsStr = "[myDate]|',none,NULL"
This will work:
MM_fieldsStr = "myDate|value"
MM_columnsStr = "[myDate]|#,none,NULL"
Choosing submitting as date during the form building wizard doesn't seem to have any effect.