Re: [firebird-support] Firebird 2.5 rejecting connections

2017-08-07 Thread 'CR' ch...@vp44.net [firebird-support]
On Mon, August 7, 2017 11:03 pm, 'livius' liviusliv...@poczta.onet.pl
[firebird-support] wrote:
> Hi,
> put fbclient.dll / and/or/ gds32.dll into your application folder.

That is standard practice, I do it at each installation.
I have found several mentions of conflicts with antivirus sw such as NIS
or NOD32. I will take a closer look at installed applications to see if
there's anything suspicious



Re: [firebird-support] Firebird 2.5 rejecting connections

2017-08-07 Thread 'livius' liviusliv...@poczta.onet.pl [firebird-support]
Hi,
put fbclient.dll / and/or/ gds32.dll into your application folder.
Remember that you need 32bit dll’s if your app is 32bit and 64bit dll if you 
have 64bit app (bitness of the server does not matter)
Check if you have not Interbase installed on you computer side (some apps can 
install it)
regards,
Karol Bieniaszewski 

RE: [firebird-support] Firebird 2.5 rejecting connections

2017-08-07 Thread 'CR' ch...@vp44.net [firebird-support]
>>>Can  you  connect locally by using TCP/IP(i.e.: using localhost or the
>>> server's own IP)?
>
> Just my 2c. We have also experienced this on a few PC's.
>
> A connection string of:
>
> localhost:c:\MyFolder\MyData.fdb
>
> gives the connection rejected error.
>
> Changing to:
>
> c:\MyFolder\MyData.fdb
>
> resolves the problem.
>

I believe this switches the connection protocol to XNET and not TCP/IP so
I don't think it would fix the issue should I need to connect from another
machine.

Here is an excerpt of the firebird log file when attempting a connection
with ibmanager:

XS001 (Client)  Mon Aug 07 15:58:12 2017
INET/inet_error: read errno = 10054

XS001   Mon Aug 07 15:58:12 2017
inet server err: setting KEEPALIVE socket option

XS001   Mon Aug 07 15:58:12 2017
inet server err: setting NODELAY socket option

XS001   Mon Aug 07 15:58:12 2017
INET/select_wait: found "not a socket" socket : 236

XS001   Mon Aug 07 15:58:12 2017
INET/inet_error: select in packet_receive errno = 10038

XS001   Mon Aug 07 15:58:12 2017
Unable to complete network request to host "XS001".
Error reading data from the connection.

This is the error returned:

Connection rejected by remote interface.
SQL code: -923
IB error #: 335544421


Thanks!



RE: [firebird-support] Firebird 2.5 rejecting connections

2017-08-07 Thread Maya Opperman m...@omniaccounts.co.za [firebird-support]
>>Can  you  connect locally by using TCP/IP(i.e.: using localhost or the 
>>server's own IP)?

Just my 2c. We have also experienced this on a few PC's. 

A connection string of:

localhost:c:\MyFolder\MyData.fdb 

gives the connection rejected error.

Changing to:

c:\MyFolder\MyData.fdb

resolves the problem.

We haven't managed to get to the bottom of it yet, we usually just end up using 
the local connection string, but it would be nice to finally know what's 
causing it instead of using the workaround. Unfortunately, once the workaround 
is in effect, we then don't end up with much time to scrutinise the person's PC 
to  find out what the problem was.