Subject 133208 Re: [firebird-support] New Firebird 3.0.4 install can't attach, sysdba & password
Author Chris LeFebvre
Hi Carlos:

Thanks for the response, when I tried "isql 127.0.0.1:C:\Firebird\<database>.gdb –u sysdba –p <My password> I was able to connect to the database and show the properties of it and do a test select statement that returned data that shows me that I am in fact connected to the database. But I still can't connect to the database from my application (located on the tablet itself) or from Database Workbench on my development computer, in both cases I'm using the sysdba username and the same password that I did when using isql but I continue to get the error message "Your user name and password are not defined. Etc etc".

I tried installing Database workbench on the tablet and I was able to attach to the database without a problem; I tried looking for the fbclient.dll and there's a newer version than the one that I had in my applications directory. Once I renamed the old client library and copied the newer client library into my applications directory I was able to connect to the local server without any problem.

Thanks for your help.

>Carlos H. Cantu
>Today at 12:12 PM
>Firebird 3 allows users with the same name to exists in different authentication plugins, so you need to be sure that the user/password you are using in the connection >really exists and are correct in the authentication plugin being used.
>
>Also, note that:
>isql C:\Firebird\<database>.gdb –u sysdba –p <My password>
>
>In Firebird 3, the above command will connect using an embedded connection. In embedded connection, password is not validated. Try this:

>isql localhost:C:\Firebird\<database>.gdb –u sysdba –p <My password>

>and see if it works. It will force connection to be done with tcp/ip instead of embedded.

>Carlos
>Migration Guide to Firebird 3 eBook
>https://www.firebirdnews.org/migration-guide-to-firebird-3/