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

[Ken B. <ke...@bk...>]

Let me add, too.
I read the Quick start guide. I read the help file that came with ODBC, the
langref-update for Firebird 2.1, the PDF for GSEC.

One thing I'm still not sure of - should this ODBC be set up and FILE or
USER or SYSTEM?

Any ideas there? 

-----Original Message-----
From: Ken Benson [mailto:ke...@bk...] 
Sent: Wednesday, December 15, 2010 1:38 PM
To: fir...@li...
Subject: Re: [Firebird-odbc-devel] ODBC connection fails

>>>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.



Just so I'm clear - you mean the two apps I'm trying to connect using ODBC,
right?

Here's the deal - one of those apps is MAP DESIGNER from Pervasive. It has
fields for User/password - and if the ODBC connection is left blank, this
application prompts with a box for USER/PASSWORD/ROLE ... nothing I put in
this box satisfies the app.

The other app is the Database Browser. It has the capability to connect
directly - or via ODBC. It will connect to the database, directly. It will
NOT connect to the same database via ODBC.



-----Original Message-----
From: Helen Borrie [mailto:he...@ii...]
Sent: Wednesday, December 15, 2010 1:10 PM
To: fir...@li...
Subject: Re: [Firebird-odbc-devel] ODBC connection fails

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


----------------------------------------------------------------------------
--
Lotusphere 2011
Register now for Lotusphere 2011 and learn how to connect the dots, take
your collaborative environment to the next level, and enter the era of
Social Business.
http://p.sf.net/sfu/lotusphere-d2d
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel


----------------------------------------------------------------------------
--
Lotusphere 2011
Register now for Lotusphere 2011 and learn how to connect the dots, take
your collaborative environment to the next level, and enter the era of
Social Business.
http://p.sf.net/sfu/lotusphere-d2d
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel