Urgent: How Open a Firebird

[Silvio]

I must open a fdb archive and list the structure of each table
How I can make it ?

Can I have a small sample pls. ?

[Antonio Linares]

Silvio,

You may use ADO to open and manage it.

[Silvio]

on the same mode I open MDB access file ?
thanks I try now


to print each structure table
wich is the command ?

[Enrico Maria Giordano]

to print each structure table
wich is the command ?

Code: Select all  Expand view

FUNCTION MAIN()

    LOCAL oCat

    LOCAL i, j

    oCat = CREATEOBJECT( "ADOX.Catalog" )

    oCat:ActiveConnection = "Your connection string"

    FOR i = 0 TO oCat:Tables:Count() - 1
        ? oCat:Tables( i ):Name
        ?

        FOR j = 0 TO oCat:Tables( i ):Columns:Count() - 1
            ? SPACE( 4 ),;
              PADR( oCat:Tables( i ):Columns( j ):Name, 20 ),;
              STR( oCat:Tables( i ):Columns( j ):Type, 5 ),;
              STR( oCat:Tables( i ):Columns( j ):DefinedSize, 10 ),;
              STR( oCat:Tables( i ):Columns( j ):Precision, 5 )
        NEXT

        ?
    NEXT

    RETURN NIL

EMG

[Silvio]

thanks emg,

[Silvio]

It give me error


Application
===========
Path and name: C:\work\prg\firebird\test.Exe (32 bits)
Size: 1,311,744 bytes
Time from start: 0 hours 0 mins 0 secs
Error occurred at: 09/26/08, 17:42:11
Error description: Error ADOX.Catalog/16389 E_FAIL: _ACTIVECONNECTION
Args:
[ 1] = C Provider=Microsoft.Jet.OLEDB.4.0;Data Source=test.fdb;User Id=admin;Password=bpteramo;

Stack Calls
===========
Called from: win32ole.prg => TOLEAUTO:_ACTIVECONNECTION(0)
Called from: test.prg => MAIN(45)

[James Bott]

There is a sample Firebird connection string on this page:

http://www.connectionstrings.com/?carrier=firebird

Regards,
James

[Silvio]

i try with Driver=Firebird/InterBase(r) driver;Uid=SYSDBA;Pwd=masterkey;DbName=TEST.FDB;

but it make the same error

[James Bott]

You have to use your own user ID and password.

James

[wmormar]

I must open a fdb archive and list the structure of each table
How I can make it ?

Can I have a small sample pls. ?

Silvio,

you see the blog from Andres.

CODIGO-BASE

[Silvio]

I insert My admin and My password
Application
===========
Path and name: C:\work\prg\firebird\test.Exe (32 bits)
Size: 1,311,744 bytes
Time from start: 0 hours 0 mins 0 secs
Error occurred at: 09/27/08, 12:29:11
Error description: Error ADOX.Catalog/16389 E_FAIL: _ACTIVECONNECTION
Args:
[ 1] = C Driver=Firebird/InterBase(r) driver;Uid=Administrator;Pwd=bpteramo;DbName=test.fdb

Stack Calls
===========
Called from: win32ole.prg => TOLEAUTO:_ACTIVECONNECTION(0)
Called from: test.prg => MAIN(45)

System
======
CPU type: AMD Athlon(tm) 64 X2 Dual Core Processor 4400+ -19448 Mhz
Hardware memory: 2048 megs

Free System resources: 90 %
GDI resources: 90 %
User resources: 90 %

Compiler version: xHarbour build 0.99.71 Intl. (SimpLex)
Windows version: 5.1, Build 2600 Service Pack 2

Windows total applications running: 0

[Silvio]

Dear wmormar
I try also it
no run ok

[Enrico Maria Giordano]

Maybe you haven't installed Firebird drivers correctly or haven't installed them at all.

EMG

[Silvio]

NO

I have installed Firebird correctly VERSION 2.1

and the service run correctly as you can see here




the test of wnormar (Tfirebird) run correctly
I must to insert sample.gdb in c:\bases
But My archive is Fdb extension no gdb


Dear Emg ,
with your sample How I must make the connection for the test.fdb ?
thanks

[Enrico Maria Giordano]

NO

I have installed Firebird correctly VERSION 2.1

You have to install Firebird drivers for ODBC/ADO too.

EMG