[DUG] Firebird 1.5 - unavailable database

[John Davys]

Sounds like a firewall is blocking the port... 

-----Original Message-----
From: delphi-bounces at delphi.org.nz [mailto:delphi-bounces at delphi.org.nz] On
Behalf Of Steve Peacocke
Sent: Friday, 22 June 2007 4:09 p.m.
To: NZ Borland Developers Group - Delphi List
Subject: Re: [DUG] Firebird 1.5 - unavailable database

Thanks Tracey and everyone,

I still have not been able to connect.

I'm using D2007 and when connecting through TIBDatabase, the connection
shows...

Remote
Protocol: TCP
Server: <192.xxx.x.xxx>
Database: C:\Program Files\Firebird\DB\<databasename>.FDB

Username and password are the standard ones. (Items in <> have been replaces
with exact names.)

Interestingly, when I press the "Test" button on the "Database Component
Editor" (on the TIBDatabase), the systems goes away for some time, but
eventually comes back with
    Unable to complete network request to host "192.xxx.x.xxx:3050".
    Failed to establish a connection.
    unknown Win32 error 10061.

I have tried with 192.xxx.x.xxx:3050:C:\Program
Files\Firebird\DB\<filename>.fdb and various other cokmbinatio0ns, so far
without success.

Steve

