I created a very small test program which simply sets up the connection string,
tries to create a fresh database, and then tries to open it. While the program
yields the same failure in Vista, I also tried it on a VM image with Windows XP
sp3, and Firebird 2.5 beta (2.5.0.23247) installed -- the test program can
create the database, but then gets a different exception upon trying to open
the database:
"Offset and length were out of bounds for the array or count is greater than
the number of elements from index to the end of the source collections" in
System.Buffer.BlockCopy (called from
FirebirdSql.Data.Client.Gds.GdsDatabase.DatabaseInfo(...) ).
Does my installation command line setup appear unorthodox? Aside from that, I
can only think that I have an outdated copy of the
FirebirdSql.Data.FirebirdClient.dll file (see details below), but again, I
would very much appreciate any hints or advice on how to further troubleshoot
these problems. I would be happy to send anyone my test program if you would
like to try it out and compare results.
----- Forwarded Message ----
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
------------------------------------------------------------------------------
Enter the BlackBerry Developer Challenge
This is your chance to win up to $100,000 in prizes! For a limited time,
vendors submitting new applications to BlackBerry App World(TM) will have
the opportunity to enter the BlackBerry Developer Challenge. See full prize
details at: http://p.sf.net/sfu/blackberry
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
