firebird-odbc-devel — All about development of Firebird ODBC driver donated by IBPhoenix

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

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

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

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

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

[Firebird-odbc-devel] ODBC connection fails

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

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

Re: [Firebird-odbc-devel] ODBC Connection

[Woody <woo...@gt...>]

From: "Michael Möhle" <m.m...@mb...>

> Which setting do you use for the VM network?
> NAT or Bridged? If I remember it right, NAT will not
> Work, because VM and Host will have the same ip.
> Michael
>

VM and host have different IP's. As a matter of fact, the main computer has 
a static IP.

I believe my issue is related to the firewall in Windows 7 on my main 
machine. Turning it off allows the connection to go through. I recently 
updated to Windows 7 from XP Pro and I've found several things different 
regarding interoperability within my home network.

Thanks,

Woody (TMW) 

Re: [Firebird-odbc-devel] ODBC Connection

[Michael M. <m.m...@mb...>]

Which setting do you use for the VM network?
NAT or Bridged? If I remember it right, NAT will not
Work, because VM and Host will have the same ip.
Michael

-----Original Message-----
From: Woody [mailto:woo...@gt...] 
Sent: Wednesday, December 08, 2010 6:18 PM
To: fir...@li...
Subject: Re: [Firebird-odbc-devel] ODBC Connection

From: "Woody" <woo...@gt...>
>
> I know it can't work without a server. What I said was that connecting to
> the local server works fine, without specifying the client library. Trying
> to connect to a remote server doesn't work, with or without the client
> specified.
>

OK, after further searching and testing, apparently you still need to direct

the ODBC connection to the firebird client, which means it needs to be 
installed along with the ODBC driver, something I didn't know.

What was throwing me off when testing, if you put the client location in and

test the connection, it works. However, taking out the client location by 
deleting the entry, the connection still works so MS must be storing the 
location somewhere even though I removed it from the form. The only way to 
clear it is to totally exit the ODBC settings dialogs without saving 
anything. The next time you go to create a connection, you have to put the 
location in again the first time for even a local connection to work.

Now, on to my problem of connecting to a remote server (my main computer) 
from a client (in my VM). I seem to have lost my link totally now since even

IBOConsole won't work. Undoubtedly, my problem isn't related to the ODBC 
setup but rather has to do with my own internal issue.

