1

Topic: connection rejected by remote interface

Kind day.
In Firebird it is not strong, but there is a necessity to read a file with FDB extension.
Installed Firebird 3 and ODBC
I try it will be connected to basis so:
driver = {Firebird/Interbase (r) driver} ;DbName=localhost:.FDB;UID=SYSDBA;PWD=masterkey;CHARSET=WIN1251
The error report:
There was an exceptional situation (Microsoft OLE DB Provider for ODBC Drivers): [ODBC Firebird Driver] connection rejected by remote interface
Prompt the guru where to dig, what to check, where to look?

2

Re: connection rejected by remote interface

alekckuc;
The server is not launched

3

Re: connection rejected by remote interface

You are connected by the client of version 2.5 to the server 3.0

4

Re: connection rejected by remote interface

hvlad, the server like is launched, anyway services work

5

Re: connection rejected by remote interface

Shavljuk Evgenie and how to correct? Where to look?
I will in addition explain, it is possible I am important connected through COM object ADODB.Connection

6

Re: connection rejected by remote interface

alekckuc;
I am normal for check  IBExpert.
In triple is not present by default SYSDBA/masterke.

7

Re: connection rejected by remote interface

AltHasp wrote:

alekckuc;
I am normal for check  IBExpert.
In triple is not present by default SYSDBA/masterke.

IBExpert the same is not got https://www.screencast.com/t/fP773lQdt

8

Re: connection rejected by remote interface

alekckuc wrote:

it is passed...
IBExpert the same is not got https://www.screencast.com/t/fP773lQdt

00541C13] FIB.IBError (Line 556, "FIB.pas" + 55) + $2
[0053D60C] FIBDatabase. TFIBDatabase. Open (Line 1122, "FIBDatabase.pas" + 64) + $9
[00517BC3] pFIBDatabase. TpFIBDatabase. Open (Line 285, "pFIBDatabase.pas" + 9) + $2
[0053D8FD] FIBDatabase. TFIBDatabase. SetConnected (Line 1192, "FIBDatabase.pas" + 4) + $4
[010B8BFE] IBEDatabases. TIBEDatabase. Connect (Line 3238, "IBEDatabases.pas" + 2) + $10
[01051142] InspectorFm. TInspectorFrame. OpenDatabase (Line 3325, "Frames\InspectorFm.pas" + 44) + $D
[00FC4A69] Main.TIBEMainForm.actConnectToDatabaseExecute (Line 6959, "Main.pas" + 4) + $D
[004258E7] Classes. TBasicAction. Execute (Line 8076, "Classes.pas" + 3) + $7
[004DF874] dxBar. TdxBarItemControl. ControlUnclick (Line 22796, "dxBar.pas" + 28) + $7

9

Re: connection rejected by remote interface

alekckuc;
Well it is correct, login error (is not present  or the password not ).

10

Re: connection rejected by remote interface

AltHasp wrote:

alekckuc;
Well it is correct, login error (is not present  or the password not ).

And how to get the user?

11

Re: connection rejected by remote interface

alekckuc wrote:

hvlad, the server like is launched, anyway services work

Firewall locks port 3050?
What in firebird.log?

12

Re: connection rejected by remote interface

alekckuc wrote:

it is passed...
And how to get the user?

https://www.firebirdsql.org/file/docume … /qsg3.html

13

Re: connection rejected by remote interface

Evgenie wrote:

You are connected by the client of version 2.5 to the server 3.0

alekckuc wrote:

In Firebird it is not strong...
Installed Firebird 3 and ODBC

Whence there to undertake to other client?

14

Re: connection rejected by remote interface

Thanks for the link, at sketchy review speak about that that is both user SYSDBA and the password at it by default masterkey
I will try to dig ports

15

Re: connection rejected by remote interface

hvlad wrote:

it is passed...
Firewall locks port 3050?
What in firebird.log?

Prompt,  where to search firebird.log?

16

Re: connection rejected by remote interface

hvlad wrote:

it is passed...
Firewall locks port 3050?
What in firebird.log?

The port checked up telnet everything is all right is opened

17

Re: connection rejected by remote interface

alekckuc;
Launch the console (cmd) in the directory with Firebird
There launch

 isql-user sysdba 

In it fulfill and show result

set list;
select * from sec$users;

18

Re: connection rejected by remote interface

hvlad wrote:

alekckuc;
Launch the console (cmd) in the directory with Firebird
There launch

 isql-user sysdba 

In it fulfill and show result

set list;
select * from sec$users;

https://www.screencast.com/t/3Ou5NNkCT7U5

19

Re: connection rejected by remote interface

hvlad wrote:

there launch

 isql-user sysdba 

and any DB, certainly, without a host;
For example

 isql-user sysdba PutIImjaFajla.FDB 

20

Re: connection rejected by remote interface

For screenshots here can and drive. Is not present either necessities, nor sense to rush pictures when it is possible to copy the text
Now try

 isql-user sysdba-pass masterkey localhost:.FDB 

21

Re: connection rejected by remote interface

hvlad wrote:

it is passed...
For screenshots here can and drive. Is not present either necessities, nor sense to rush pictures when it is possible to copy the text
Now try

 isql-user sysdba-pass masterkey localhost:.FDB 

As that so:
SQL> isql-user sysdba-pass masterkey localhost:C:\bp7.FDB
CON>

22

Re: connection rejected by remote interface

alekckuc;
It is not necessary in isql to write commands for cmd.

23

Re: connection rejected by remote interface

hvlad;
Statement failed, SQLSTATE = 08004
unsupported on-disk structure for file C:\BP7\BP.FDB; found 10.1, support 12.0
-IProvider:: attachDatabase failed when loading mapping cache
Use CONNECT or CREATE DATABASE to specify a database
SQL>
Not that format of a DB?
Thus native application from which this file works normally with it

24

Re: connection rejected by remote interface

alekckuc;
Firebird 3 works only from a DB in  12
For operation with previous  put Firebird 2.5

25

Re: connection rejected by remote interface

hvlad wrote:

alekckuc;
Firebird 3 works only from a DB in  12
For operation with previous  put Firebird 2.5

Thanks, truth 2.5 same did not fly up, but now at least I understand it is necessary to specify a DB format.