RE: [firebird-support] Error -902 after Update Windows 10

['Primoz Jenko' primoz.je...@domplan.si [firebird-support]]

Hi!


Thank you for your message!

We were using TCP/IP. We will check all details you wrote in your message.
Thank you very much!

Best regards,
Primoz


From: firebird-support@yahoogroups.com 
[mailto:firebird-supp...@yahoogroups..com]
Sent: Thursday, May 24, 2018 10:32 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Error -902 after Update Windows 10



On 2018-05-24 07:37, 'Primoz Jenko' 
primoz.je...@domplan.si
[firebird-support] wrote:
> Hi!
>
> We have exact same problem. Author of some previous posts here in this
> group (THANK YOU AGAIN!) gave us the asnwer how to solve the problem.

The problem I have with this solution, is that when using a Firebird
database, you shouldn't be accessing a Firebird dstabase through a
share, and Firebird should disallow that by default. So I wonder if the
problem is not related to the connection protocol used.

In other words: did you really access a Firebird database through a
share? Or where you using the WNET (NetBEUI) protocol to connect to
Firebird?

Because if that is the actual problem, the solution should be much
simpler: use a TCP/IP connection string instead. That avoids the need to
turn on SMB (which is a potential security issue), or having to do a
forced upgrade of your OS.

Mark



To elektronsko sporo?ilo in vse morebitne priloge predstavljajo poslovno 
skrivnost oziroma so zaupne in so namenjene izklju?no naslovniku. Kakr?nokoli 
razkrivanje, distribucija ali kopiranje vsebine sporo?ila je izrecno 
prepovedano. ?e ste sporo?ilo prejeli pomotoma, Vas prosimo, da o tem obvestite 
po?iljatelja, sporo?ilo pa takoj uni?ite.

RE: [firebird-support] Error -902 after Update Windows 10

['Primoz Jenko' primoz.je...@domplan.si [firebird-support]]

Hi!




We have exact same problem. Author of some previous posts here in this group 
(THANK YOU AGAIN!)  gave us the asnwer how to solve the problem.
Problem is with update WIN 10, uptd 1803.


https://blog.mertech.com/windows-10-version-1803-breaks-some-shared-folder-applications


The Version 1803 issue in detail
It appears that Microsoft has introduced a bug or security feature that 
prevents applications started from SMB v1.x network shares from making network 
connections. This means that applications started from these environments can’t 
open a connection to a database server. In fact, they can’t perform any other 
types of network calls either.

This problem most commonly occurs when Windows 10 clients access a custom 
application from a mapped drive on Windows Server 2003. Unfortunately, there 
doesn’t appear to be a way to upgrade Windows Server 2003 to use a newer 
version of the SMB protocol. The only workaround in this environment is to copy 
the application executable to a local disk and run it from there.


---
We choose to update our Server 2003 to get newer protocol and for time beeing 
we copy each of .exe to local machine. It all is described in article above 
(link).



Best regards,
Primoz



From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Wednesday, May 23, 2018 7:24 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Error -902 after Update Windows 10



Hi

Since few days ago, after Windows 10 update, some applications writes in Delphi 
can not connect to network  Firebird 2.5.5 server.
These applications can connect with BDE, InterBase, FIB, FireDac... but all are 
using the GDS32.dll

In other side, applications as FlameRobin, are using the same library GDS32.dll 
and connects successfully.
Clients with previous Windows versions works fine too.

These are the errors messages:
Interbase:

22/05/2018 17:48:03  DBUG:  ; ¬[Application: ]¬[Error] -902 335544721 Unable to 
complete network request to host "192.168.1.100".¬Failed to establish a 
connection



BDE:

OpenConfigDatabase DbConnection Exception. Error Opening Configured Database 
$AUTO_DATA, Error was: Unknown database.
Unable to complete network request to host "192.168.1.100".
Failed to establish a connection.


The problem is a kind of local issue, because other Pc-clients works fine. But 
certainly is the gds32.dll that cannot connect with server and I not known why.

Some help please?
Tank you.

a Reveure,
--
Eduard Calveras
IT System Engineer





--
This message has been scanned for viruses and dangerous content by
E.F.A. Project, and is believed to be clean.
Click here to report this message as 
spam.