Thanks all for listening and helping. Having never tried to use ODBC with 
Firebird, this was very enlightening for me. (I will post further if 
resolving my internal issue doesn't fix the problem.)

Woody (TMW) 


----------------------------------------------------------------------------
--
This SF Dev2Dev email is sponsored by:

WikiLeaks The End of the Free Internet
http://p.sf.net/sfu/therealnews-com
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

Re: [Firebird-odbc-devel] ODBC Connection

[Woody <woo...@gt...>]

From: "Woody" <woo...@gt...>
>
> I know it can't work without a server. What I said was that connecting to
> the local server works fine, without specifying the client library. Trying
> to connect to a remote server doesn't work, with or without the client
> specified.
>

OK, after further searching and testing, apparently you still need to direct 
the ODBC connection to the firebird client, which means it needs to be 
installed along with the ODBC driver, something I didn't know.

What was throwing me off when testing, if you put the client location in and 
test the connection, it works. However, taking out the client location by 
deleting the entry, the connection still works so MS must be storing the 
location somewhere even though I removed it from the form. The only way to 
clear it is to totally exit the ODBC settings dialogs without saving 
anything. The next time you go to create a connection, you have to put the 
location in again the first time for even a local connection to work.

Now, on to my problem of connecting to a remote server (my main computer) 
from a client (in my VM). I seem to have lost my link totally now since even 
IBOConsole won't work. Undoubtedly, my problem isn't related to the ODBC 
setup but rather has to do with my own internal issue.

Thanks all for listening and helping. Having never tried to use ODBC with 
Firebird, this was very enlightening for me. (I will post further if 
resolving my internal issue doesn't fix the problem.)

Woody (TMW) 

Re: [Firebird-odbc-devel] ODBC Connection

[Woody <woo...@gt...>]

From: "Dimitry Sibiryakov" <sd...@ib...>
> 08.12.2010 15:15, Woody wrote:
>> Do you actually need to the client when working through ODBC? I know that
>> using the local database, it works fine without the client setting.
>
>   Yes, FB client is required. No, ODBC driver cannot work with databases 
> without server.
>

I know it can't work without a server. What I said was that connecting to 
the local server works fine, without specifying the client library. Trying 
to connect to a remote server doesn't work, with or without the client 
specified.

Woody (TMW)
 

Re: [Firebird-odbc-devel] ODBC Connection

[Dimitry S. <sd...@ib...>]

08.12.2010 15:15, Woody wrote:
> Do you actually need to the client when working through ODBC? I know that
> using the local database, it works fine without the client setting.

   Yes, FB client is required. No, ODBC driver cannot work with databases without server.

-- 
   SY, SD.

Re: [Firebird-odbc-devel] ODBC Connection

[Woody <woo...@gt...>]

From: "Helen Borrie" <he...@ii...>
>
> Does your datasource setup look anything like this?
> Note, this connection is made using a database alias for that database on 
> the remote server.
>
> The client entry should point to fbclient.dll on the *client* computer.
> Emacs!
>

Looks about the same, Helen. I tried it with and without aliases, with and 
without the client setting.

Do you actually need to the client when working through ODBC? I know that 
using the local database, it works fine without the client setting.

Woody (TMW) 

Re: [Firebird-odbc-devel] OdbcFb.dll, RC2

[Alexander P. <ale...@gm...>]

On 08.12.2010 1:36, ld...@vo... wrote:
> Hi,
>
> A couple of questions:
>
> 1) Against what version of Firebird (headers and lib files) was RC2 built?
>      What are the implications of running against a different Firebird?
>      (I realize, for example, that if it's built against FB 2.1, functionality
>       new in FB 2.5 wouldn't be availble, but are there any other known
>       problems?)
ODBC driver uses Firebird 2.5 headers (ibase.h, iberror.h) but it does 
not use features which are various in different versions of the server.
> 2) I see that there's no OdbcFb.lib in the ZIP distribution. Is there one in
>      the Full Install?
Yes.

Regards,
Alexander

-- 
Alexander Potapchenko
Lead developer
LASP technology, http://www.lasptech.ru

Re: [Firebird-odbc-devel] ODBC Connection

[Woody <woo...@gt...>]

From: "Maya Opperman" <Ma...@om...>
>>>whether I need to supply more information?
>
> Got an error message?
>

I get a dialog that says Connection to <dbname> failed. That's it. I have 
tried several databases but none will connect.

Woody (TMW) 

Re: [Firebird-odbc-devel] ODBC Connection

[Maya O. <Ma...@om...>]

>>whether I need to supply more information?

Got an error message?

Re: [Firebird-odbc-devel] ODBC Connection

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

At 12:02 PM 8/12/2010, Woody wrote:
>Hello,
>
>Was directed here from firebird-support group.
>
>I've never connected to FB using ODBC so I downloaded the driver from the
>FirebirdSQL.org site and installed it in an XP virtual machine. My main
>machine is running FB SS 1.5 and using normal client connections
>(fbclient.dll) everything works fine.
>
>When trying to configure an ODBC connection through the Windows control
>panel, I can connect to the local (in the VM) FB server but it won't connect
>to my main computer FB server.
>
>I'm using the IP connection string format:
>
>    myserver:d:\databases\wonderware.fdb
>
>Windows firewall is turned off in the virtual machine. IBOConsole connects
>fine using normal client so I know everything is working normally. I just
>can't get the ODBC driver to connect.
>
>Any suggestions on what else I can try or whether I need to supply more
>information?

