AW: [firebird-support] sql query in firebird

Hello Sean Thanks a lot! Unfortunately the gemini interbase odbc driver works not with this union query. Even not if I create 3 single queries and call this in a union query. Is there an easy way to put them into a stored procedure without duplicates? Then I can get the return values by cal

AW: [firebird-support] sql query in firebird

Hello again, now I have test it with a pass through query and it works! Thanks! Hello Sean Thanks a lot! Unfortunately the gemini interbase odbc driver works not with this union query. Even not if I create 3 single queries and call this in a union query. Is there an easy way to put th

Re: AW: [firebird-support] sql query in firebird

Hey there, i did not follow the beginning of this thread but this looks like a proper SQL query...and it should have nothing to do with the ODBC driver, because the driver just sends the query to the server and the server will run it. Could you please provide the error message you receive at r

[firebird-support] Forced Write turning off

We recently had database corruptions and had turned on forced write on our databases on windows environment but we found that after we run our client application gstat was no more showing the forced write status. We are using Delphi and IBO components but not sure what in the application is rese

Re: [firebird-support] Forced Write turning off

> We recently had database corruptions and had turned on forced write on our > databases on windows environment but we found that after we run our client > application gstat was no more showing the forced write status. We are using > Delphi and IBO components but not sure what in the application

[firebird-support] Inconsistency issue in FB 1.56

I backed up a (FB 1.56) database on my server and am trying to restore it on my local machine. I get the following error message in IB Expert: Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements. action cancelled by trigger (

[firebird-support] How to migrate to new database Server?

I have a Delphi web Server application using Firebird 1.5 as backend database. I am thinking about updating to new server. Few questions: 1. Could I install Firebird2 64 bits on a database server and access to the database from 32 bits web application on another machine? 2. What is the process

[firebird-support] connection rejected after first installation on Mac OS 10.7.5

I installed FirebirdSS-2.5.2-26539-lipo-x86_64.pkg.zip I unzipped the package and double clicked on the icon and successfully installed the program. Howeve

Re: [firebird-support] How to migrate to new database Server?

> 1. Could I install Firebird2 64 bits on a database server and access to > the database from 32 bits web application on another machine? Yes. > 2. What is the process to convert Firebird 1.5 database to Firebird 2 > database? Make a backup on the old (FB1.5) server. Uninstall the old server. I

RE: [firebird-support] Inconsistency issue in FB 1.56

Look at the system tables. Don't know if it works on Fb 1.5, but I'd try something like select * from rdb$user_privileges u where u.rdb$field_name is not null and not exists(select * from rdb$relation_fields rf where u.rdb$relation_name = rf.rdb$relation_name