Re: [Firebird-net-provider] I get error using FbScript and FbBatchExecution

[Jiri C. <di...@ci...>]

On 3/1/08, Mercea Paul <pau...@al...> wrote:
>
>
>
> Hi all
>
> Using VS2005, c#, FB1.5.4 and Fb.Net Provider 2.1!
>
>
>
> I try to execute from a sql file a procedure ddl using FbScript and
> FbBatchExecution, but I get errors in 2 situations!
>
>
>
> 1.Without FbTransaction:
>
> An exception was thrown when executing command: CREATE OR ALTER PROCEDURE
> REPORT_DATA (
>
>     TIPUNIT CHAR(1),…
>
> At the and I have:
>
> Batch execution aborted
>
> The returned message was: Dynamic SQL Error
>
> SQL error code = -817
>
> Metadata update statement is not allowed by the current database SQL dialect
> 1

Are you able to run the script via isql under same connection
(chraset, dialect, server, etc.)?

-- 
Jiri {x2} Cincura (CTO x2develop)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com