I have searched the archives for this list, and the web in general, finding no
reference to the issue I am facing. Also, I have tried many experiments, as
mentioned below.
The issue is that when the program tries to create a new database
(FirebirdSql.Data.FirebirdClient.FbConnection.CreateDatabase(connection_string)),
an exception is thrown:
"Unable to complete network request to host "localhost" "
(this gets logged as an exception of type
'FirebirdSql.Data.Common.IscException').
I am
testing out Firebird version 2 on my Vista dev machine (Vista Ultimate,
currently sp2, but the problem also occurred with sp1 before I
upgraded). Our Firebird-related code runs fine with Firebird 1.5 in Windows XP
and Windows Server 2003 (but now we need to support Vista). We were previously
using .NET 2.0 (VS 2005) with Firebird 1.5, but I am now using .NET 3.5 sp1
(Visual Studio 2008 sp1).
I have tried versions 2.1.1, 2.1.2, and beta 2.5.0.23247. In each case, I had
installed with a silent command line to simulate how our users would be
installing. Here are the command line args:
/SP- /SILENT /DIR="C:\Firebird" /NOICONS /NOCPL /NOGDS32
/COMPONENTS="SuperServerComponent, ServerComponent, ClientComponent"
Our program is mainly in C#, and we use the .NET
FirebirdSql.Data.FirebirdClient library.
I looked at the FirebirdSql.Data.FirebirdClient.dll file details to see if
perhaps I was using an older version and needed to update it. The
version is listed as 2.0.0.0 (filesize 692,222 bytes). The Firebird v2
installations did not seem to include any later version based on a
Windows file search of my C: drive, and searching on Google did not
indicate any clear need to upgrade this dll.
I have tried replacing "localhost" with 127.0.0.1, but the result is the same.
In case it is helpful, here is more detail about the connection
string: {server=localhost;user id=SYSDBA; password=masterkey;
database=NameOfDatabase.fdb;
pooling=false}
I have validated the syntax of the connection string by switching to using
FbConnectionStringBuilder, and also tried adding the port (3050) even though
this is indicated as optional.
I had tried temporarily turning off the Windows Firewall when I was using
v2.1.1. However, for v2.1.2 and v2.5 beta I added an exception for TCP
port 3050.
Generally with version 1.5 the database file was created in
C:\Windows\System32 (I know, this is not a wise place to put the database file
-- a previous developer left it there, and I plan to move it before our next
release). With the v2.1.2 release I used FlameRobin to
create a test database in the System32 folder, and that worked fine. My account
is part of the (local
machine) Administrators group, and I have UAC turned off.
I also changed the location during recent testing to a folder under my user
account, which yielded the same exception.
I would appreciate any advice that can get me on track towards solving this
problem.
------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
