Free:
http://www.ibphoenix.com/main.nfs?page=ibp_60_odbc

RBS

_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of pabloagogo
Sent: 23 March 2010 22:33
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: About Firebird and Excel VBA





Is the "IBPhoenix ODBC driver" driver free or is it commercial?

P

--- In firebird-support@ <mailto:firebird-support%40yahoogroups.com>
yahoogroups.com, "RB Smissaert" <bartsmissaert@...> wrote:

>
> All you need is the IBPhoenix ODBC driver and a reference in Excel to the
> latest ADO library.
> Connection string will be like this for a DSN-less connection:
> Driver={Firebird/InterBase(r) driver};
> Dbname=FullDBPath;
> PWD=Password;
> UID=Username;
>
> Doing a Google for ADO Firebird connectionstring will get you more
> information.
>
> RBS
>
> _____
>
> From: firebird-support@ <mailto:firebird-support%40yahoogroups.com>

yahoogroups.com

> [mailto:firebird-support@ <mailto:firebird-support%40yahoogroups.com>

yahoogroups.com] On Behalf Of pabloagogo

> Sent: 23 March 2010 17:45
> To: firebird-support@ <mailto:firebird-support%40yahoogroups.com>

yahoogroups.com

> Subject: [firebird-support] About Firebird and Excel VBA
>
>
>
>
> Hi There,
>
> I would like to use Excel as a data entry grid front end,
> and use Firebird as a backend.
>
> Using Excel VBA-ADO, what is required to connect to Firebird(lets say in
> Server mode), create a database file and populate it.
>
> What is the connection string required from VBA?
>
> Any help is appreciated.
> (By the way, can Firebird be used in an embedded mode, in Excel VBA?,
> is there any .dll file that can be used. I know that there is that kind of
> mode when I did a java app with JayBird).
>
> Sincerely,
>
> Pabloagogo
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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