--- In firebird-support@yahoogroups.com, Jason Dodson <jasond@...> wrote:

>
> Um, try:
>
> CONNECT localhost:D:\APPS\Firebird\examples\employee.fdb;

Well if that works then he is not using the embedded engine. He would
be using whatever full server is listening to 3050 on the local machine.

If you pass through a TCP connection string, the embedded engine
behaves like a standard client. This is clearly stated in the readme
in the embedded install.

Classic is the other way around. You can not (in Windows) connect to a
classic server using a local connection string, and so you will need
to put 'hostname:' first. This is also clearly stated in the quick
start guide amongst other places.

Superserver is able to accept both, except when connecting from a
terminal services session in which case only the TCP method works.

The best way to handle this is to use an ini file or equivalent to
build your connection string, and depending on which server type you
are connecting two, adjust your switch.

Embedded should not be used until you are ready to deploy. It prevents
multiple processes from connecting the single database, which is a
real PITA, because now you can't use your admin tool to confirm
records are successfully added etc.

Classic is not really the one you want to develop against for embedded
systems. Since embedded server is superserver in a dll, you are far
better off developing against superserver which will allow you to
develop using the local connection syntax and simply substitute the dlls.

Adam

>
>
> Jeff Lynn wrote:
> > Help! I am extremely fustratated, not able to use anything after
> > download.
> >
> > First, I tried to use the fbembed.dll from embedded download with a
> > sample code api1.c from the server folder of the class download. i
> > can compile and link but unable to create database as suggested in

api1.c.

> >
> > I then switch to startup up the classic server service, and use the
> > "Quick Start" doc to verify the installation using the ISQL utility,
> > as suggested in the Quick Start:
> >
> > D:\Apps\Firebird\bin>isql
> > Use CONNECT or CREATE DATABASE to specify a database
> > SQL> CONNECT 'D:\APPS\Firebird\examples\employee.fdb'
> > CON> user 'SYSDBA' password 'masterkey';
> > Statement failed, SQLCODE = -904
> >
> > unavailable database
> > SQL>
> >
> > How come?
> >
> >>From all the good news from all the posint, I was extremely unlucky to
> > get it going. I was being very careful and only download the release,
> > not the beta 2.0 version yet I still unable to do anything with the
> > installation, either server or embedded.,
> >
> > jml
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > 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
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
> --
> The information transmitted herewith is sensitive information

intended only for use to the individual or entity to which it is
addressed. If the reader of this message is not the intended
recipient, you are hereby notified that any review, retransmission,
dissemination, distribution, copying or other use of, or taking of any
action in reliance upon, this information is strictly prohibited. If
you have received this communication in error, please contact the
sender and delete the material from your computer.

>