| Subject | Re: [firebird-support] Cannot connect to database. |
|---|---|
| Author | Helen Borrie |
| Post date | 2009-08-12T23:57:21Z |
At 08:50 AM 13/08/2009, you wrote:
Firebird is a database management system for managing ("serving") *Firebird* databases that are physically located on the same host computer as Firebird. Client applications access databases by passing a network request. The "unavailable database" error occurs when a client passes a request to a server that is not running.
The Firebird server comes in several flavours. As a full server, it listens on a network for requests from client applications.
Firebird has an "embedded" flavour which can be deployed with an associated application. The application itself loads the embedded Firebird server and has exclusive access to the database. Since you report that you were able to connect locally by running your application, it seems most likely that your software uses this embedded model. If that is the case, then you are using software designed for local, stand-alone use and it won't be possible to connect to the database remotely.
Try to find out what you have there, i.e., whether your software installed a full server (fbserver.exe or fb_inet_server.exe, usually in c:\Program Files\Firebird...) or whether it uses embedded. The DLL for the Fb embedded server would be in the same directory as the application executable. Likely names for it would be fbclient.dll, fbembed.dll or gds32.dll and its size would be around 2 MB.
./heLen
>The error message says:Your terminology seems a bit mixed up and it's not likely we can help you until you help us to understand what you are working with there.
>
>Cannot connect to database.
>
>Unknown Username or Password
>unavailable database
>Alias: DB_CSAI
>
>Here's what I'm doing, I installed a program on the server (CASA, its a program for import/export) that uses Firebird as the database manager.
>
>Now when I physically log into the server as an Admin or as any user, I can use the CASA program just fine with no problems (I placed a shortcut in the desktop for all users).
>
>The error message comes out when I try to use the program via a remote desktop connection. I suspect I have to create a new username/pass in firebird? Or maybe this is a terminal services licencing issue?
>
>Any info would be great, this problem is really killing me.
>
>The server is running on Windows Server 2003 R2 standard SP1.
Firebird is a database management system for managing ("serving") *Firebird* databases that are physically located on the same host computer as Firebird. Client applications access databases by passing a network request. The "unavailable database" error occurs when a client passes a request to a server that is not running.
The Firebird server comes in several flavours. As a full server, it listens on a network for requests from client applications.
Firebird has an "embedded" flavour which can be deployed with an associated application. The application itself loads the embedded Firebird server and has exclusive access to the database. Since you report that you were able to connect locally by running your application, it seems most likely that your software uses this embedded model. If that is the case, then you are using software designed for local, stand-alone use and it won't be possible to connect to the database remotely.
Try to find out what you have there, i.e., whether your software installed a full server (fbserver.exe or fb_inet_server.exe, usually in c:\Program Files\Firebird...) or whether it uses embedded. The DLL for the Fb embedded server would be in the same directory as the application executable. Likely names for it would be fbclient.dll, fbembed.dll or gds32.dll and its size would be around 2 MB.
./heLen