Subject Re: [firebird-php] Re: PHP Firebird Vista install problems
Author Helen Borrie
At 07:24 7/10/2008, you wrote:

>> On Mon, Oct 6, 2008 at 10:31 PM, dogrocket2003 <dogrocket2003@...>
>> > connected to Database: <none>
>> > InterBase Error:
>> > connection rejected by remote interface
>> Is your server listening on specified port? Firewall?
>Not sure what could have changed, interbase was working fine. Windows
>firewall is off, checked mcaffe firewall and it doesnt have any info
>about rejections as such.

Is InterBase still running? if so, then it has port 3050 and Firebird can't listen through it.

>Checked Apache error log, and had this
>Mon Oct 06 16:56:38 2008] [warn] (OS 64)The specified network name is
>no longer available. : winnt_accept: Asynchronous AcceptEx failed.

So DHCP has changed the IP address of your server...? Why not put an entry in ..\system32\drivers\etc\hosts to pin your host machine's network node name to a single IP address? Of course, this won't cure the problem if in fact you still have InterBase listening on port 3050.

>What am i supposed to do with the fbclient.dll and gds32.dll? am i
>supposed to replace gds32.dll in php directory or something?

It depends on whether the gds32.dll in your php directory belongs to InterBase or Firebird. What I would do is rename that file and put the renamed fbclient.dll in its place as gds32.dll.

>In addition the make fbclient.dll like old style gds32.dll selection
>during install, has me confused Also I looked in system32 and it didnt
>exist is it supposed to.

You can have the Firebird install generate a "gds32.dll" into the system32 directory. The main purpose of that is to cater for some brain-dead Delphi components that won't work unless a Borland-style version string is hard-wired. For other interfaces you can simply rename fbclient.dll if the driver is expecting gds32.dll. It is quite likely that you need the generated gds32.dll if you are trying to develop in a Codegear environment....someone else can confirm...but at worst it won't do any harm to give it a try. You can run the program instclient.exe (in your Firebird \bin directory) to generate it.

>also have this file in firebird directory "JAYS-PC.lcke", does this
>mean I cant use localhost as prefix to my host name now and I must use

On Vista your command-line stuff runs in a remote desktop client so localhost is unavailable. If JAYS-PC is your host machine's hostname then that's what you should be using for your connection string if you are using TCP/IP protocol.

Do you mean "JAYS-PC.lck"? if there is a file called "JAYS-PC.lcke" then it doesn't belong to Firebird. Anyway, it doesn't mean, per se, that you can't use TCP local loopback. It just means that the Firebird server knows the hostname of the machine it is running on. But it is your environment that is blocking TCP/IP local loopback.

>This installation should not be so ambiguous. We are not all experts
>at apache / firebird / php. Im not sure why something like a LAMPS
>installation or even codegear installation cant be developed.
>Firebird isn't endearing itself to me that's for sure!

Firebird is a relational database management system that is totally neutral to the client application environment. It gets down to individuals to set up such things that are specific to their own idiosyncratic environment and make them available for use by others. Rather than blag Firebird - which is not responsible for the misconfiguration of your network setup - you could do a favour to yourself and others coming afterwards by recording what eventually works for you in your environment and submitting it as a How-to to the firebird-docs project.

From your other postings I note that you are trying to use the Firebird 2.5 alpha 1 version. Why? an alpha is for testing by people who already know what they are doing - the idea being for field-testers to feed back to firebird-devel on features that seem to have failed or regressed. Use a *release version* and the associated documentation to help you get where you want to be.