Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

In Windows Vista, cannot create new database on localhost [CORE2533] #2943

Closed
firebird-automations opened this issue Jul 1, 2009 · 11 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Brian Hartmann (brhartmann)

There were similar posts but this issue did not seem to be addressed conclusively.

We use Firebird in one of our products, currently version 1.5, as the last release supported Win 2k, Win XP and Win Server 2k3 only.

Due to the control panel issue in Vista and also wanting to keep current with Firebird technology, for our next product release I am testing out version 2 on my Vista dev machine (Vista Ultimate, currently sp2, but the problem also occurred with sp1 before I upgraded). We would like to allow our next product release to be used in Vista and Windows Server 2k8 (and perhaps Windows 7).

I 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.

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 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=***; password=***; database=***.fdb; pooling=false}
(anything in *** I would prefer not to share, but I am sure these are valid strings)

I have tried versions 2.1.1, 2.1.2, and after reading issue DNET140 I thought perhaps it was fixed in the 2.5 beta, so I just tried that (2.5.0.23247) ... still no good.

I had tried 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 (based on this article:
http://firebirdsql.org/dotnetfirebird/blog/2006/04/common-firebird-errors-and-firebird.html)

Generally with version 1.5 the database file was created in C:\Windows\System32. With the v2.1.2 release I used FlameRobin to create a test database in the System32 folder, and that worked fine, so I do not suspect permission issues. My account is part of the (local machine) Administrators group, and I have UAC turned off.

I would appreciate any advice on a solution, workaround, ETA on a fix, etc. for this problem. Thank you.

@firebird-automations
Copy link
Collaborator Author

Commented by: Brian Hartmann (brhartmann)

Another detail I forgot to mention: We were previously using .NET 2.0 (VS 2005), but are now using .NET 3.5 sp1 (Visual Studio 2008 sp1).

@firebird-automations
Copy link
Collaborator Author

Commented by: Sean Leyne (seanleyne)

Brian,

This seems to be a support issue, the error message being reported (unable to complete network request), is something controlled by the OS or a firewall.

{There are plenty of installs running on Vista and Win2008 without any issues}

Please post this issue to the support mailing list.

@firebird-automations
Copy link
Collaborator Author

Commented by: Lester Caine (lsces)

More accurately Sean - it seems just to be a .NET issue since FlameRobin IS working for him.
But using 'C:\Windows\System32' as a location for DATA? I can imaging Microsoft code such as .NET objecting to that ... but the best starting point is the Firebird .Net list
p.s. - does that driver really use ';' as the separator between host name and database ?

@firebird-automations
Copy link
Collaborator Author

Commented by: Brian Hartmann (brhartmann)

I posted my problem to the support newsgroup. Thank you both for taking the time to respond and point me in the right direction.

@firebird-automations
Copy link
Collaborator Author

Commented by: Sean Leyne (seanleyne)

Brian,

I'm not sure how to interpret your last reply.

Are you saying that this issue has been addressed by the support list(s) (and this case can be closed)?

@firebird-automations
Copy link
Collaborator Author

Commented by: Brian Hartmann (brhartmann)

Well, it hasn't been answered yet, but I moved the question to what I hope is the right place to be asking it, so here it can be closed at least. As you say, there have been successful installs on Vista and so this is likely not a legitimate bug. I did initially try sending to the ib-support mailing list, and for some reason it never showed up. However, after re-reading Lester's comment I subscribed to the Firebird-net-provider list instead and sent the issue there, and I have verified it at least went out to the list members. I reshaped the question and added more details about my experiments based on the article "How to Ask questions the smart way" -- there was a link to this somewhere on the Firebird site -- good stuff (obviously, I am a bit green when it comes to successfully seeking help on open source software), so hopefully my issue will catch someone's interest who can help me further.

p.s. Lester -- the driver definitely uses semicolons as separators (using the FbConnectionStringBuilder class proves this).

@firebird-automations
Copy link
Collaborator Author

Commented by: Konstantin Dombrugov (abracadabra)

I'm using FirebirdClient on Vista Business sp1 and cannot reproduce this issue.
Try to specify port in connection string like "port number=3050"

@firebird-automations
Copy link
Collaborator Author

Commented by: Sean Leyne (seanleyne)

Brian,

Given Konstantin's comments, and my own experience using Win2008 (although we don't create database from scratch) I'm inclined to believe that the issue is with the server setup, and as such this case should be closed (as "Won't Fix").

I will give you another week to work through this, before making any changes to the case.

@firebird-automations
Copy link
Collaborator Author

Commented by: Brian Hartmann (brhartmann)

Sean, you probably should close the issue here. It is clear I should have posted to the net provider mailing list in the first place rather than here, my apologies.

I seem to have problems with pre-Vista Windows as well -- I pulled out the relevant Firebird code into a small test program and tried it on Vista (same result) AND on Windows XP sp3 -- here, the database file gets created, but I get a different exception upon trying to open the database. I have sent more details on this to the net provider list. Konstantin, thank you also for trying to help.

@firebird-automations
Copy link
Collaborator Author

Modified by: Sean Leyne (seanleyne)

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Won't Fix [ 2 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant