Unable to connect to Server, with real help from error message
--------------------------------------------------------------
Key: DNET-1035
URL: http://tracker.firebirdsql.org/browse/DNET-1035
Project: .NET Data provider
Issue Type: Bug
Components: ADO.NET Provider
Affects Versions: 7.10.1.0, 7.10.0.0, 7.5.0.0
Environment: OS: Windows Server 2019 Standard
Firewall: Disabled
Internet connection / DNS Working: Yes
Reporter: Poul Lindholm Christiansen
Assignee: Jiri Cincura
Hi
I have downloaded Firebird 3.0.7 and installed the server.
Easy - peasy.
I did this because, i want to evaluate using firebird for an application that I'm staring out on just now. It's not going so well :-(
I have then started Visual Studio 2019 on the same computer as the server is installed.
I have this code:
FbConnectionStringBuilder connStr = new FbConnectionStringBuilder();
connStr.UserID = "SYSDBA";
connStr.Password = "masterkey";
connStr.Port = 3050;
connStr.DataSource = "127.0.0.1";
connStr.Database = @"test.db";
connStr.Dialect = 3;
connStr.Charset = "UTF8";
connStr.ServerType = FbServerType.Default;
connStr.Pooling = true;
connStr.MinPoolSize = 15;
connStr.MaxPoolSize = 30;
connStr.PacketSize = 8192;
connStr.WireCrypt = FbWireCrypt.Required;
FbConnection.CreateDatabase(connStr.ConnectionString, false);
Whicc I was expecting to create a Database on the server.
I have tried everything (it feels like that at least) in the "DataSource" ("127.0.0.1", "localhost", "::1", "DEV3" etc) and "Database" ("inet://127.0.0.1:3050/test.db", "DEV3:test.db" ......) properties.
Regardless of these settings ige et this error:
FirebirdSql.Data.FirebirdClient.FbException
Unable to complete network request to host "
No message for error code 335544721 found.
Sometimes the host '' from the message is replaced by the actual hostname, but the error remains the same.
I have run netstat -a to verify that firebird.exe is running and listening to requests on port 3050.
If I change the WireCrypt - then I get error messages related to this, so that works.
When I do a search online - i get posts that are 5-6 years old and only talking about disabling the firewall.
Since the error message does not contain any helpfull information about the issue at hand - I'm at a loss and a little afraid about using Firebird in an application that I need to support going forward.
I do not know what to do and how to trouble-shoot.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|