Thank you both for your comments. Both posts helped contribute to my understanding.
Please review my revised code (including registry values from another post on registry keys)
Code:
$sourceDir = 'V:\hotfixes\CAD to RMS fix files\'
$destDir1 = 'C:\Program Files\Common Files\Borland Shared\BDE\'
$destDir2 = '%windir%\system32\'
$checkFile = 'DONOTDELETE-CADFix1.txt'
$sourceFiles1 = 'sql_mss','sqllnk32.cnt','sqllnk32.fts','sqllnk32.hlp','SQLLNK32.TOC','sqlmss32.dll'
$sourceFiles2 = 'ntwdblib.dll'
$Key1 = "HKLM\SOFTWARE\Borland\Database Engine\Settings\DRIVERS\MSSQL"
IF left(@wksta,2) = "PD"
$Result = EXIST($destdir2 + $checkFile)
IF $Result = 0
for each $File1 in $sourceFiles1
copy $sourceDir + $File1 $destDir1 + $File1
next
copy $sourceDir + $sourceFiles2 $destDir2 + $sourceFiles2
copy $sourceDir + $checkFile $destDir2 + $checkFile
$rc = WriteValue ($key1 + "\DB OPEN","DATABASE NAME","","REG_SZ")
$rc = WriteValue ($key1 + "\DB OPEN","SERVER NAME","MSS_SERVER","REG_SZ")
$rc = WriteValue ($key1 + "\DB OPEN","USER NAME","MYNAME","REG_SZ")
$rc = WriteValue ($key1 + "\DB OPEN","OPEN MODE","READ/WRITE","REG_SZ")
$rc = WriteValue ($key1 + "\DB OPEN","SCHEMA CACHE SIZE","8","REG_SZ")
$rc = WriteValue ($key1 + "\DB OPEN","BLOB EDIT LOGGING","","REG_SZ")
$rc = WriteValue ($key1 + "\DB OPEN","LANGDRIVER","","REG_SZ")
$rc = WriteValue ($key1 + "\DB OPEN","SQLQRYMODE","","REG_SZ")
$rc = WriteValue ($key1 + "\DB OPEN","SQLPASSTHRU MODE","SHARED AUTOCOMMIT","REG_SZ")
$rc = WriteValue ($key1 + "\DB OPEN","DATE MODE","0","REG_SZ")
$rc = WriteValue ($key1 + "\DB OPEN","SCHEMA CACHE TIME","-1","REG_SZ")
$rc = WriteValue ($key1 + "\DB OPEN","MAX QUERY TIME","300","REG_SZ")
$rc = WriteValue ($key1 + "\DB OPEN","MAX ROWS","-1","REG_SZ")
$rc = WriteValue ($key1 + "\DB OPEN","BATCH COUNT","200","REG_SZ")
$rc = WriteValue ($key1 + "\DB OPEN","ENABLE SCHEMA CACHE","FALSE","REG_SZ")
$rc = WriteValue ($key1 + "\DB OPEN","SCHEMA CACHE DIR","","REG_SZ")
$rc = WriteValue ($key1 + "\DB OPEN","HOST NAME","","REG_SZ")
$rc = WriteValue ($key1 + "\DB OPEN","APPLICATION NAME","","REG_SZ")
$rc = WriteValue ($key1 + "\DB OPEN","NATIONAL LANG NAME","","REG_SZ")
$rc = WriteValue ($key1 + "\DB OPEN","ENABLE BCD","FALSE","REG_SZ")
$rc = WriteValue ($key1 + "\DB OPEN","TDS PACKET SIZE","4096","REG_SZ")
$rc = WriteValue ($key1 + "\DB OPEN","BLOB TO CACHE","64","REG_SZ")
$rc = WriteValue ($key1 + "\DB OPEN","BLOB SIZE","32","REG_SZ")
$rc = WriteValue ($key1 + "\INIT","VERSION","4.0","REG_SZ")
$rc = WriteValue ($key1 + "\INIT","TYPE","SERVER","REG_SZ")
$rc = WriteValue ($key1 + "\INIT","DLL32","SQLMSS32.DLL","REG_SZ")
$rc = WriteValue ($key1 + "\INIT","VENDOR","INIT","REG_SZ")
$rc = WriteValue ($key1 + "\INIT","CONNECT TIMEOUT","60","REG_SZ")
$rc = WriteValue ($key1 + "\INIT","TIMEOUT","300","REG_SZ")
$rc = WriteValue ($key1 + "\INIT","DRIVER FLAGS","","REG_SZ")
$rc = WriteValue ($key1 + "\INIT","TRACE MODE","0","REG_SZ")
$rc = WriteValue ($key1 + "\INIT","MAX DBPROCESSES","31","REG_SZ")
ENDIF
ENDIF