> Thanks for your answer. I think I got help from you also during last time 
> migration test. :-)
> I tested it with your advice but it still doesn't work.

I am not convinced you have that authentication configured properly
nor that your application is really loading the Fb3 client library.

Some reality checks:

1. Make sure that you deleted the # symbol when you configured
AuthServer.

2. It might be worthwhile to change the ordering of the list in
AuthClient, so that Legacy_Auth appears first.

2. Get rid of SRP from the UserManager list.  Make it so that
Legacy_UserManager is only entry.

3. Don't forget to save firebird.conf, and to restart Firebird.

4.  Put fbclient.dll in the same folder as your application.  It would
probably be a good idea to reboot the client machine, while you are at
it, in case the old version is still loaded.

> I would like to test it with a fresh installation of FB 3.0 later.

> I should make my description more clear for my steps.


> 0. First of all, all applications are running in Windows 7. FB x32 versions 
> are used for testing.
> 1. Use gbak (FB 2.5) to backup Firebird 2.5 database file.
> 2. Use gbak (FB 3.0) to restore backuped FBK file to a new database file.
> 3. Use isql, to run: SQL> alter user sysdba set password 'masterkey';
> respond: Database: myimport,&n  bsp;User: SYSDBA

Without the modifications to firebird.conf, that step operates on the
SYSDBA that is configured under UserManager SRP.  It will NOT work
with applications connecting via Legacy_UserManager.

You have to create SYSDBA for use with Legacy_UserManager.  You need
to use the USING PLUGIN clause, as indicated in my previous posting.

> 4. Open new database file in IBExpert with FB 3.0 client library 
> (fbclient.dll), it works.
> 5. Run my own applicatoin with FB 3.0 client library which works
> with FB2.5 client library, error message shows below:
> [FireDAC][Phys][FB]Your user name and password are not defined. Ask
> your database administrator to set up a Firebird login.

> ********************************
> Connection string inside my code
> ********************************
>   object dbcMain: TFDConnection
>     Params.Strings = (
>   &nbsp  ;   'DriverID=FB'
>       'User_Name=sysdba'
>       'Password=masterkey')
> ********************************

But it will not work if either (or both)
1) the application is loading the Fb 2.5 client
2) firebird.conf configuration is a mismatch with the client

BTW, you are not REALLY using masterkey for your SYSDBA password, are
you?

HB

  • [firebird-supp... James mallee....@gmail.com [firebird-support]
    • Re: [fire... Alexey Kovyazin a...@ib-aid.com [firebird-support]
    • Re: [fire... Helen Borrie hele...@iinet.net.au [firebird-support]
      • Re: R... James mallee....@gmail.com [firebird-support]
        • R... 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
        • R... Helen Borrie hele...@iinet.net.au [firebird-support]
          • ... James mallee....@gmail.com [firebird-support]
          • ... James mallee....@gmail.com [firebird-support]
            • ... Tim Ward t...@telensa.com [firebird-support]
              • ... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
              • ... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
              • ... Lester Caine les...@lsces.co.uk [firebird-support]
                • ... Norman Dunbar nor...@dunbar-it.co.uk [firebird-support]
              • ... Stefan Heymann li...@stefanheymann.de [firebird-support]
              • ... Tim Ward t...@telensa.com [firebird-support]
                • ... Tim Ward t...@telensa.com [firebird-support]

Reply via email to