Subject | Re: About Firebird and Excel VBA |
---|---|
Author | pabloagogo |
Post date | 2010-03-23T22:33:25Z |
Is the "IBPhoenix ODBC driver" driver free or is it commercial?
P
P
--- In firebird-support@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@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of pabloagogo
> Sent: 23 March 2010 17:45
> To: firebird-support@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]
>