Re: [firebird-support] Wirecrypt

[Helen Borrie hele...@iinet.net.au [firebird-support]]

I wrote:
>> The Firebird 3 installer script didn't put it there but possibly
>> FlameRobin or Jaybird did.  Some client interfaces need to read
>> firebird.conf.  It won't conflict with the server's firebird.conf, per
>> se, but it would pay to keep the one used by the client app consistent
>> with the one used by the server.

Thursday, October 19, 2017, 9:13:39 PM, Mark wrote:

> Jaybird doesn't install anything, and AFAIK, neither does Flamerobin do
> anything with with firebird.conf. It is more likely the layout of the 
> specific firebird install on his Linux system.

More likely some other client app, then, as he seems to have installed
Firebird from the project package - since it is installed in
/opt/firebird.

FWIW, I'm on a Ubuntu-based Linux and their platform-specific Firebird
packages are a nightmare and usually horribly old.  I always install
from our own tar.gz because it just works, it's the latest sub-release
and I don't get files being spread all over the system.

Helen

Re: [firebird-support] "Invalid Cursor State"

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

19.10.2017 18:11, Tomasz Tyrakowski t.tyrakow...@sol-system.pl 
[firebird-support] wrote:
> The real nightmare of a programmer is not when the program doesn't work
> and she/he doesn't know why; it's when the program does work and she/he
> doesn't know why :)

https://docs.microsoft.com/en-us/sql/odbc/reference/develop-app/was-a-result-set-created


-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] "Invalid Cursor State"

[Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]]

On 19.10.2017 at 16:46, Jorge Andres Brugger jorge.brug...@gmail.com 
[firebird-support] wrote:
> I´m not sure which was the solution that finally worked, as I´ve made
> several changes, mostly on the execution order in my program (windows exe,
> not FB).
> I suppose there is some issues with ODBC driver _and_ Clarion, but I´m not
> really sure about it.

The real nightmare of a programmer is not when the program doesn't work 
and she/he doesn't know why; it's when the program does work and she/he 
doesn't know why :)

have a good one
Tomasz

-- 
__--==--__
__--== Tomasz Tyrakowski==--__
__--==SOL-SYSTEM==--__
__--== http://www.sol-system.pl ==--__
__--==--__

Re: [firebird-support] "Invalid Cursor State"

[Jorge Andres Brugger jorge.brug...@gmail.com [firebird-support]]

I´m not sure which was the solution that finally worked, as I´ve made
several changes, mostly on the execution order in my program (windows exe,
not FB).
I suppose there is some issues with ODBC driver _and_ Clarion, but I´m not
really sure about it.
Regards

2017-10-18 15:19 GMT-03:00 'Leyne, Sean' s...@broadviewsoftware.com
[firebird-support] :

>
>
>
>
>
>
> It´s an executable procedure which returns a parameter. It´s not a
> selectable procedure.
>
> Its the kind of SP you invoke like "execute procedure ... returning values
> ..." while selectable ones are usually called as "select ... from
> stored_procedure_name"
>
> I´ve managed to fix my issue, anyway.
>
>
>
>  What was the solution?  (Others might want to know)
>
>
>
>
> 
>

Re: [firebird-support] Wirecrypt

[Helen Borrie hele...@iinet.net.au [firebird-support]]

Wednesday, October 18, 2017, 9:52:36 AM, dferg...@gmail.com wrote:

> I am a newbie, like a total newbie just exploring databases for the
> first time.  I am using Lazarus and they all seem to prefer Firebird
> and lot of the documentation is geared that way.  I have
> successfully downloaded and installed Firebird onto ElementaryOS
> Loki.  I am trying to use DB Scema but can't connect to firebird
> from there.  I can connect to sqlite from dbscema and I can
>  connect  to firebird from Flamerobin.  I get the error:

> ncompatible wire encryption levels requested on client and server
> Incompatible wire encryption levels requested on client and server
> [SQLState:28000, ISC error code:335545064]
>
You CAN or you cannot connect from FlameRobin?

> I then followed these instruction and changed my firebird.conf file
> to "Wirecrypte = Enabled" as seen here:

Hopefully you didn't add that extraneous letter 'e' to the parameter
name.  And you removed the '#' character from that line.

>   - https://www.firebirdsql.org/ file/documentation/drivers_
> documentation/java/3.0.2/ release_notes.html#notes-on- firebird-3-support

If you want to enable wire encryption, you will need to have two
things in addition to enabling it in firebird.conf:

1.  the fbclient.so that comes with Firebird 3.  Older Firebird
versions do not support wire encryption.

2.  a language interface layer that knows about Fb3 wire encryption so
that the application can pass it in the API.

For FlameRobin, you need fbclient.so:  the 64-bit version if you are
using 64-bit FR;  otherwise, you need the 32-bit version.  You match
the bitness of the client to the bitness of your application, not the
bitness of the Firebird server.
Unfortunately, if you have installed the 64-bit Firebird server and
need the 32-bit client, you'll have to grab the x86 kit from the
download area and extract the client from it.  For some reason that
totally escapes me, we still do not provide any client-only kits in
the download area.

> But I still can't connect.  I also tested with DBerver but have the
> same problem.  I downloaded and installed the java driver to version
> 3.0.2.  But still no success at all.  I have no idea what t  o do. 
> All the programs I have tried to use to connect to Firebird don't
> work and they all tell me to come here.

You've named some applications I've never heard of.  Are you sure they
actually support Firebird?  If they claim to do so, check what driver
they need, e.g., ODBC, Python, etc.

In the case of Jaybird, you have both the client and the language
interface rolled into one.  Jaybird supports the API natively.
However, it appears Jaybird does not support wire encryption yet.  To
ask about that, subscribe to the firebird-java support list, see
https://www.firebirdsql.org/en/mailing-lists/

> I would attach the firebird.conf but there doesn't seem to be a way
> to do that.  the firebird conf that I found was in
> /etc/firebird/firebird3.0

The Firebird 3 installer script didn't put it there but possibly
FlameRobin or Jaybird did.  Some client interfaces need to read
firebird.conf.  It won't conflict with the server's firebird.conf, per
se, but it would pay to keep the one used by the client app consistent
with the one used by the server.

> I also found an other firebird.conf in  /opt/firebird/.

That's the one the installer put there.

> I h  ave no idea why there would be two of them.  I
> have only ever installed FB once.  I have tried changed the
> Wirecrypt on both, then on one then the other.

If you change a configuration setting you have to restart the Firebird
server, unless you are running Classic. (But, if you didn't change the
ServerMode parameter, then you are running Superserver and you DO need
that restart.)  If FR or another app is depending on the settings in
its own firebird.conf file then you;d probably need to restart that
app after changing that file, too.

Another possibility is that the FlameRobin package you installed is
pre-Firebird 3.0 and has installed an old fbclient.so in its WD.  So
check that as well.

I strongly recommend that you study the two PDF books in
/opt/firebird/doc.  There you have the Quick Start Guide and the
release notes.  Our release notes are very detailed.

Helen