RE: [Firebird-odbc-devel] FW: [firebird-support] ODBC connection to Firebird (2.1.2.18118) database on Windows Server 2003 from Windows 7 x64

2012-01-11 Thread Michael Möhle
Installation Order for Windows 64 Bit – 32 Bit ODBC App: - Install Firebird Native Client 32 Bit by installing the Firebird Server on this System and choosing “Only Client Install” - Install Firebird ODBC Driver 32 Bit - Go to Control Panel. There must be a Button

Re: [firebird-support] Re: Copy Table in store procedure

2012-01-11 Thread Helen Borrie
At 08:24 PM 11/01/2012, you wrote: How can I Prepare a suite of scripts? Is there any example script? Create your own, using isql -extract server:dbalias /filepath myscript.sql -user sysdba -password dbapwd8 /filepath myscript.sql Then you can open myscript.sql in a good text editor, adding

Re: [firebird-support] A query about foreign keys

2012-01-11 Thread Milan Babuskov
Marco Aurelio Castro wrote: What is the query that I inform the name of the Foreign Key and it returns the names of the tables and fields related to this foreign key? You need to join system tables RDB$RELATION_CONSTRAINTS, RDB$INDICES and RDB$INDEX_SEGMENTS. Regards, -- Milan Babuskov

[firebird-support] Re: How can I get a list of firebird db users?

2012-01-11 Thread Ahmet Nuri D
I find one solition for that SELECT RDB$USER FROM RDB$USER_PRIVILEGES group by 1 --- In firebird-support@yahoogroups.com, Milan Babuskov milanb@... wrote: Ahmet Nuri D wrote: Hi, I want to list firebird user. can I do that? Start Firebird gsec tool with -display switch. Example on

Re: [firebird-support] Altering Numeric datatype to Numeric (15,5)

2012-01-11 Thread Helen Borrie
At 09:59 PM 11/01/2012, porapu wrote: Hi to one and All.In my working database some columns are created with Numeric datatype whose precision and scale is Numeric(15,2) where I want only 2 decimals.So if I am trying to Alter the scale of that column ie to Numeric(15,5) SQL is throwing the error