Connecting to Firebird with SQL explorer should be no problem. First you
have to You then have to modify a registry entry for the interbase setup to
add a key for SQLDIALECT.

run regedit and browse to:

HKEY_LOCAL_MACHINE\SOFTWARE\Borland\Database
Engine\Settings\DRIVERS\INTRBASE\DB OPEN

Right click in the right pane and select New|String Value

Name this value "SQLDIALECT" ... I'm not sure what dialect you should use
for an Interbase database. The value would either be 3 or 1.

Now, create create a new entry with driver "INTRBASE" and set the local path
and you should be good to go.

For non BDE connection to Firebird I use (and recommend) IBExpert
(http://www.ibexpert.com). I also use IBObjects in my application.

Hope this helps!

-Anthony


W. Anthony Tanas
Systems Analyst/Architect/Programmer
-------------------------------------------
Liquid Software Designs, Inc.
1300 Maynard Rd.
Ste. 102
Cary, NC 27511
-------------------------------------------
Phone: 919.244.3276
Fax: 866.394.5961
Email: anthony@...
Web: http://www.liquidsoftwaredesigns.com
<http://www.liquidsoftwaredesigns.com/>
-------------------------------------------




_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Erik GIls
Sent: Monday, December 11, 2006 5:47 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Borland Database Explorer & Firebird



Hi There

I'm currently trying to migrate my Interbase 5.5
application to a firebird database. I'm running into a
problem though. My application has been written in
Delphi 6 based on the database express component.

I installed Firebird on my laptop that serves as a
develop/test enviroment. I switched of the Interbase
server that is also installed on my laptop off first.
After the manual install of firebird (and modifying
the dbxconnections file) my application works fine.

Socondly I tried either the application (with the new
firebird components/GDS32 file) still worked over the
network with our current interbase server. This also
worked fine.

The problems start if I try to enter the database
using the Borland Database Explorer. If I try to do so
locally, there is no way I get acces to the database.
I've experimented with the new GDS32 as well as with
the old one. The Borland IDE just terminates without
giving any error-message.

The only method that I found to get acces to the
database (other than my application) was the old GDS32
file in combination with the Interbase server over the
network.

Thanks in advance !

Erik

__________________________________________________________
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail beta.
http://new.mail. <http://new.mail.yahoo.com> yahoo.com






[Non-text portions of this message have been removed]