Re: [Firebird-odbc-devel] ODBC connection fails

[Helen B. <he...@ii...>]

At 08:50 AM 16/12/2010, Ken Benson wrote:

>I have a database (single file). 
>I'm able to connect to this database using ISQL, and Database Browser from DB software. 
>I'm also able to extract data from the database using FBExport - just fine. 
>I created an ODBC connection to this database - and when I click the 'test' button, it reports 'connected'. 

Assuming here, then, that you are connecting as SYSDBA with the default password on Windows, 'masterke'.  ('masterkey' but the 'y' is not read.)

>However, when I use either of the two applications I have available - to connect to this ODBC connection, I get an error, "Your user name and password are not defined. Ask your database administrator to set up a Firebird login."
>
>I don't understand. 

Whoever wrote those apps has hard-coded a username and password into their code, that are not the SYSDBA/masterke combination that the whole world knows (which is *entirely* expected).  If you know what they are, then you will have to set them up in your server.  There's no way to discover them if you don't know them.

Clue here: gsec.exe. 

If you don't know what I'm talking about then you have some research to do - start with the Quick Start Guide that's in your Firebird ..\doc folder.  It's not an ODBC issue.

HB