On 2/16/06, Martijn Tonies <m.tonies@...> wrote:
> Hi,
>
> > I received the following message as I connected to an older Interbase
> > database from a ISQL window.
> >
> > Warning Pre IB V6 database only speaks SQL dialect 1 and does not
> > accet Client SQL dialect 3. Client SQL Dialect is reset to 1.
> >
> > A few questions:
> > 1. I presume the SQL Dialect 3 is the later release of SQL that most
> > DBs now run on ?
>
> If you mean by "most DBs", different database systems, then "no". This
> has nothing to do with that.
>
> IB 6 introduced "dialect 3" as to avoid compatibility problems between
> some new features and the older "dialect 1".
>
> > 2. If I have an old Interbase Database and want to port the data over
> > to Firebird, what is the easiest way to do so ?
>
> Transfer the metadata first by extracting a script. Then transfer the data
> by using a source and destination connection to each server.
>


Would you be able to elaborate on this procedure a bit further ? What
sort of application do I use ? or is there some command line function
which connects the two DBs and populates the 2nd empty one if you have
created the empty tables ?

Thanks again,
Gaurav
> > 3. Are there special configurations required for a database to be
> > accesible by multiple users over a LAN ? If the database is stored on
> > one host PC and other users try to access it over a LAN, and I have
> > installed the Super Server (I think) Firebird database, would this be
> > easier to do ?
>
> You need to have the server process running (Firebird: fbserver.exe)
> and make it accessible to others on the network.
>
> Martijn Tonies
> Database Workbench - development tool for Firebird and more!
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>


--



Analyst
B. Engineering, B. IT
A.N.U (2004)

M: +61 401 409 620
H: +61 3 9376 8580


"In life, always do right. This will gratify some people and astonish the rest."

— Mark Twain