"c:\Program files\Firebird\bin\isql" -user SYSDBA -password masterke
-terminator ; -sqldialect 3 -charset ISO8859_1 -cache 1024 -input
C:\SalesLabourBudget\spBudgetInputForFreshRevision.sql

in spBudgetInputForFreshRevision.sql

don't forget to add at the beginning

CONNECT WINREDATA.FDB ;

also look if spBudgetInputForFreshRevision.sql is encoded in utf8 or in ansi
if in utf8 the 3 first char can be the bom that in the way can raise and
error

stephane

On 1/30/2012 3:09 PM, Mahesh Pratihari wrote:
>
> Hi All,
>
> Please guide me how to execute the batch script for a file, I have
> written in this way, could you let me know where is my fault, it showing
> error
>
> @echo off
>
> cls
>
> set SName=bg4ws0650
>
> set UName=sysdba
>
> set Pwd=masterke
>
> set DbName=D:\RiTEQFireBird\RELEASE2\TIMETEQ-FIREBIRD-TEST-RELEASE2.FDB
>
> @echo on
>
> CD C:\Program Files (x86)\Firebird\Firebird_2_5\bin
>
> rem echo Importing Table and Stored Procedure to Firebird Database
>
> rem echo Added on 05-01-2012 for Sales and Budget---------------------
>
> isql.exe -U %UName% -P %Pwd% -d %DbName% -S %SName% -i
> C:\SalesLabourBudget\spBudgetInputForFreshRevision.sql
>
> pause
>
> Thanks,
>
> Mahesh Pratihari
>
> Sonata Software Limited
>
> Phone : +91 80 3097 1527
>
> Mobile : +91 99808 37446
>
> www.sonata-software.com <http://www.sonata-software.com>
>
> Please don't print this email unless you really need to. This will
> preserve trees on our planet.
>
> [Non-text portions of this message have been removed]
>
>


[Non-text portions of this message have been removed]