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.

> 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