You need:

Version 2.0 RC1

* 20th Nov 2008 Windows Full Install (32bit) (.exe)

This is not for a reference in Excel, the only Excel reference you need is
for ADO.


RBS

_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of kleinmoney
Sent: 24 March 2010 14:18
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: About Firebird and Excel VBA




Hi, RBS,

I could not find the reference of odbc driver. The driver I found here is
just a dll, which I can't load it as a reference.

http://www.ibphoeni <http://www.ibphoenix.com/main.nfs?page=ibp_60_odbc>
x.com/main.nfs?page=ibp_60_odbc

Would you mind give me some help? Thanks!

--- 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]