[Firebird-odbc-devel] ODBC connection fails

[Ken Benson]

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

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.

Ken B

ken ------ at ---------- bkenbenson ------------ dot ---------- com

[Helen Borrie]

Post by Ken Benson
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.)

Post by Ken Benson
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

[Ken Benson]

Post by Ken Benson

Post by Helen Borrie
Whoever wrote those apps has hard-coded a username and password into

their code, that are not the SYSDBA/masterke combination

Post by Ken Benson

Post by Helen Borrie
that the whole world knows (which is *entirely* expected). If you know

what they are, then you will have to set them up in

Post by Ken Benson

Post by Helen Borrie
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:***@iinet.net.au]
Sent: Wednesday, December 15, 2010 1:10 PM
To: firebird-odbc-***@lists.sourceforge.net
Subject: Re: [Firebird-odbc-devel] ODBC connection fails

Post by Ken Benson
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.)

Post by Ken Benson
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."

Post by Ken Benson
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

[Ken Benson]

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:***@bkenbenson.com]
Sent: Wednesday, December 15, 2010 1:38 PM
To: firebird-odbc-***@lists.sourceforge.net
Subject: Re: [Firebird-odbc-devel] ODBC connection fails

Post by Ken Benson

Post by Helen Borrie
Whoever wrote those apps has hard-coded a username and password into

their code, that are not the SYSDBA/masterke combination

Post by Ken Benson

Post by Helen Borrie
that the whole world knows (which is *entirely* expected). If you know

what they are, then you will have to set them up in

Post by Ken Benson

Post by Helen Borrie
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:***@iinet.net.au]
Sent: Wednesday, December 15, 2010 1:10 PM
To: firebird-odbc-***@lists.sourceforge.net
Subject: Re: [Firebird-odbc-devel] ODBC connection fails

Post by Ken Benson
I have a database (single file).
I'm able to connect to this database using ISQL, and Database Browser
from

DB software.

Post by Ken Benson
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.)

Post by Ken Benson
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."

Post by Ken Benson
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
Firebird-odbc-***@lists.sourceforge.net
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

[Helen Borrie]

Post by Helen Borrie

Post by Helen Borrie
Whoever wrote those apps has hard-coded a username and password into

their code, that are not the SYSDBA/masterke combination

Post by Helen Borrie
that the whole world knows (which is *entirely* expected). If you know

what they are, then you will have to set them up in

Post by Helen Borrie
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?

I guess so.

Post by Helen Borrie
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.

Then that says the access to the objects you are trying to access have been (correctly) set up with SQL Privileges that have been bundled in a ROLE. SQL Privileges belong to a database, not a server.

This is *still* not an ODBC issue...If you have been connecting to that database using isql (which doesn't use ODBC) and the SYSDBA credentials *for your server*, you should be able to ascertain the roles that have been defined in that database, using SHOW ROLES. SHOW GRANT should show you the name[s] of the user[s] that have been granted the respective roles. To make it work, you will need to define that/those user[s] in your server's security database, logged in as SYSDBA. And then, when you attempt to connect, you will need that user's login credentials PLUS the role name (which may or may not be case-sensitive, so assume it is...copy exact case from what SHOW ROLES displays and wrap in double quotes if SHOW ROLES displays something other than all-caps.

Post by Helen Borrie
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.

If we are talking about the same database browser (DBrowser.exe) then look at my posting from last week, which shows a screenshot of a successful ODBC connection made by that application. However, that browser is pretty generic...it probably doesn't even know about roles.

HB

[Ken Benson]

I would love to see the screen shot ... but, when I view that posting -
there's no screen shot in it. :-(

-----Original Message-----
From: Helen Borrie [mailto:***@iinet.net.au]
Sent: Wednesday, December 15, 2010 2:49 PM
To: firebird-odbc-***@lists.sourceforge.net
Subject: Re: [Firebird-odbc-devel] ODBC connection fails

Post by Helen Borrie

Post by Helen Borrie
Whoever wrote those apps has hard-coded a username and password into

their code, that are not the SYSDBA/masterke combination

Post by Helen Borrie
that the whole world knows (which is *entirely* expected). If you know

what they are, then you will have to set them up in

Post by Helen Borrie
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?

I guess so.

Post by Helen Borrie
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.

Then that says the access to the objects you are trying to access have been
(correctly) set up with SQL Privileges that have been bundled in a ROLE.
SQL Privileges belong to a database, not a server.

This is *still* not an ODBC issue...If you have been connecting to that
database using isql (which doesn't use ODBC) and the SYSDBA credentials *for
your server*, you should be able to ascertain the roles that have been
defined in that database, using SHOW ROLES. SHOW GRANT should show you the
name[s] of the user[s] that have been granted the respective roles. To make
it work, you will need to define that/those user[s] in your server's
security database, logged in as SYSDBA. And then, when you attempt to
connect, you will need that user's login credentials PLUS the role name
(which may or may not be case-sensitive, so assume it is...copy exact case
from what SHOW ROLES displays and wrap in double quotes if SHOW ROLES
displays something other than all-caps.

Post by Helen Borrie
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.

If we are talking about the same database browser (DBrowser.exe) then look
at my posting from last week, which shows a screenshot of a successful ODBC
connection made by that application. However, that browser is pretty
generic...it probably doesn't even know about roles.

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

[Helen Borrie]

Post by Ken Benson
I would love to see the screen shot ... but, when I view that posting -
there's no screen shot in it. :-(

Keep scrolling down - the screenshots got moved to the end.

HB

[Robert martin]

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>

<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi<br>
<br>
When I configure a System DSN in a clients Windows 7 64bit and do a
'test' I get a 'Open database ....Db location... failed' error
message.&nbsp; I try the services button and get 'sqlcode -904, fbcode
335544792 - Cannot attach to services manager'. <br>
<br>
We are running FB 2.0 superserver (client did the install but I
believe it is Super server looking in task mgr) 32bit, ODBC 2.0.0
32bit.<br>
<br>
Our application the creates its own file DSN can connect to the DB
and access data fine.&nbsp; I ran '<span class="pBody postableBody">C:\Windows\SysWOW64\odbcad<wbr>32'
</span>to configure the odbc driver.&nbsp; <br>
<br>
Any suggestions would really help :)<br>
<br>
Thanks<br>
Rob<br>
<br>
</body>
</html>