Got it working after deleting both .gdb and .fdb files and
regenerating UserGroupDB.fdb.


--- In firebird-support@yahoogroups.com, "throwmail2000"
<throwmail2000@y...> wrote:

> Thank you David, I downloaded the UserGroupDB.sql and I'm going
> to learn a lot from it.
> I used IBExpert to open it and create database. IBExpert gave
> error when I tried to execute the script. It complained that
> 'TIME' is not defined in 'Dialect 1'. I solved this by adding
> 'SET SQL DIALECT 3;' on top of script. And then it complained
> that it cannot create UserGroupDB.GDB, so I changed its name
> from .GDB to .FDB. Now it executed fine and I can play around
> with the database using IBExpert, but when I put mouse over
> database name then in a popup bubble it shows database name as
> .GDB and Dialect 1. And using windows explorer I checked the
> data directory and it showed both .gdb(836kb) and .fdb(.94MB) files.
>
>
> --- In firebird-support@yahoogroups.com, "David Cornelius" <dev@c...>
> wrote:
> > "Employee" is a good test one. I also uploaded one to the Yahoo!

Groups

> > "files" page called, UserGroupDB.sql.
> >
> > --
> > David Cornelius
> > CorneliusConcepts.com
> >
> >
> > ----- Original Message -----
> > From: throwmail2000
> > To: firebird-support@yahoogroups.com
> > Sent: Wednesday, March 03, 2004 7:59 PM
> > Subject: [firebird-support] Sample/example firebird databases
> >
> >
> > Are there any freely available sample firebird databases.
> > I'm new to firebird so want to get familiar with its
> > design and syntax etc.
> > So far I found two sample databases ibdemo.gdb and employee.fdb
> >
> >
> >
> > Yahoo! Groups Sponsor
> > ADVERTISEMENT
> >
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> > To visit your group on the web, go to:
> > http://groups.yahoo.com/group/firebird-support/
> >
> > To unsubscribe from this group, send an email to:
> > firebird-support-unsubscribe@yahoogroups.com
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.