Does your datasource setup look anything like this? 
Note, this connection is made using a database alias for that database on the remote server. 

The client entry should point to fbclient.dll on the *client* computer.
Emacs!


The cursor in this screenshot is sitting on the "Test" button and the test was ok.

No drama, either, using dBrowser (free download from dbSoftlab, http://www.dbsoftlab.com/database-editors/database-browser/overview.html ).

Emacs!

I'm rather pleased with this. :-) My first test of Alexander's RC2, no dramas!

Helen

[Firebird-odbc-devel] ODBC Connection

[Woody <woo...@gt...>]

Hello,

Was directed here from firebird-support group.

I've never connected to FB using ODBC so I downloaded the driver from the
FirebirdSQL.org site and installed it in an XP virtual machine. My main
machine is running FB SS 1.5 and using normal client connections
(fbclient.dll) everything works fine.

When trying to configure an ODBC connection through the Windows control
panel, I can connect to the local (in the VM) FB server but it won't connect
to my main computer FB server.

I'm using the IP connection string format:

    myserver:d:\databases\wonderware.fdb

Windows firewall is turned off in the virtual machine. IBOConsole connects
fine using normal client so I know everything is working normally. I just
can't get the ODBC driver to connect.

Any suggestions on what else I can try or whether I need to supply more
information?

TIA

Woody (TMW) 

[Firebird-odbc-devel] OdbcFb.dll, RC2

[<ld...@vo...>]

Hi,

A couple of questions:

1) Against what version of Firebird (headers and lib files) was RC2 built?
    What are the implications of running against a different Firebird? 
    (I realize, for example, that if it's built against FB 2.1, functionality
     new in FB 2.5 wouldn't be availble, but are there any other known
     problems?)

2) I see that there's no OdbcFb.lib in the ZIP distribution. Is there one in 
    the Full Install?

Thanks very much in advance.

Regards,
Lee

Re: [Firebird-odbc-devel] Alpha Five v10 and ODBC Driver 2.00.00.150

[Alexander P. <ale...@gm...>]

On 28.11.2010 5:34, web...@rw... wrote:
>
> I am trying to use ODBC Driver 2.00.00.150 with Alpha Five v10 to 
> access a Firebird 2.5 database.
>
> I get the following error when trying to save data to the server...
>
> Server side error updating row.
>
> Database API specific error
>
> Your database has returned the following error code and description to 
> Alpha Five.
>
> Consult your database documentation for further information.
>
> -4 - '[ODBC Firebird Driver]Sqlda variable has zero length
>
> SQL State is: HY000'
>
> Refresh the data to see the current server values.
>
> Note that this same ODBC driver works perfectly with Access 2003.
>
> Is this a problem with the ODBC driver or Alpha Five?
>
> Thanks, Bob
>
>
Alpha Five generates SQL queryies such as:
"UPDATE COUNTRY SET CURRENCY = ? WHERE (COUNTRY = ?)  AND (CURRENCY = ? 
OR CURRENCY IS NULL AND *? IS NULL*)"
Firebird ODBC driver does not support such query now.

For resolving the problem you can change the following parameter in the 
Active-Link table settings:
Base update statement on: *Primary key only*
You can use Custom update query too.

Regards,
Alexander
-- 
Alexander Potapchenko
Lead developer
LASP technology, http://www.lasptech.ru

[Firebird-odbc-devel] Problems with MS Access and Unicode

[Henner K. <Hen...@gm...>]

Dear Alexander,

here is the patch file.

Best regards,
Henner Kollmann

Re: [Firebird-odbc-devel] connection pooling

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

At 07:29 PM 22/11/2010, Steffen Heil wrote:

>> The driver cannot make the database engine do things that are not defined
>> in the API.  ...
>
>May or may not be true.
>For example the JDBC driver supports updateable result sets that fwik are
>not supported by the API.

Usually, a *native* interface achieves this by holding a FOR UPDATE cursor open that is sychronized to the output that it holds in the buffer for the client. The Jaybird driver and the native IBObjects (for Delphi) are the only ones I know that do this currently.  A native interface is planned for Python, too. 

