Thank you for your reply!

I installed this driver already and did reference ADO. ADO part is working properly, since I can connect to an Oracle database.

But when I try to connect to FB. VBA gives "run-time error '3706': provider cannot be found. It may not be properly installed."

Here is my VBA code.
Set conn = New ADODB.Connection
fb_options = "192.168.2.10:D:\database\OPTIONS.FDB"
conn.Provider = "Firebird/InterBase(r) driver"
conn.Open fb_options, sysdba, masterkey

--- In firebird-support@yahoogroups.com, "RB Smissaert" <bartsmissaert@...> wrote:
>
> 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]
>