Hi Paul,

> Is it possible to have a connection open to a Firebird embedded
> database and have another connection open to a Firebird database on a
> server at the same time from within one program?

Yes. The Firebird Embedded library can also act as a client
for normal database access. Just use a server name as you
would normally do when connecting to a remote server.

> Since two different versions of fbclient.dll are needed, how is it done?
>
> I want to copy some rows from some of the tables in a Firebird
> database on a server to the Firebird embedded database. I do not want
> to export the data to a flat file first but instead want to perform
> the copy in one step within the same program.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com