ODBC is the antithesis of a "native interface", in that it provides a lowest-common-denominator of functionality for multi-layered applications that want to treat divers data stores generically and independently of the application's host language.

>For the original question: Connection pooling *COULD* be done in the odbc
>layer, but I agree, that's not a good place for that.

The client layer is not the appropriate place for 2-tier apps but I think it should be feasible, at least, to incorporate an optional "uber-layer" with a connection-pooling interface for n-tier server applications to hook into.

Helen

Re: [Firebird-odbc-devel] connection pooling

[Steffen H. <li...@st...>]

Hi

> The driver cannot make the database engine do things that are not defined
> in the API.  ...

May or may not be true.
For example the JDBC driver supports updateable result sets that fwik are
not supported by the API.

For the original question: Connection pooling *COULD* be done in the odbc
layer, but I agree, that's not a good place for that.

Regards,
  Steffen

Re: [Firebird-odbc-devel] connection pooling

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

At 11:54 PM 19/11/2010, Chris Scott wrote:

>Hi Alexander, thanks for checking that.  We are using version 1.03.00.96 of the firebird odbc driver.  Is there a chance that this older version did use connection pooling?  If I reboot our firebird 1.5 server and then run an infoview report several fb_inet_server processes appear on the firebird server.
> 
>On 19.11.2010 3:18, Chris Scott wrote: 
>We have a server running SAP Crystal Server XI.  We use the program called infoview (web portal) to run crystal reports.  This connects to the firebird 1.5 database using an ODBC connection.  

Old Firebird version, very old ODBC driver version...see comment below.

>My understanding is that the firebird ODBC driver uses connection pooling.  Is it possible to configure the min and max connections in this connection pool?

Any ODBC driver is one component in a heavily layered scenario that, broadly, provides an interface between your client application and a database.  To do this, it implements "translations" of Firebird's API function calls and structures (which are in C language) into structures that are defined by the ODBC standard.  This translation, again broadly, allows application layers, written in a variety of host languages, to pass requests to the database engine and receive responses that they can understand and work with. 

The driver cannot make the database engine do things that are not defined in the API.  The API is pitched at one connection per database and the transactions and requests within that single connection context. 

If there is an application in the layering structure that wants to pool connections, that application would be written to manage multiple client connections in such a way that client instances could request a connection and be allocated one from a pool of available connections.  An "available connection" would be one instance of the database driver connected to one database and flagged as "not currently in use". In your setup, it is the InfoView software that is providing that pool-management layer.  

The Infoview pooling mechanism (if it really exists) would be creating, for each connection in the pool, one instance of the ODBC driver (client) connected to one fb_inet_server process - that is the Classic model of the Firebird engine.  If the ODBC driver never receives a detach_database call from the Infoview layer then none of those fb_inet_server processes will end.  The Infoview pooling mechanism *will* have some limit to the number of fb_inet_server instances it has running, along with some kind of configuration (in Infoview) that allows your installation to be limited to some maximum number of connections (processes) so as not to overwhelm your server's resources.

If the Infoview support people have told you something different then perhaps you have not spoken to the right people. 

Having said all that, I note that you are using both a very old version of Firebird and a very old version of the ODBC driver, with the Classic server model.  I hope you are not running the Guardian (fbguard.exe) with Classic.  If you are, then you have what was a known source of "ghost processes" when Firebird Classic was introduced for Windows and the early versions of the installer did not prevent you from installing Guardian with Classic.  Do that reality check if you have not already done so.  Take the Guardian right out of the picture:  it should not be there!

Helen

Re: [Firebird-odbc-devel] Problems with MS Access and Unicode

[Henner K. <Hen...@gm...>]

It's a patch for the current cvs version. I'll send you a patch tomorrow.

Regards
Henner

