"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]
