Thanks, Ivan,

I was unable to locate the Interbase 6 documentation. What I found is
Interbase 7 documentaton what I have to purchase. I have no problem
of purchasing the document if I know it will address my problem.

So with Ivan's pointer, I started searching for DPB (Database
Parameter Block) and now I was able to specify the user/password and
the good news is now I can attach to the file database successfull. I
need to see if I can insert/delete/update/query for it next.

Thanks you very much for everyone's posting that help me get this far.
Yes, it took more than 2 hours for searching, but the actual
programming is nothing, only a few minutes of work.

Programming is nothing, knowledge is the power!

Thanks again!

Ming

--- In firebird-support@yahoogroups.com, "Ivan Prenosil"
<Ivan.Prenosil@...> wrote:

>
> > ok, I am using the embedded dll, and the isc_attach_database api call
> > does not allow for user/password specification.
>
> It can be specified using database parameter buffer (DPB),
> i.e. the last parameter of isc_attach_database().
>
> Or, you can use environment variables ISC_USER and ISC_PASSWORD.
>
> >
> > Again, pardon my ignorance, I did not find any documentation on API.
> > I can only derive the calling sequence from the header file.
>
> Use InterBase6 documentation.
>
> Ivan
>