> -----Original Message-----
> From: Alexander Potapchenko [mailto:ale...@gm...]
> Sent: Sunday, November 21, 2010 8:44 PM
> To: fir...@li...
> Subject: Re: [Firebird-odbc-devel] Problems with MS Access and Unicode
> 
> On 21.11.2010 17:20, Henner Kollmann wrote:
> 
> 	Hello,
> 
> 	if you use the odbc driver with MS Access and UTF8 fields you
> always get a
> 	#deleted message.
> 	This described here:
> 
> 	http://www.easysoft.com/support/kb/kb00929.html.
> 
> 
> 	I patched the driver source to return a SQL_C_CHAR instead of
> SQL_C_WCHAR
> 	and created a new MsVc90 project to generate an odbc driver named
> "Firebird
> 	driver for MS Access".
> 
> 	This new driver works with MS Access 2003 and 2007 with Unicode
> databases.
> 
> 	Is anybody interested in this patch? How can I submit it?
> 
> 	Best regards,
> 	Henner
> 
> 
> Hi Henner,
> 
> I can look at your patch. You can send it me or publish it in the
> Firebird-odbc-devel mail list.
> Does your patch for sources of the ODBC driver 2.0 RC2 ?
> 
> Regards
> Alexander
> 
> --
> 
> Alexander Potapchenko
> 

Re: [Firebird-odbc-devel] Problems with MS Access and Unicode

[Alexander P. <ale...@gm...>]

On 21.11.2010 17:20, Henner Kollmann wrote:
> Hello,
>
> if you use the odbc driver with MS Access and UTF8 fields you always get a
> #deleted message.
> This described here:
>
> http://www.easysoft.com/support/kb/kb00929.html.
>
>
> I patched the driver source to return a SQL_C_CHAR instead of SQL_C_WCHAR
> and created a new MsVc90 project to generate an odbc driver named "Firebird
> driver for MS Access".
>
> This new driver works with MS Access 2003 and 2007 with Unicode databases.
>
> Is anybody interested in this patch? How can I submit it?
>
> Best regards,
> Henner
>
Hi Henner,

I can look at your patch. You can send it me or publish it in the 
Firebird-odbc-devel mail list.
Does your patch for sources of the ODBC driver 2.0 RC2 ?

Regards
Alexander
-- 
Alexander Potapchenko

[Firebird-odbc-devel] Problems with MS Access and Unicode

[Henner K. <Hen...@gm...>]

Hello,

if you use the odbc driver with MS Access and UTF8 fields you always get a
#deleted message.
This described here:

http://www.easysoft.com/support/kb/kb00929.html.


I patched the driver source to return a SQL_C_CHAR instead of SQL_C_WCHAR
and created a new MsVc90 project to generate an odbc driver named "Firebird
driver for MS Access". 

This new driver works with MS Access 2003 and 2007 with Unicode databases.

Is anybody interested in this patch? How can I submit it?

Best regards,
Henner

Re: [Firebird-odbc-devel] connection pooling

[Chris S. <CS...@sg...>]

Hi Alexander, thanks for checking that.  We are using version 1.03.00.96 of the firebird odbc driver.  Is there a chance that this older version did use connection pooling?  If I reboot our firebird 1.5 server and then run an infoview report several fb_inet_server processes appear on the firebird server.

From: Alexander Potapchenko [mailto:ale...@gm...]
Sent: Friday, 19 November 2010 9:46 PM
To: fir...@li...
Subject: Re: [Firebird-odbc-devel] connection pooling

On 19.11.2010 3:18, Chris Scott wrote:
We have a server running SAP Crystal Server XI.  We use the program called infoview (web portal) to run crystal reports.  This connects to the firebird 1.5 database using an ODBC connection.  My understanding is that the firebird ODBC driver uses connection pooling.  Is it possible to configure the min and max connections in this connection pool?

I have looked at the source code. Firebird ODBC driver doesn't use connection pooling apparently.
--
Regards,
Alexander Potapchenko