To elektronsko sporočilo in vse morebitne priloge predstavljajo poslovno 
skrivnost oziroma so zaupne in so namenjene izključno naslovniku. Kakršnokoli 
razkrivanje, distribucija ali kopiranje vsebine sporočila je izrecno 
prepovedano. Če ste sporočilo prejeli pomotoma, Vas prosimo, da o tem obvestite 
pošiljatelja, sporočilo pa takoj uničite.

RE: [firebird-support] FB3 alter domain colltion

['Primoz Jenko' primoz.je...@domplan.si [firebird-support]]

Hi,


we have 2.05, tough. So I am not sure for 3.x. Sorry.
Well, if you install IBExpert or some similar tool, you would be able to see 
immediately.

Best regards,
Primoz



From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Thursday, May 17, 2018 5:58 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] FB3 alter domain colltion


Hi,

>>There is no way to change the default collation without dropping the domain 
>>and recreating it with the desired attributes.
>>Perhaps tool like IBExpert could do this – alter and set collation? Not sure.

this was for FB2.5 where users could modify system tables but now in FB3 it is 
prohibited
and i suppose it is fixed by some DDL statement?

regards,
Karol Bieniaszewski




To elektronsko sporočilo in vse morebitne priloge predstavljajo poslovno 
skrivnost oziroma so zaupne in so namenjene izključno naslovniku. Kakršnokoli 
razkrivanje, distribucija ali kopiranje vsebine sporočila je izrecno 
prepovedano. Če ste sporočilo prejeli pomotoma, Vas prosimo, da o tem obvestite 
pošiljatelja, sporočilo pa takoj uničite.

RE: [firebird-support] Firebird and Windows 10 update

['Primoz Jenko' primoz.je...@domplan.si [firebird-support]]

Hi to all!

We have 100% similar problem. And link to a blog (solution describe there) is 
our solution too!
Thank you very much to all!

We hope we will be able to provide some answer as well on some other problem.


Best wishes!

Primoz



From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Wednesday, May 16, 2018 1:58 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Firebird and Windows 10 update



Hi all,

Could this be related to:
https://blog.mertech.com/windows-10-version-1803-breaks-some-shared-folder-applications

"This means that applications started from these environments can’t open a
connection to a database server."

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

On 15-5-2018 23:50, fo...@darsys.com.ar 
[firebird-support] wrote:
> Since few hours ago, in some customers after Windows 10 update, my app
> can not connect to server.
>
> Fb server works, and clients with previous Windows versions work.
>
>
> Error; 8004 - Unable to complete server request to host...
>
>
> Fb 2.5.6 .7 .8
>
> Tried with odbc 2.02, 2.03 2.05



To elektronsko sporočilo in vse morebitne priloge predstavljajo poslovno 
skrivnost oziroma so zaupne in so namenjene izključno naslovniku. Kakršnokoli 
razkrivanje, distribucija ali kopiranje vsebine sporočila je izrecno 
prepovedano. Če ste sporočilo prejeli pomotoma, Vas prosimo, da o tem obvestite 
pošiljatelja, sporočilo pa takoj uničite.

RE: [firebird-support] Subscribe and question

['Primoz Jenko' primoz.je...@domplan.si [firebird-support]]

Hello, Karol,

thank you very much for your respond!


Firebird is installed on different machine with WIN Server OS, only on local 
machine (client) there is WIN 10, with no FB istalled. On local machine there  
is only our software that uses FB from server.
We can not acces it even with IBConsole, …

Other local machines with like WIN 7 are operating normally, connecting normaly 
to this server.

Best wishes,
Primoz




From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Thursday, May 10, 2018 12:34 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Subscribe and question


Ar you sure that your answers are true?
You say that win10 is only a clien and then that when you restore to update 
1709 you see that fb is listen. I suppose you have Firebird installed on this 
Win10 machine and it serve client and server in the same time. Is this true or 
your config os different?



Regards,
Karol Bieniaszewski


--
This message has been scanned for viruses and dangerous content by
E.F.A. Project, and is believed to be clean.
Click here to report this message as 
spam.


To elektronsko sporočilo in vse morebitne priloge predstavljajo poslovno 
skrivnost oziroma so zaupne in so namenjene izključno naslovniku. Kakršnokoli 
razkrivanje, distribucija ali kopiranje vsebine sporočila je izrecno 
prepovedano. Če ste sporočilo prejeli pomotoma, Vas prosimo, da o tem obvestite 
pošiljatelja, sporočilo pa takoj uničite.

RE: [firebird-support] Subscribe and question

['Primoz Jenko' primoz.je...@domplan.si [firebird-support]]

