Discussion:
Firebird connection not working under Vista
(too old to reply)
Markus.Humm
2008-02-28 21:04:44 UTC
Permalink
Hello,

clicked send to soon...

Okay I also tried to change the paths to the database file in the ini
files as Windows is unclear about the name of the user folder (sometimes
it's listed in english sometimes in german...they simply messed up
things!). This didn't help. The exception is always the same.

Greetings

Markus
Bill Todd [TeamB]
2008-02-28 22:15:45 UTC
Permalink
I'm also using MadExcept which says the failure is on the connect
call and the exception code is 0x0015 "database unavailable".
What happens when you try to connect to the database with isql? Do you
get the same error?
The fbclient.dll is on the system and the user is admin. Now he's got
write rights on the application folder where also the ini files (yes,
UAC is on and inis in the application directory is a no no nowdays
but I don't change them in my app.) and the database file is located.
Since you are using the InterBase driver, which does not officially
support Firebird, I assume you installed Firebird for IB compatibility.
If so, you should be using a version of the FB client named gds32.dll.

Are you saying that the application, the INI files and the database
file are all in a folder under the Program Files folder? The first
thing I would try is turning UAC off temporarily to see if that solves
the problem. If it does then you know that the error is caused by lack
of rights and you can try to determine what the FB server does not have
rights to.
--
Bill Todd (TeamB)
Tommi Prami
2008-02-29 08:57:35 UTC
Permalink
Hello,

We had some connection problesm, and those went away by defining:

database=127.0.0.1:C:\Data.FDB

in dbxconnections.ini. If there was no IP it just did not work too well...

-TP-
Post by Markus.Humm
Hello,
I've developped a application with BDS2006 where I connect to a Firebird
1.5 database on the same computer using the Interbase driver. Under XP
all works fine but not under Vista.
I'm using loadparams on connect so I deploy both ini files
(dbxdrivers.ini and the pther one).
I'm also using MadExcept which says the failure is on the connect call
and the exception code is 0x0015 "database unavailable".
The Firebird services are running and the user for them is local system
account and connection with desktop is allowed (sorry, maybe the
translation of this services stuff may be wrong, it's a non english Vista).
The fbclient.dll is on the system and the user is admin. Now he's got
write rights on the application folder where also the ini files (yes,
UAC is on and inis in the application directory is a no no nowdays but I
don't change them in my app.) and the database file is located.
What's wrong here and how to solve this?
Greetings
Markus
Markus.Humm
2008-02-29 09:27:48 UTC
Permalink
Hello,

your suggestion helps a bit. Now the login works.
My app. fails later with db connection problems because after login it
connects to a server and loads a new version of the database down which
is then written over the old one. As it seems the reconnect to the
database is causing trouble afterwards.

Unluckily I have no direct access to that PC or to Vista.

Another question: is the LoadParamsOnConnect setting Vista UAC
compatible? Or where does it search for ini files? Has this been changed
in D2007 vs. BDS2006?

Greetings

Markus

Martijn Tonies
2008-02-29 09:11:37 UTC
Permalink
Post by Markus.Humm
I've developped a application with BDS2006 where I connect to a Firebird
1.5 database on the same computer using the Interbase driver. Under XP
all works fine but not under Vista.
I'm using loadparams on connect so I deploy both ini files
(dbxdrivers.ini and the pther one).
I'm also using MadExcept which says the failure is on the connect call
and the exception code is 0x0015 "database unavailable".
Firewall?
--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
Loading...