Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Failed to launch 'osql'

Author  Topic  marco99 Starting Member 1 Post Posted - 2006-09-13 : 03:19:51 I use one-way Transactional Replication on 38 servers with same configuration. On one server I have problem with OSQL.EXE path. On Publication properties -> snapshot -> Additional scripts -> Before applying the snapshot, execute this script: Is set preinit script (C:\ReplData\ReplPreInit.sql). On Distribution agent properties -> step "Run Agent" I set additional command for log problem. command= -Output C:\ReplOutFile.txt -Outputverboselevel 2 Here is part of ReplOutFile.txt: -------------------------------- The osql command is: "C:\Program Files\Microsoft SQL Server\80\Tool\Binn\osql.exe" -U"***" -P"***" -i "\\STROSBB\ReplData\unc\STROSBB_antikor_DataCDB\20060908104051\ReplPreInit_0.sql" -S "BTSVR" -d "AntikorCDB" -o "C:\WINNT\TEMP\ReplPreInit_0.sql_20060912150416.log" -b -X1 Launching osql to apply the script 'ReplPreInit_0.sql' [9/12/2006 3:04:16 PM]STROSBB.distributionAntikor: {call sp_MSadd_distribution_history(1, 3, ?, ?, 0, 0, 0.00, 0x00, 1, ?, 0, 0x01, 0x00)} Agent message code 20130. Failed to launch 'osql' [9/12/2006 3:04:16 PM]STROSBB.distributionAntikor: {call sp_MSadd_distribution_history(1, 6, ?, ?, 0, 0, 0.00, 0x01, 1, ?, 4, 0x01, 0x01)} Adding alert to msdb..sysreplicationalerts: ErrorId = 1233, Transaction Seqno = 00000491000618f4007000000001, Command ID = 4 Message: Replication-Replication Distribution Subsystem: agent STROSBB-antikor-BTSVR-1 failed. Failed to launch 'osql'[9/12/2006 3:04:16 PM]STROSBB.distributionAntikor: {call sp_MSadd_repl_alert(3, 1, 1233, 14151, ?, 4, N'STROSBB', N'antikor', N'BTSVR', N'AntikorCDB', ?)} ErrorId = 1233, SourceTypeId = 3 ErrorCode = '3' ErrorText = 'The system cannot find the path specified. -------------------------------- Problem is that the path to osql command in log ReplOutFile.txt is C:\Program Files\Microsoft SQL Server\80\Tool\Binnbut SQL is installed on path C:\Program Files\Microsoft SQL Server\80\Tools\Binn Diferences is between Tool vs. Tools I think that when server create OSQL command for preinit sql script he use STATIC path to osql.exe and there is my problem. Where is this path stored and can I change it?