On 22/06/07, AlanRose <alanrose at pocketnz.co.nz> wrote:
> Hi Steve
> First off I'd be using version 2 given its available and I find it's 
> very reliable. Second if you are using Vista then you must use a 
> TCP/IP connection like Tracy mentioned. E.g. 
> 127.0.0.1:c:\mydir\mydb.fdb If it's on a different machine try adding 
> the servers ip address and that you have read/write access rights
>
>
>
> -----Original Message-----
> From: delphi-bounces at delphi.org.nz 
> [mailto:delphi-bounces at delphi.org.nz]
> On Behalf Of Steve Peacocke
> Sent: Friday, 22 June 2007 3:06 p.m.
> To: NZ Borland Developers Group - Delphi List
> Subject: Re: [DUG] Firebird 1.5 - unavailable database
>
> Thanks Tracey,
>
> LocalHost will owrk while I have the database on my machine, however I 
> now want to move the database to the server and it won't work - yet.
>
> Steve
>
> On 22/06/07, Tracey <tracey at logis.co.nz> wrote:
> > And have u tried IBAdmin?
> >
> > Don't forget when using TIBDatabase to manually add "localhost:" b4
> the Db
> > path :)
> >
> >
> >
> > -----Original Message-----
> > From: delphi-bounces at delphi.org.nz
> [mailto:delphi-bounces at delphi.org.nz] On
> > Behalf Of Steve Peacocke
> > Sent: Friday, 22 June 2007 2:25 p.m.
> > To: NZ Borland Developers Group - Delphi List
> > Subject: Re: [DUG] Firebird 1.5 - unavailable database
> >
> > Further,
> >
> > TIBDatabase can't open it - it gives (you guessed it) "unavailable 
> > database".
> >
> > I'm just about ready to go to MySQL at this stage - after 2 whole 
> > days of struggling with this type of error, its not good for the 
> > sunny disposition.
> >
> > Steve
> >
> > On 22/06/07, Steve Peacocke <steve.peacocke at gmail.com> wrote:
> > > Thanks Todd,
> > >
> > > Interestingly, FlameRobin opens it up and shows me its all fine.
> > > Everything there, allows me to add to it if needed etc.
> > >
> > > However, neither "InterBase/Firebird Development Studio" nor 
> > > "DeZign for databases v4" come up with anything but "unavailable
database"
> > >
> > > Database Workbench now sees it as a valid database and exposes all 
> > > tables, domains and generators etc. However, prior to using 
> > > FlameRobin, it also came up with "unavailable database".
> > >
> > > Thanks again
> > >
> > > Steve
> > >
> > > On 22/06/07, Todd Martin <toddm at kol.co.nz> wrote:
> > > > Hi Steve
> > > >
> > > > Download FlameRobin (www.flamerobin.org) and use that to
> setup/test your
> > > > database connections.
> > > >
> > > > Todd.
> > > >
> > > > Steve Peacocke wrote:
> > > > > Gidday all,
> > > > >
> > > > > I've successfully created my database on my local drive. After
> hours
> > > > > and hours of real frustration, I am in need of assistance on
> this.
> > > > > Normally this would be easily done as I have done this before 
> > > > > on
> other
> > > > > computers.
> > > > >
> > > > > Whenever I try to attach to my newly created database (created
> with
> > > > > ISQL), I get the error "Unavailable database".
> > > > >
> > > > > Looking throuigh Google, I find a number of references to
> gds32.dll
> > > > > and have definately got that available (as well as 
> > > > > FBCLIENT.DLL)
> in
> > > > > the C:\WINDOWS\system32 directrory.
> > > > >
> > > > > In my frustrations, I have....
> > > > >
> > > > > * Completely removed both Firebird and Interbase from my
> computer and
> > > > > ensured neither was running a service.
> > > > >
> > > > > * Downloaded and installed Firebird 1.5.4 onto my local 
> > > > > computer (ensuring that "copy to system directory" was ticked 
> > > > > - copying
> those
> > > > > dll's to the system32 directory)
> > > > >
> > > > > I have attempted, through InterBase/Firebird Development
> Studio's
> > > > > (sqlly) Administration Console, to register the database using
> the
> > > > > local server - "unavailable database".
> > > > >
> > > > > I have attempted, through the same tool using the 
> > > > > Administration Console, to register the Local Server using 
> > > > > either of gds32.dll
> or
> > > > > fbclient.dll with the result of "unavailable database?
> > > > >
> > > > > Any help to get rid of this "unavailable database" would by 
> > > > > much appreciated at present.
> > > > >
> > > > > Steve
> > > > >
> > > >
> > > > _______________________________________________
> > > > NZ Borland Developers Group - Delphi mailing list
> > > > Post: delphi at delphi.org.nz
> > > > Admin: http://delphi.org.nz/mailman/listinfo/delphi
> > > > Unsubscribe: send an email to delphi-request at delphi.org.nz with
> Subject:
> > unsubscribe
> > > >
> > > >
> > >
> > >
> > > --
> > > Steve Peacocke
> > > http://stevepeacocke.blogspot.com/
> > >
> >
> >
> > --
> > Steve Peacocke
> > http://stevepeacocke.blogspot.com/
> > _______________________________________________
> > NZ Borland Developers Group - Delphi mailing list
> > Post: delphi at delphi.org.nz
> > Admin: http://delphi.org.nz/mailman/listinfo/delphi
> > Unsubscribe: send an email to delphi-request at delphi.org.nz with
> Subject:
> > unsubscribe
> >
> >
> > _______________________________________________
> > NZ Borland Developers Group - Delphi mailing list
> > Post: delphi at delphi.org.nz
> > Admin: http://delphi.org.nz/mailman/listinfo/delphi
> > Unsubscribe: send an email to delphi-request at delphi.org.nz with
> Subject: unsubscribe
> >
>
>
> --
> Steve Peacocke
> http://stevepeacocke.blogspot.com/
> _______________________________________________
> NZ Borland Developers Group - Delphi mailing list
> Post: delphi at delphi.org.nz
> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> Unsubscribe: send an email to delphi-request at delphi.org.nz with Subject:
> unsubscribe
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.472 / Virus Database: 269.9.4/860 - Release Date: 
> 6/21/2007
> 5:53 p.m.
>
>
> _______________________________________________
> NZ Borland Developers Group - Delphi mailing list
> Post: delphi at delphi.org.nz
> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> Unsubscribe: send an email to delphi-request at delphi.org.nz with 
> Subject: unsubscribe
>


--
Steve Peacocke
http://stevepeacocke.blogspot.com/
_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: delphi at delphi.org.nz
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to delphi-request at delphi.org.nz with Subject:
unsubscribe