DOCUMENT:Q153838  18-FEB-2002  [mspress]
TITLE   :FILE: Name Expansion Utility/"Hitchhiker's Guide to VB and SQL"
PRODUCT :Microsoft Press
PROD/VER::4.0,6.0
OPER/SYS:
KEYWORDS:

======================================================================
-------------------------------------------------------------------------------
The information in this article applies to:

 - MSPRESS Hitchhiker's Guide to Visual Basic and SQL Server ISBN 1-55615-906-4 
 - Microsoft Visual Basic Enterprise Edition, 32-bit, for Windows, version 4.0 
 - Microsoft SQL Server version 6.0 
-------------------------------------------------------------------------------

SUMMARY
=======

Windows 95 using Real-mode (MS-DOS) CD-ROM drivers and Windows NT 3.51 are both
unable to read the long file names on the companion compact disc for the book
"Hitchhiker's Guide to Visual Basic and SQL Server." NAMEXPAN.EXE is a utility
that copies the long file names to a hard disk, and then renames the short file
names to their original long file names.

The following file is available for download from the Microsoft Download Center:

   NAMEXPAN.EXE
   (http://download.microsoft.com/download/vb40pro/MSPRESS/2.0/WIN98Me/EN-US/NAMEXPAN.EXE)

For additional information about how to download Microsoft Support files, click
the article number below to view the article in the Microsoft Knowledge Base:

   Q119591 How to Obtain Microsoft Support Files from Online Services

Microsoft used the most current virus detection software available on the date of
posting to scan this file for viruses. Once posted, the file is housed on secure
servers that prevent any unauthorized changes to the file.

MORE INFORMATION
================

INSTALLATION INSTRUCTIONS
-------------------------

1. Download the NAMEXPAN.EXE self-extracting executable.

2. Run NAMEXPAN.EXE to extract the NAMEXPAN.BAT file.

3. If you will be installing the CD-ROM files to a different hard disk, move
   NAMEXPAN.BAT to the hard disk you intend to install the CD-ROM files to

   NOTE: To run this batch file successfully you must:

    - save it to the hard disk drive to which you will be installing the compact
      disc contents

    - save it as NAMEXPAN.BAT because this file calls itself by that name

    - Delete any previous directory tree by the name of C:\VBSQL (or other name
      if not installing to the default directory)

4. Double-click NAMEXPAN.EXE from File Manager or any other file viewing
   program, or run this batch file from a command prompt.

5. Delete NAMEXPAN.EXE, NAMEXPAN.BAT, and README.TXT.

If you have any questions or problems with this name-expansion utility, please
send email to MSPINPUT@MICROSOFT.COM and include any error messages and the
amount of free disk space on your hard disk.

NAMEXPAN.EXE FILE CONTENTS
--------------------------

 - README.TXT Contains basic usage information for NAMEXPAN.BAT

 - NAMEXPAN.BAT Filename expansion utility, with usage and description included
   in batch file program.

If you cannot download the NAMEXPAN.EXE patch, copy the following text to a new
text document using Microsoft Notepad, and then save the file as NAMEXPAN.BAT.
After saving this file, use Notepad to search the batch file for the word
WARNING and follow any further instructions before running this batch file.

   rem *** BEGINNING OF NAMEXPAN.BAT
   @echo off
   @echo ***************************************************
   @echo "Hitchhiker's Guide to Visual Basic and SQL Server"
   @echo      CD-ROM short filename expansion utility
   @echo -
   @echo version 1.0
   @echo created 7/17/96 by Microsoft Press
   @echo ***************************************************
   @echo -
   @echo This utility installs the contents of the "Hitchhiker's Guide
   @echo to Visual Basic and SQL Server" companion CD-ROM to your hard
   @echo disk and then renames all short filenames to their original long
   @echo filenames.
   @echo -
   @echo NOTE: This utility requires 35 MB of hard disk space on the
   @echo target hard disk.
   @echo -
   @echo -
   @echo USAGE: NAMEXPAN (CD-ROM drive) (Destination drive and directory)
   @echo EXAMPLE: NAMEXPAN D: C:\VBSQL
   @echo -
   @echo -

   IF "%1"=="RENAME" goto BEGIN_RENAME
   IF "%1"=="" goto NO_PARAMETERS
   IF "%2"=="" goto ONE_PARAMETER
   IF NOT "%3"=="" goto TOO_MANY_PARAMETERS
   goto BEGIN_COPY

   :NO_PARAMETERS
   @echo No parameters were entered. To abort, press Ctrl+C.
   @echo to accept the default parameters:
   @echo      NAMEXPAN D: C:\VBSQL
   @echo -
   pause
   @echo Calling NAMEXPAN with the proper paramaters...
   NAMEXPAN D: C:\VBSQL
   goto END

   :ONE_PARAMETER
   @echo One parameter was entered. To abort, press Ctrl+C.
   @echo to accept the parameters:
   @echo      NAMEXPAN %1 C:\VBSQL
   @echo -
   pause
   @echo Calling NAMEXPAN with the proper paramaters...
   NAMEXPAN %1 C:\VBSQL
   goto END

   :TOO_MANY_PARAMETERS
   @echo This utility only accepts two parameters.  Please check
   @echo the usage syntax above and try again.
   goto END

   :BEGIN_COPY
   @echo Verifying CD-ROM source...
   IF NOT EXIST %1HHGV51.AVI GOTO INVALID_SOURCE
   @echo Ready to copy CD-ROM contents from %1 to %2...
   pause

   rem Copy all files except HHGV51.AVI
   MKDIR %2
   XCOPY %1\VBSQL %2\VBSQL /S /E /I
   XCOPY %1\APEXGRID %2\APEXGRID /S /E /I
   XCOPY %1\INTRO %2\INTRO /S /E /I
   XCOPY %1\ODBCAPI %2\ODBCAPI /S /E /I
   XCOPY %1\PUBLICAT %2\PUBLICAT /S /E /I
   XCOPY %1\SAMPLE~1 %2\SAMPLE~1 /S /E /I
   XCOPY %1\README.DOC %2
   XCOPY %1\README.RTF %2
   XCOPY %1\VBDATA-L.TXT %2

   rem * Need to copy hidden directory %1\publicat\vbits\sample~1\orland~1
   rem * WARNING: Microsoft Knowledge Base is unable to store long XCOPY
   rem * commands on one line. Extra carriage return must be removed before
   rem * this utility can successfully be used.
   @echo -
   @echo WARNING: This batch file requires the next XCOPY command to be on
   @echo one line. If an error occurs, please edit NAMEXPAN.BAT using
   @echo Notepad and delete the carriage return at the end of the first
   line
   @echo below.
   @echo on
   XCOPY %1\publicat\vbits\sample~1\orland~1
   %2\publicat\vbits\sample~1\orland~1 /S /I
   @echo off
   rem * now that XCOPY of hidden directory orland~1 is long done,
   rem * reset hidden attribute
   attrib -h %2\publicat\vbits\sample~1\orland~1
   goto BEGIN_RENAME

   :INVALID_SOURCE
   @echo The file %1HHGV51.AVI was not found. Please insert the
   @echo Hitchhiker's Guide to Visual Basic and SQL Server CD-ROM
   @echo in drive %1 and press any key (or press CTRL+C to abort).
   pause
   goto BEGIN_COPY

   :BEGIN_RENAME
   @echo -
   IF NOT EXIST %2\VBDATA-L.TXT echo %2\VBDATA-L.TXT not found!
   IF NOT EXIST %2\VBDATA-L.TXT echo Check batchfile or manually XCOPY
   files.
   @echo -
   @echo Ready to begin renaming files in %2 to original long filenames.
   @echo Press Ctrl+C to abort, or
   pause

   @echo -
   @echo Any errors will be listed between the dashed lines below.
   @echo Please edit or review NAMEXPAN.BAT contents to resolve any errors
   @echo you might encounter.
   @echo ------------------- BEGIN ERRROR LOG -------------------------
   set TEMP_PROMPT=%prompt%
   prompt expanding names$g

   rem * To troubleshoot any files that do not rename properly, remove
   rem * the "rem" from the following line, and then use the pause key
   rem * and space bar to locate the specific filenames.
   rem echo on

   rem * NOTE: If you encounter many "file not found" errors, check to make
   rem * sure you have at least 35 MB of hard disk space before running
   rem * this utility. Insufficient disk space will cause the XCOPY
   rem * commands to fail, which will then cause the file-by-file rename
   rem * commands to not find files.
    Cd %2\ 
   RENAME APEXGRID        ApexGrid
   RENAME INTRO           Intro
   RENAME ODBCAPI         ODBCAPI
   RENAME PUBLICAT        Publicat
   RENAME README.DOC      Readme.doc
   RENAME README.RTF      Readme.rtf
   RENAME SAMPLE~1        "Sample Code"
   RENAME VBDATA-L.TXT    VBDATA-L.txt
   RENAME VBSQL           VBSQL
   rem HHGV51.AVI is a 70 MB long author introduction video, and is
   readable
   rem directly from the CD-ROM.
   rem RENAME HHGV51.AVI      hhgv51.avi

    Cd %2\ApexGrid
   RENAME CONTAC~1.TXT    "Contacting Apex.txt"
   RENAME DBGRID~1        "DBGrid Help files"
   RENAME DBGRID~2        "DBGrid Unbound Mode"
   RENAME FTPSNA~1.96     "FTP Snapshot As of 3.15.96"
   RENAME README.TXT      README.TXT
   RENAME TRUEDB~1        "True DBGrid Standard - 16bit"
   RENAME TRUEDB~2        "True DBGrid Standard - 32bit"

    Cd %2\ApexGrid\"DBGrid Help files"
   RENAME DBGHLP~1.URL    "Dbghlp.exe (ftp.apexsc.com).url"
   RENAME INSTALL.LOG     INSTALL.LOG
   RENAME DBGHLP.EXE      dbghlp.exe
   RENAME TDBGHLP.EXE     tdbghlp.exe

    Cd %2\ApexGrid\"DBGrid Unbound Mode"
   RENAME DBGRIDUB.ZIP    dbgridub.zip

    Cd %2\ApexGrid\"FTP Snapshot As of 3.15.96"
   RENAME DEMOS           Demos
   RENAME INDEX.TXT       INDEX.txt
   RENAME INDEX2~1.TXT    "Index 2.txt"
   RENAME PUBDIR~1.HTM    "Pub directory.htm"
   RENAME TGPATCH         TgPatch
   RENAME CALLBACK.ZIP    callback.zip
   RENAME DBGHLP.EXE      dbghlp.exe
   RENAME DBGRIDUB.ZIP    dbgridub.zip
   RENAME EDITMASK.ZIP    editmask.zip
   RENAME LINKGRID.ZIP    linkgrid.zip
   RENAME MARKGRID.ZIP    markgrid.zip
   RENAME MSVIBM.ZIP      msvibm.zip
   RENAME TABLEVW.ZIP     tablevw.zip
   RENAME TDBGHLP.EXE     tdbghlp.exe
   RENAME TDBGSX16.EXE    tdbgsx16.exe
   RENAME TDBGSX32.EXE    tdbgsx32.exe
   RENAME TGPSCR.ZIP      tgpscr.zip
   RENAME TGSHLP.ZIP      tgshlp.zip
   RENAME TGSTD.ZIP       tgstd.zip
   RENAME UB_OCX.ZIP      ub_ocx.zip
   RENAME W32SOLE.EXE     w32sOLE.exe

    Cd %2\ApexGrid\"FTP Snapshot As of 3.15.96"\Demos
   RENAME INDEX.TXT       Index.txt
   RENAME PRODBMPS.ZIP    prodbmps.zip
   RENAME TGDEMO.EXE      tgdemo.exe
   RENAME VBACOMP.EXE     vbacomp.exe

    Cd %2\ApexGrid\"FTP Snapshot As of 3.15.96"\TgPatch
   RENAME INDEX.TXT       Index.txt
   RENAME TGP21C.EXE      tgp21c.exe
   RENAME TGPTAB.EXE      tgptab.exe
   RENAME TGS21A.EXE      tgs21a.exe
   RENAME TGSHLP.ZIP      tgshlp.zip
   RENAME TPATCH.EXE      tpatch.exe

    Cd %2\ApexGrid\"True DBGrid Standard - 16bit"
   RENAME TDBGSX16.EXE    tdbgsx16.exe

    Cd %2\ApexGrid\"True DBGrid Standard - 32bit"
   RENAME TDBGSX32.EXE    tdbgsx32.exe

    Cd %2\Intro
   RENAME BOOKIN~1.VBP    BookIntro.vbp
   RENAME FORM1.FRM       Form1.frm
   RENAME FORM1.FRX       Form1.frx

    Cd %2\Publicat
   RENAME DOCUME~1        "Documents and White Papers"
   RENAME PRESEN~1        Presentations
   RENAME VBITS           VBits

    Cd %2\Publicat\"Documents and White Papers"
   RENAME ASIDET~1.DOC    "A Side Trip to SQL OLE.doc"
   RENAME AWALKI~1.DOC    "A Walking Tour of RDO.doc"
   RENAME ADVANC~1.DOC    "Advanced RDO Techniques (VBITS 96).doc"
   RENAME ADVANC~2.DOC    "Advanced VBSQL Techniques.doc"
   RENAME CREATI~1.DOC    "Creating Parameter Queries with RDO.doc"
   RENAME EXECUT~1.DOC    "Executing Stored Procedures with RDO.doc"
   RENAME RDOASY~1.DOC    "RDO Asynchronous Operations.doc"
   RENAME RDOTHE~1.DOC    "RDO The new gateway to SQL Server.doc"
   RENAME RDOAND~1.DOC    "RDO and VBSQL Connectivity (Vbits 95).doc"
   RENAME REMOTE~1.DOC    "Remote Server Connectivity (Vbits 95).doc"
   RENAME THEVBS~1.DOC    "The VBSQL Portage to RDO.doc"
   RENAME WHAT'S~1.DOC    "What's New in VB4 Data Access (VBits 95).doc"

    Cd %2\Publicat\Presentations
   RENAME ADVANC~1.PPT    "Advanced RDO Techniques (VBits 95 SFO).ppt"
   RENAME ADVANC~2.PPT    "Advanced RDO Techniques (VBits 96 SFO).ppt"
   RENAME ADVANC~3.PPT    "Advanced VBSQL Techniques (vbits 95).ppt"
   RENAME REMOTE~1.PPT    "Remote Server Connectivity (Vbits 95
   Orlando).ppt"
   RENAME REMOTE~2.PPT    "Remote Server Connectivity.ppt"
   RENAME WHAT'S~1.PPT    "What's new with VB4 Data Access (SFO '96).ppt"
   RENAME WHAT'S~2.PPT   "What's new with VB4 Data Access.ppt"

    Cd %2\Publicat\VBits
   RENAME SAMPLE~1        "Sample Code"

    Cd %2\Publicat\VBits\"Sample Code"
   RENAME MISCEL~1        "Miscellaneous Files"
   RENAME MULTIP~1        "Multiple Interface Demo"
   RENAME OLEAUT~1        "OLE Automation Demo"
   RENAME OLEAUT~2        "OLE Automation Time Demo"
   RENAME ORLAND~1        "Orlando Sample Applications"
   RENAME SHOWDS~1        "Show DSNs with ODBC"

    Cd %2\Publicat\VBits\"Sample Code"\"Miscellaneous Files"
   RENAME MODULE1.BAS     Module1.bas
   RENAME MAKEPH~1.SQL    "make phones.sql"

    Cd %2\Publicat\VBits\"Sample Code"\"Multiple Interface Demo"
   RENAME MULTIP~1.FRM    "Multiple Interface Demo.Frm"
   RENAME MULTIP~1.VBP    "Multiple Interface Demo.Vbp"
   RENAME MULTIP~1.EXE    "Multiple Interface Demo.exe"
   RENAME MULTIP~1.FRX    "Multiple Interface Demo.frx"
   RENAME MULTIP~1.LOG    "Multiple Interface Demo.log"
   RENAME VBSQL.BAS       Vbsql.bas

    Cd %2\Publicat\VBits\"Sample Code"\"OLE Automation Demo"
   RENAME CREATE~1.SQL    "Create Customer Table.sql"
   RENAME CUSTOMER.FRM    Customer.frm
   RENAME OLEAUT~1.CLS    "OLE Automation Repair Server.Cls"
   RENAME OLEAUT~1.BAS    "OLE Automation Repair.bas"
   RENAME OLEAUT~1.VBP    "Ole Automation Server.Vbp"
   RENAME CUSTOMER.VBP    customer.vbp

    Cd %2\Publicat\VBits\"Sample Code"\"OLE Automation Time Demo"
   RENAME GLOBAL.BAS      Global.bas
   RENAME OLEAUT~1.VBP    "OLE Automation Time Object Server.Vbp"
   RENAME TIMECA~1.VBP    "Time Calc.Vbp"
   RENAME TIMEOB~1.CLS    "Time Object.cls"
   RENAME TIMERE~1.VBP    "Time Requestor.Vbp"
   RENAME TIMERE~1.FRM    "Time requestor.frm"
   RENAME TIMERE~1.FRX    "Time requestor.frx"
   RENAME TIMECALC.CLS    "TimeCalc.cls"

    Cd %2\Publicat\VBits\"Sample Code"\"Orlando Sample Applications"
   RENAME DATATIME.EXE    datatime.exe
   RENAME RDOASY2.FRM     rdoasy2.frm
   RENAME RDOASY2.FRX     rdoasy2.frx
   RENAME RDOASY2.VBP     rdoasy2.vbp

    Cd %2\Publicat\VBits\"Sample Code"\"Show DSNs with ODBC"
   RENAME SHOWDS~1.VBP    "Show DSNs using ODBC APIs.Vbp"
   RENAME SHOWDSN.FRM     ShowDSN.frm
   RENAME ODBC32.TXT      odbc32.txt

    Cd %2\"Sample Code"
   RENAME DATABA~1        Databases
   RENAME JETDAT~1        "Jet Data Control"
   RENAME MULTIP~1        "Multiple Interface Comparison"
   RENAME PICTURES        Pictures
   RENAME RDOSAM~1        "RDO Samples"
   RENAME SPWHOC~1        "SP Who Client-Server"
   RENAME SQLWOR~1        "SQL Work"
   RENAME TEXTFI~1        "Text files"
   RENAME VBSQL           VBSQL

    Cd %2\"Sample Code"\16BIT
   RENAME BASICV~1        "Basic VBSQL"
   RENAME ODBCQS.FRM      ODBCqs.frm
   RENAME SAMPLE1.FRM     SAMPLE1.FRM
   RENAME SAMPLE1A.FRX    SAMPLE1a.frx
   RENAME SAMPLE2.FRM     SAMPLE2.FRM
   RENAME SAMPLE3.LOG     SAMPLE3.log
   RENAME VBSQL.BAS       VBSQL.BAS
   RENAME ODBCQS.MAK      odbcQS.mak
   RENAME SAMPLE3A.MAK    sample3a.mak
   RENAME VB3SAMP3.FRM    vb3Samp3.frm
   RENAME VB3SAMP3.MAK    vb3samp3.mak
   RENAME VBSQLQS.FRM     vbsqlQS.frm
   RENAME VBSQLQS2.VBP    vbsqlQS2.vbp
   RENAME VBSQLQS2.FRM    vbsqlqs2.frm

    Cd %2\"Sample Code"\32BIT
   RENAME DATACO~1        "Data Control Quick Start"
   RENAME ENUMER~1        "Enumerate all types"
   RENAME JETDAO~1        "Jet DAO Quick Start"
   RENAME JETDAT~1        "Jet Data Control Quick Start"
   RENAME ODBCQU~1        "ODBC Quick Start"
   RENAME RDCQUI~1        "RDC Quick Start"
   RENAME RDOQUI~1        "RDO Quick Start"
   RENAME SQLINF~1        "SQLInfo Call Test"

    Cd %2\"Sample Code"\32BIT\"Data Control Quick Start"
   RENAME DATACO~1.FRM    "Data control Quick Start.Frm"
   RENAME DATACO~1.VBP    "Data control Quick Start.Vbp"
   RENAME DATACO~1.FRX    "Data control Quick Start.frx"

    Cd %2\"Sample Code"\32BIT\"Enumerate all types"
   RENAME 42TYPE.TXT      42type.txt
   RENAME 60TYPE.TXT      60type.txt
   RENAME CREATE~1        "Create All types"
   RENAME ENUMER~1.FRM    "Enumerate All 42 Types.Frm"
   RENAME ENUMER~1.VBP    "Enumerate All 42 Types.Vbp"
   RENAME ENUMER~2.FRM    "Enumerate All 60 Types.Frm"
   RENAME ENUMER~2.VBP    "Enumerate All 60 Types.Vbp"
   RENAME ENUMER~3.FRM    "Enumerate All Types.Frm"
   RENAME ENUMER~3.VBP    "Enumerate All Types.Vbp"

    Cd %2\"Sample Code"\32BIT\"Enumerate all types"\"Create All types"
   RENAME CREATE~1.FRM    "Create All VB Types.Frm"
   RENAME CREATE~1.VBP    "Create All VB4 Types.Vbp"

    Cd %2\"Sample Code"\32BIT\"Jet DAO Quick Start"
   RENAME DAOQUI~1.FRM    "DAO QuickStart.Frm"
   RENAME DAOQUI~1.FRX    "DAO QuickStart.frx"
   RENAME JETDAO~1.VBP    "Jet DAO QuickStart.Vbp"

    Cd %2\"Sample Code"\32BIT\"Jet Data Control Quick Start"
   RENAME JETDAT~1.FRM    "JET Data Control Quick Start.Frm"
   RENAME JETDAT~1.VBP    "Jet Data Control Quick Start.Vbp"

    Cd %2\"Sample Code"\32BIT\"ODBC Quick Start"
   RENAME ODBCQU~1.FRM    "ODBC QuickStart.Frm"
   RENAME ODBCQU~1.VBP    "ODBC QuickStart.Vbp"
   RENAME ODBC32.TXT      odbc32.txt

    Cd %2\"Sample Code"\32BIT\"RDC Quick Start"
   RENAME MSRDCQ~1.FRM    "MSRDC QuickStart.Frm"
   RENAME MSRDCQ~1.VBP    "MSRDC QuickStart.Vbp"
   RENAME MSRDCQ~1.FRX    "MSRDC QuickStart.frx"

    Cd %2\"Sample Code"\32BIT\"RDO Quick Start"
   RENAME RDOQUI~1.FRM    "RDO QuickStart.Frm"
   RENAME RDOQUI~1.VBP    "RDO QuickStart.Vbp"

    Cd %2\"Sample Code"\32BIT\"SQLInfo Call Test"
   RENAME SQLINF~1.FRM    SQLInfoCall.Frm
   RENAME SQLINF~1.VBP    SQLInfoCall.Vbp
   RENAME ODBC32.TXT      odbc32.txt

    Cd %2\"Sample Code"\Databases
   RENAME ATTACH.MDB      Attach.mdb
   RENAME JETPUBS.LDB     JETPUBS.LDB
   RENAME JETPUBS.MDB     JetPubs.mdb
   RENAME NOTABLES.LDB    NOTABLES.LDB
   RENAME NOTABLES.MDB    NoTables.mdb
   RENAME CURSOR.MAP      cursor.map

    Cd %2\"Sample Code"\"Jet Data Control"
   RENAME BASIC           Basic
   RENAME DATACO~1        "Data Control Population Test"
   RENAME ERRORH~1.BAS    ErrorHandler.bas
   RENAME MULTIP~1        "Multiple Data Control Test"
   RENAME RAISER~1        "RAISERROR Test"
   RENAME RTFSHO~1        "RTF ShowLog Test"
   RENAME SQLPAS~1        "SQL PassThrough Test"
   RENAME UPDATE~1        "Update Log Test"

    Cd %2\"Sample Code"\"Jet Data Control"\Basic
   RENAME BASICD~1.VBP    "Basic Data control test.Vbp"
   RENAME BASICD~1.FRM    "Basic data control test.Frm"

    Cd %2\"Sample Code"\"Jet Data Control"\"Data Control Population Test"
   RENAME DATACO~1.FRM    "Data Control Population Test.Frm"
   RENAME DATACO~1.VBP    "Data Control Population Test.Vbp"

    Cd %2\"Sample Code"\"Jet Data Control"\"Multiple Data Control Test"
   RENAME MULTIP~1.FRM    "Multiple Data Control Test.Frm"
   RENAME MULTIP~1.VBP    "Multiple Data Control Test.Vbp"

    Cd %2\"Sample Code"\"Jet Data Control"\"RAISERROR Test"
   RENAME RAISER~1.SQL    "RAISERRROR Stored Procedure.SQL"
   RENAME TESTRA~1.FRM    "Test RAISERROR.Frm"
   RENAME TESTRA~1.VBP    "Test RAISERROR.Vbp"

    Cd %2\"Sample Code"\"Jet Data Control"\"RTF ShowLog Test"
   RENAME RTFSHO~1.FRM    "RTF ShowLog.Frm"
   RENAME RTFSHO~1.FRX    "RTF ShowLog.frx"
   RENAME RTFSHO~1.LOG    "RTFSHO~1.log"
   RENAME SHOWOD~1.FRM    "Show ODBC Log.Frm"
   RENAME SHOWOD~1.VBP    "Show ODBC Log.Vbp"
   RENAME SHOWOD~1.FRX    "Show ODBC Log.frx"

    Cd %2\"Sample Code"\"Jet Data Control"\"SQL PassThrough Test"
   RENAME JETTEST.TXT     Jettest.txt
   RENAME SQLPAS~1.FRM    "SQL PassThrough test.Frm"
   RENAME SQLPAS~1.VBP    "SQL PassThrough test.vbp"
   RENAME SQLPAS~2.FRM    "SQL PassThrough test2.Frm"
   RENAME ATTACH.MDB      attach.mdb

    Cd %2\"Sample Code"\"Jet Data Control"\"Update Log Test"
   RENAME RTFSHO~1.FRM    "RTF ShowLog.Frm"
   RENAME RTFSHO~1.LOG    "RTF ShowLog.log"
   RENAME UPDATE~1.FRM    "Update Log Example.Frm"
   RENAME UPDATE~1.FRX    "Update Log Example.frx"
   RENAME UPDATE~2.FRM    "Update Test.Frm"
   RENAME UPDATE~1.VBP    "Update log test.Vbp"

    Cd %2\"Sample Code"\"Multiple Interface Comparison"
   RENAME MULTIP~1.VBP    "Multiple Interface Comparison "
   RENAME MULTIP~1.FRM    "Multiple Interface Test.Frm"
   RENAME MULTIP~1.FRX    "Multiple Interface Test.frx"

    Cd %2\"Sample Code"\Pictures
   RENAME AMERIC~1.GIF    "AMERICAN CREAM DRAFT STALLION.GIF"
   RENAME ANGUSB~1.GIF    "ANGUS BULL.GIF"
   RENAME APPALO~1.GIF    "APPALOOSA STALLION.GIF"
   RENAME AMERIC~1.TXT    "American Cream Draft text.txt"
   RENAME ANGUST~1.TXT    "Angus text.txt"
   RENAME ANGUS1.GIF      Angus1.gif
   RENAME APPALO~1.TXT    "Appaloosa Text.txt"
   RENAME BERKSH~1.GIF    "BERKSHIRE PIG.GIF"
   RENAME BERKSH~1.TXT    "Berkshire Pig Text.txt"
   RENAME CHICKEN.GIF     CHICKEN.GIF"
   RENAME CHESTE~1.TXT    "Chester White text.txt"
   RENAME PSATEX~1.TXT    "PSA text.txt"
   RENAME SGIGHEN.GIF     SGIGHEN.GIF
   RENAME TEXASA~1.TXT    "Texas A&M text.txt"
   RENAME ANGUS1.BMP      angus1.bmp
   RENAME ANGUS2.BMP      angus2.bmp
   RENAME ANGUS3.BMP      angus3.bmp
   RENAME CHICK1.BMP      chick1.bmp
   RENAME COWCALF.GIF     cowcalf.gif
   RENAME HORSE1.BMP      horse1.bmp
   RENAME HORSE2.BMP      horse2.bmp
   RENAME PIG1.BMP        pig1.bmp
   RENAME PSACHIC.BMP     psachic.bmp
   RENAME PSALOGO2.GIF    psalogo2.gif
   RENAME TEXAS.BMP       texas.bmp

    Cd %2\"Sample Code"\"RDO Samples"
   RENAME CAPTUR~1        "Capture Identity"
   RENAME CURSOR~1        "Cursor Map"
   RENAME FORM1.FRM       Form1.frm
   RENAME MSSCCPRJ.SCC    MSSCCPRJ.SCC
   RENAME MULTIP~1        "Multiple Resultsets"
   RENAME RDCUPD~1.FRM    "RDC Update Test.Frm"
   RENAME RDCUPD~1.VBP    "RDC Update Test.Vbp"
   RENAME RDCUPD~1.FRX    "RDC Update Test.frx"
   RENAME RDOADD~1        "RDO AddDrop Login"
   RENAME RDOCAL~1        "RDO Call SP with Float"
   RENAME RDOCAL~2        "RDO Call Stored Procedure"
   RENAME RDOOUT~1        "RDO Output Parameter"
   RENAME RDOPRE~1        "RDO Prepared Statement"
   RENAME RDOVSD~1        "RDO vs DAO Test"
   RENAME RDOVSD~2        "RDO vs DAO vs VBSQL Test"
   RENAME SIMPLE~1        "Simple Join"
   RENAME TABLEO~1        "Table Object Test"
   RENAME UPDATE~1        "Update Tests"
   RENAME RDOPRE~2        "rdo Prepared Statement Insert"

    Cd %2\"Sample Code"\"RDO Samples"\"Capture Identity"
   RENAME CAPTUR~1.FRM    "Capture IDENTITY.Frm"
   RENAME CAPTUR~1.VBP    "Capture IDENTITY.Vbp"

    Cd %2\"Sample Code"\"RDO Samples"\"Cursor Map"
   RENAME CURSOR~1.VBP    "Cursor Map.Vbp"
   RENAME CURSOR~1.FRM    "Cursor Map.frm"
   RENAME CURSOR~1.FRX    "Cursor Map.frx"

    Cd %2\"Sample Code"\"RDO Samples"\"Multiple Resultsets"
   RENAME MULTIP~1.FRM    "Multiple Resultsets.Frm"
   RENAME MULTIP~1.VBP    "Multiple Resultsets.Vbp"

    Cd %2\"Sample Code"\"RDO Samples"\"RDO AddDrop Login"
   RENAME RDOADD~1.FRM    "RDO AddDropLogin Example.Frm"
   RENAME RDOADD~1.VBP    "rdo AddDrop Login Example.Vbp"

    Cd %2\"Sample Code"\"RDO Samples"\"RDO Call SP with Float"
   RENAME SPFLOA~1.FRM    "SP Float test.Frm"
   RENAME SPFLOA~1.VBP    "Sp float test.Vbp"

    Cd %2\"Sample Code"\"RDO Samples"\"RDO Call Stored Procedure"
   RENAME RDOCAL~1.FRM    "RDO Call SP.Frm"
   RENAME RDOCAL~1.VBP    "RDO Call SP.Vbp"

    Cd %2\"Sample Code"\"RDO Samples"\"RDO Output Parameter"
   RENAME RDOOUT~1.FRM    "RDO Output Parameter.Frm"
   RENAME RDOOUT~1.VBP    "RDO Output Parameters.Vbp"

    Cd %2\"Sample Code"\"RDO Samples"\"RDO Prepared Statement"
   RENAME RDOPRE~1.FRM    "rdoPrepared Statement 1.Frm"
   RENAME RDOPRE~1.VBP    "rdoPrepared Statement 1.Vbp"
   RENAME RDOPRE~2.FRM    "rdoPrepared Statement 2.Frm"
   RENAME RDOPRE~2.VBP    "rdoPrepared Statement 2.Vbp"

    Cd %2\"Sample Code"\"RDO Samples"\"RDO vs DAO Test"
   RENAME RDOVSD~1.VBP    "RDO vs DAO Test.Vbp"
   RENAME RDOVSD~1.FRM    "RDO vs DAO test.Frm"
   RENAME RDOVSD~1.FRX    "RDO vs DAO test.frx"

    Cd %2\"Sample Code"\"RDO Samples"\"RDO vs DAO vs VBSQL Test"
   RENAME RDOVSD~1.FRM    "RDO vs DAO vb VSQL test.Frm"
   RENAME RDOVSD~1.FRX    "RDO vs DAO vb VSQL test.frx"
   RENAME RDOVSD~1.VBP    "RDO vs DAO vs VBSQL Test.Vbp"

    Cd %2\"Sample Code"\"RDO Samples"\"Simple Join"
   RENAME FORM1.FRM       Form1.frm
   RENAME MSSCCPRJ.SCC    MSSCCPRJ.SCC
   RENAME SIMPLE~1.VBP    "Simple Join.vbp"

    Cd %2\"Sample Code"\"RDO Samples"\"Table Object Test"
   RENAME TABLEO~1.VBP    "Table Object test.Vbp"
   RENAME TABLEO~1.FRM    "Table object test.Frm"
   RENAME TABLEO~1.FRX    "Table object test.frx"
   RENAME TABLEO~1.LOG    "Table object test.log"

    Cd %2\"Sample Code"\"RDO Samples"\"Update Tests"
   RENAME UPDATE~1.VBP    "Update Tests.Vbp"
   RENAME UPDATE~1.EXE    "Update Tests.exe"
   RENAME UPDATE~1.FRM    "Update Tests.frm"
   RENAME UPDATE~1.FRX    "Update Tests.frx"

    Cd %2\"Sample Code"\"RDO Samples"\"rdo Prepared Statement Insert"
   RENAME RDOPRE~1.FRM    "RDO Prepared Statement Insert.Frm"
   RENAME RDOPRE~1.VBP    "RDO Prepared Statement Insert.Vbp"

    Cd %2\"Sample Code"\"SP Who Client-Server"
   RENAME CLASS1.CLS      Class1.cls
   RENAME OLESER~1.EXE    "OLE Server Show Who.exe"
   RENAME OLESER~1.VBP    "OLE Server Show Who.vbp"
   RENAME OLESVR~1.BAS    OLESvrMod1.bas
   RENAME OLEFORM1.FRM    OLEform1.frm
   RENAME OLEFORM1.FRX    OLEform1.frx
   RENAME README.TXT      Readme.txt
   RENAME SHOWWH~1.VBP    "ShowWho (client).Vbp"
   RENAME TESTSH~1.FRM    "TestShow Who Server.Frm"
   RENAME TESTSH~1.FRX    "TestShow Who Server.frx"

    Cd %2\"Sample Code"\"SQL Work"
   RENAME ALLVB4~1.SQL    "All VB4 Data Types.sql"
   RENAME LOGMES~1.FRM    "LogMessages sample.Frm"
   RENAME LOGMES~1.VBP    "LogMessages sample.Vbp"
   RENAME LOGMES~1.FRX    "LogMessages sample.frx"
   RENAME MAKENE~1.VBP    "Make new table example.Vbp"
   RENAME MAKENE~1.FRM    "MakeNewTable example.Frm"
   RENAME RETURN~1.VBP    "Return Status stored procedure.Vbp"
   RENAME RETURN~1.FRM    "Return status stored procedure.Frm"
   RENAME RETURN~1.FRX    "Return status stored procedure.frx"
   RENAME SQLLOG1.LOG     SQLLog1.log

    Cd %2\"Sample Code"\"Text files"
   RENAME ALLTYP~1.SQL    "AllTypes Script.sql"
   RENAME ERRORS~1.TXT    "Errors writing Stored Procedures.txt"
   RENAME STORED~1.TXT    "Stored Procedure using Output parameters.txt"
   RENAME TESTRE~1.TXT    "TestReturnStatus stored procedure.txt"

    Cd %2\"Sample Code"\VBSQL
   RENAME BASIC3~1        "Basic 32 bit app"
   RENAME OPENST~1        "Open Stress"
   RENAME SQLSER~1        SQLServerEnum
   RENAME TESTQU~1        "Test Query"
   RENAME VBSQLC~1        "VBSQL Cursor 32"
   RENAME VBSQL.BAS       vbsql.bas

    Cd %2\"Sample Code"\VBSQL\"Basic 32 bit app"
   RENAME BASICV~1.VBP    "Basic VBSQL.Vbp"
   RENAME BASICV~1.FRM    "Basic VBSQL.frm"
   RENAME BASICV~1.LOG    "Basic VBSQL.log"
   RENAME MSSCCPRJ.SCC    MSSCCPRJ.SCC

    Cd %2\"Sample Code"\VBSQL\"Open Stress"
   RENAME OPENST~1.FRM    "Open Stress test.Frm"
   RENAME OPENST~1.VBP    "Open Stress test.Vbp"

    Cd %2\"Sample Code"\VBSQL\SQLServerEnum
   RENAME SQLSER~1.VBP    "SQLServerEnum Sample.Vbp"
   RENAME SQLSER~1.FRM    "SQLServerEnum sample.frm"

    Cd %2\"Sample Code"\VBSQL\"Test Query"
   RENAME TESTQU~1.FRM    "Test Query.Frm"
   RENAME TESTQU~1.VBP    "Test Query.Vbp"

    Cd %2\"Sample Code"\VBSQL\"VBSQL Cursor 32"
   RENAME VBSQLC~1.FRM    "VBSQL Cursor 32.FRM"
   RENAME VBSQLC~1.VBP    "VBSQL Cursor 32.vbp"

    Cd %2\VBSQL
   RENAME 16BIT           16bit
   RENAME 32BIT           32Bit

    Cd %2\VBSQL\16bit
   RENAME SQL6~1.516      "SQL 6.5 16-Bit vbsql"
   RENAME TEXT.BAS        TEXT.BAS

    Cd %2\VBSQL\16bit\"SQL 6.5 16-Bit vbsql"
   RENAME _MSTEST.EXE     _mstest.exe
   RENAME ABOUT.FRM       about.frm
   RENAME ADBABOUT.FRM    adbabout.frm
   RENAME ADBABOUT.FRX    adbabout.frx
   RENAME ADBGLOB.BAS     adbglob.bas
   RENAME ADBLOGON.FRM    adblogon.frm
   RENAME ADBPUBS.MAK     adbpubs.mak
   RENAME ADBSQL.BAS      adbsql.bas
   RENAME AUTHORS.BAS     authors.bas
   RENAME AUTHORS.FRM     authors.frm
   RENAME AUTHORS.FRX     authors.frx
   RENAME BLOGIN.FRM      blogin.frm
   RENAME BROWSE.BAS      browse.bas
   RENAME BROWSE.FRM      browse.frm
   RENAME BROWSE.FRX      browse.frx
   RENAME BROWSE.ICO      browse.ico
   RENAME BROWSE.MAK      browse.mak
   RENAME BUILD.OUT       build.out
   RENAME CHNGDB.FRM      chngdb.frm
   RENAME CURSORS.BAS     cursors.bas
   RENAME CURSORS.FRM     cursors.frm
   RENAME CURSORS.FRX     cursors.frx
   RENAME CURSORS.ICO     cursors.ico
   RENAME CURSORS.MAK     cursors.mak
   RENAME DBNMP3.DLL      dbnmp3.dll
   RENAME GENGLOB.BAS     genglob.bas
   RENAME IMAGE.BAS       image.bas
   RENAME IMAGE.BMP       image.bmp
   RENAME IMAGE.FRM       image.frm
   RENAME IMAGE.FRX       image.frx
   RENAME IMAGE.ICO       image.ico
   RENAME IMAGE.MAK       image.mak
   RENAME INIEXITW.BAS    iniexitw.bas
   RENAME LOGIN.FRM       login.frm
   RENAME MDIMA.FRM       mdima.frm
   RENAME MDIMA.FRX       mdima.frx
   RENAME MSCOMSTF.DLL    mscomstf.dll
   RENAME MSCPYDIS.DLL    mscpydis.dll
   RENAME MSCPYDIS.INC    mscpydis.inc
   RENAME MSCUISTF.DLL    mscuistf.dll
   RENAME MSDBLIB3.DLL    msdblib3.dll
   RENAME MSDETECT.INC    msdetect.inc
   RENAME MSDETSTF.DLL    msdetstf.dll
   RENAME MSINSSTF.DLL    msinsstf.dll
   RENAME MSSHLSTF.DLL    msshlstf.dll
   RENAME MSUILSTF.DLL    msuilstf.dll
   RENAME PUBS1.HLP       pubs1.hlp
   RENAME QUERY.MAK       query.mak
   RENAME README.TXT      readme.txt
   RENAME RESULTSW.BAS    resultsw.bas
   RENAME RPC.BAS         rpc.bas
   RENAME RPC.FRM         rpc.frm
   RENAME RPC.MAK         rpc.mak
   RENAME RPCLOGIN.FRM    rpclogin.frm
   RENAME SETUP.EXE       setup.exe
   RENAME SETUP.INI       setup.ini
   RENAME SETUP.LST       setup.lst
   RENAME SETUPAPI.INC    setupapi.inc
   RENAME TEXT.BAS        text.bas
   RENAME TEXT.FRM        text.frm
   RENAME TEXT.FRX        text.frx
   RENAME TEXT.ICO        text.ico
   RENAME TEXT.MAK        text.mak
   RENAME VBCONST.BAS     vbconst.bas
   RENAME VBQUERY.BAS     vbquery.bas
   RENAME VBQUERY.FRM     vbquery.frm
   RENAME VBSQL.BI        vbsql.bi
   RENAME VBSQL.HLP       vbsql.hlp
   RENAME VBSQL.INF       vbsql.inf
   RENAME VBSQL.MST       vbsql.mst
   RENAME VBSQL.VBX       vbsql.vbx
   RENAME VBSQLGEN.BAS    vbsqlgen.bas
   RENAME VER.DLL         ver.dll
   RENAME W3DBLIB.DLL     w3dblib.dll

    Cd %2\VBSQL\32Bit
   RENAME INSTAL~1        "Install in Windows System Directory"
   RENAME README.WRI      readme.wri
   RENAME VBSQL.BAS       vbsql.bas

    Cd %2\VBSQL\32Bit\"Install in Windows System Directory"
   RENAME MSVCRT40.DLL    msvcrt40.dll
   RENAME NTWDBLIB.DLL    ntwdblib.dll
   RENAME VBSQL.OCX       vbsql.ocx

   @echo -------------------- END ERRROR LOG -------------------------
   @echo -
   @echo -
   @echo Renaming of short filenames to long filenames complete.
   @echo Browse around the %2 files or read the book for more
   @echo information regarding the files and their use.

   :END
   cd %2
   prompt %TEMP_PROMPT%
   @echo -
   @echo Exiting Namexpan utility.
   pause
   rem *** END OF NAMEXPAN.BAT


Additional query words: kbfile BookBug mspress ms press 4.00 6.5

======================================================================
Keywords          :  
Technology        : kbMSPressSearch kbVBSearch kbSQLServSearch kbAudDeveloper kbZNotKeyword6 kbSQLServ600 kbZNotKeyword2 kbVB400Search kbVB400 kbZNotKeyword3
Version           : :4.0,6.0

=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS
PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND.  MICROSOFT DISCLAIMS
ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES
OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.  IN NO
EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR
ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL,
CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF
MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE
POSSIBILITY OF SUCH DAMAGES.  SOME STATES DO NOT ALLOW THE EXCLUSION
OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES
SO THE FOREGOING LIMITATION MAY NOT APPLY.

Copyright Microsoft Corporation 2002.