help with firebird embedde!

[firesz]

hi guys, I have problems when trying to execute a stored procedure in an embedded database - the same in a common database I have no errors - the error is coming -204 procedure unknown store_procedure. error code -204 undefined name; the sql: execute procedure store_procedure; please help!

[seawolf]

Hi, the message seems to tell you the procedure you are calling does not exists .. so I suggest you check the name, because probably are different

[firesz]

not the name is well recently check it, and probe with others too but nothing, I think of must be something about grants, but I'm using the sysdba user, so it can not be, any answer is appreciated! - I'm using zstoredproc so just to run, I'm not using zquery. but the iqual code in firebird server run ok.

[seawolf]

First of all FB embedded is a single user db, so grant is not supported.

Just two question:
1. Are you sure you are working with the correct DB? I mean if you work with different copies of the db, it could be possible you are working with a
DB which is not the one you are using in production.

2. Have you recently switched to FB 1.x to FB 2.x? Because it looks like a
problem related to a conversion

[firesz]

first of all thanks seawolf for your good answers, look I'm using 2.1 does not use 1.5 but I think there just gave your answer because I'm using the database in assdows as I am a bit lazy use firebird maestro to manage and do not use flamerobin because it would have to put a couple of libraries i use the maestro so this should be used by 1.5 libraries there should be what the problem looked at him and notice if that was the problem but it sure is. the database is the same I use to manage no mistake about it! - thanks!

[mdaems]

Please give the svn trunk or Testing branch version a try. In a few minutes I'll upload the current Trunk version on http://zeosdownloads.firmos.at/downloads/snapshots/

andrevanzuydam did some important firebird patches recently.

Mark

[firesz]

thank you all for your help!

the problem was the version of Zeos, renewed and it worked fine!