Hi,


thank you! We will do it.



Best wishes,

Primoz


-Original Message-
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Thursday, May 10, 2018 12:17 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Subscribe and question

10.05.2018 12:12, 'Primoz  Jenko' primoz.je...@domplan.si [firebird-support] 
wrote:
> Does any one have any idea what to do?

   Look to firebird.log to see errors of port listening if any.


--
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item on the main 
(top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++


Yahoo Groups Links




To elektronsko sporočilo in vse morebitne priloge predstavljajo poslovno 
skrivnost oziroma so zaupne in so namenjene izključno naslovniku. Kakršnokoli 
razkrivanje, distribucija ali kopiranje vsebine sporočila je izrecno 
prepovedano. Če ste sporočilo prejeli pomotoma, Vas prosimo, da o tem obvestite 
pošiljatelja, sporočilo pa takoj uničite.

RE: [firebird-support] Subscribe and question

['Primoz Jenko' primoz.je...@domplan.si [firebird-support]]

Hi, Mark,

thank you very much for detailed questions!

Answers are:


-  WIN 10 is only on client

-  We have tried both: embeded and locall – nothing was working

-  FB runs as service

-  We wil try to run it as application

-  FB process is working, we have verify it – we see it running

-  With command netstat we do not see 3050 port in a list,

When we restore WIN to a 1709, port is visible again

We add port 3050 into firewall but it is not visible in a list (problem might 
be with port 3050 and firewall configuration?)
WIN does not listen to port 3050 data through, even it is 
configured in firewall





Does any one have any idea what to do?



Thank you so much!





Best wishes,

Primoz






From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Thursday, May 10, 2018 9:34 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Subscribe and question



On 9-5-2018 16:48, 'Primoz Jenko' 
primoz.je...@domplan.si
[firebird-support] wrote:
> I would have a question why, after automatic upate of WIN 10, update
> package 1803,FB  2.0.5.13206 (our software using those two) generates an
> error 335544721, Failed to established a connection?
>
> We have tried a lot of posibilities, but no effect.
>
> We have upgrade to FB 3.0.3 and problem remains.
>
> We have been seeking solutions on WIN 10 part too (off IVP6, unblocked
> 3050 port, unblocked FB), but no effect.
>
> Any thoughts?

What is the full error

Exactly what is your setup: Is Windows 10 used to host the Firebird
server, or is Windows 10 used on the client machines (or both)? Are you
using Firebird Embedded, connecting locally, or over the network. Is
Firebird running as a service, if so under what user? What happens if
you run it as an application (firebird -a from the command prompt with
Firebird 3).

Have you verified the Firebird process is actually running, and is
listening on port 3050 (eg check in command prompt with netstat -ano).
Have you verified the Windows 10 firewall settings?

Did you also update the Firebird client install on the client machines?

Mark
--
Mark Rotteveel



To elektronsko sporočilo in vse morebitne priloge predstavljajo poslovno 
skrivnost oziroma so zaupne in so namenjene izključno naslovniku. Kakršnokoli 
razkrivanje, distribucija ali kopiranje vsebine sporočila je izrecno 
prepovedano. Če ste sporočilo prejeli pomotoma, Vas prosimo, da o tem obvestite 
pošiljatelja, sporočilo pa takoj uničite.

[firebird-support] Subscribe and question

['Primoz Jenko' primoz.je...@domplan.si [firebird-support]]

Hello,

I would have a question why, after automatic upate of WIN 10, update package 
1803,FB  2.0.5.13206 (our software using those two) generates an error 
335544721, Failed to established a connection?
We have tried a lot of posibilities, but no effect.
We have upgrade to FB 3.0.3 and problem remains.
We have been seeking solutions on WIN 10 part too (off IVP6, unblocked 3050 
port, unblocked FB), but no effect.

Any thoughts?

Thank you very much  in advance!

Best regards,
Primoz J.




To elektronsko sporo?ilo in vse morebitne priloge predstavljajo poslovno 
skrivnost oziroma so zaupne in so namenjene izklju?no naslovniku. Kakr?nokoli 
razkrivanje, distribucija ali kopiranje vsebine sporo?ila je izrecno 
prepovedano. ?e ste sporo?ilo prejeli pomotoma, Vas prosimo, da o tem obvestite 
po?iljatelja, sporo?ilo pa takoj uni?ite.


--
This message has been scanned by E.F.A. Project and is believed to be clean.