gmane.comp.db.firebird.net-provider

Using Wide-Functions on unixODBC fails

Daniel Vogelbacher — 2013-04-10T20:07:58

Hi,

when using the Firebird ODBC driver with unixODBC, the Wide-Functions
like SQLExecDirectW fails.

UnixODBC defines SQLWCHAR as a 2-Byte value. I've transformed my
wchar_t* strings to UCS2 and call SQLExecDirectW() with them.

Here is the trace (debug version):

----
SQLExecDirectW
Preparing statement:
        INSERT INTO FOO VALUES(NU
Preparing statement:
        INSERT INTO FOO VALUES(NU

HY000:1:-104:[ODBC Firebird Driver][Firebird]Dynamic SQL Error
SQL error code = -104
Unexpected end of command - line 1, column 24
----

It seems that something in the ODBC driver truncates the
statement to the half. A short look into the code shows this function
inside the ConvertingString template (MainUnicode.cpp):


        SQLCHAR * convUnicodeToString( SQLWCHAR *wcString, int length )
        {
                size_t bytesNeeded;
                wchar_t *ptEndWC = NULL;
                wchar_t saveWC;

                if ( length == SQL_NTS )
                        length = (int)wcslen( (const wchar_t*)wcString

Using Wide-Functions on unixODBC fails

Daniel Vogelbacher — 2013-04-10T19:58:17

Hi,

when using the Firebird ODBC driver with unixODBC, the Wide-Functions
like SQLExecDirectW fails.

UnixODBC defines SQLWCHAR as a 2-Byte value. I've transformed my
wchar_t* strings to UCS2 and call SQLExecDirectW() with them.

Here is the trace (debug version):

----
SQLExecDirectW
Preparing statement:
        INSERT INTO FOO VALUES(NU
Preparing statement:
        INSERT INTO FOO VALUES(NU

HY000:1:-104:[ODBC Firebird Driver][Firebird]Dynamic SQL Error
SQL error code = -104
Unexpected end of command - line 1, column 24
----

It seems that something in the ODBC driver truncates the
statement to the half. A short look into the code shows this function
inside the ConvertingString template (MainUnicode.cpp):


        SQLCHAR * convUnicodeToString( SQLWCHAR *wcString, int length )
        {
                size_t bytesNeeded;
                wchar_t *ptEndWC = NULL;
                wchar_t saveWC;

                if ( length == SQL_NTS )
                        length = (int)wcslen( (const wchar_t*)wcString

Re: Using Firebird ODBC in MS Word

Alexander Potapchenko — 2013-03-22T13:04:35

André,

Yes,  MS Word 2007 works fine with odbc driver 152.
No, I will not come to Luxemburg this year unfortunately :-)


Regards,
Alexander

Re: Using Firebird ODBC in MS Word

André Knappstein — 2013-03-22T12:52:00

houh, hough, hough... brrrr.

please accept my apologies for stealing your time.

I  remembered  that I can also make a "trace" of ODBC calls, something
that    Mr.    Tsvigun  once  used  to find and eliminate a problem in
the driver (around 2004).
While  trying to create the trace I saw that, for whatever reason I'll
never  understand,  I  had  installed  an outdated ODBC driver on this
machine.
Re-Installing  .152,  all seems to work fine. Please excuse me for the
trouble.  Will you come to Luxemburg this year? There are so many guys
here   I  am  owing  a round of best czech or belgian beer for all the
time I'm stealing from them, one more won't matter :-)










mit freundlichen Grüßen,

André Knappstein
EDV und Controlling
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH
Hafenweg 4
59192 Bergkamen-Rünthe

Telefon: +49 2389 9240 140
Telefax: +49 2389 9240 150
e-mail:  knappstein-hmoGJ7fHJEW4Zbc9CfNGILNAH6kLmebB< at >public.gmane.org

Re: Using Firebird ODBC in MS Word

André Knappstein — 2013-03-22T12:21:24

Alexander,

I  am  probably not too good in providing what you need to help me, so
if the following is not sufficient, please ask for more.

I  will  describe  the  steps leading to the error. I suppose that the
database  itself  and  the ODBC DSN are fine because they work well in
other applications.

1.) Open MSWord (2007) (SP3)
2.) Select tab "Mailings"
3.) Select "Select recipients" (or similar label...)
3.) Select "use an existing list"
4.) Select "New Datasource"
5.) Select "ODBC/DSN" from the list
6.) Select any valid ODBC-DSN pointing to any Firebird database

german   error  message:  Es  konnten  keine  Tabellenlisten  von  der
Datenquelle  bezogen  werden  (Unable  to retrieve table metadata from
data source)








mit freundlichen Grüßen,

André Knappstein
EDV und Controlling
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH
Hafenweg 4
59192 Bergkamen-Rünthe

Telefon: +49 2389 9240 140
Telefax: +49 2389 9240 150
e-mail:  k

Re: Using Firebird ODBC in MS Word

Alexander Potapchenko — 2013-03-21T20:23:41

Hi,

Tell in-depth information how to reproduce your problem please.

On 20.03.2013 17:28, André Knappstein wrote:

Re: Using Firebird ODBC in MS Word

André Knappstein — 2013-03-21T11:59:38


SYSDBA for the first test.



------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar

Re: Using Firebird ODBC in MS Word

Thomas Steinmaurer — 2013-03-20T19:20:11

What Firebird user are you using for connecting? Is it SYSDBA or the 
database owner?

Re: Using Firebird ODBC in MS Word

André Knappstein — 2013-03-20T14:24:20

Thanks for the reply, Maury.

Sorry for not specifying this from the beginning.
Problem is in 32-Bit-only OS, Win7.

Did not even try on 64-Bit

Did  try  with a locally installed 32-Bit 2.5 Superserver and a remote
1.5.6 Classic Server.












------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar

Re: Using Firebird ODBC in MS Word

Maury Markowitz — 2013-03-20T13:32:05

This may be a problem with 32-bit vs. 64-bit versions of the connector.

A number of components of the MS stack are still 32-bit only. This includes MS Query, and I believe may be true for VBA in general, or at least it's ADO resources.

You may wish to try installing both the 32-bit and 64-bit versions, making separate DSN's for them, and seeing if that helps.

On 2013-03-20, at 9:28 AM, André Knappstein wrote:



------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar

Using Firebird ODBC in MS Word

André Knappstein — 2013-03-20T13:28:30

Hi Gang!

Is  there  a  known technical reason why I can open literally any ODBC
driven data source in MS Word (2007 and higher), but *not* Firebird?

Do   I  have  to make any settings which escaped me so far, or will it
just  not  work  or  is the problem widely unknown so far? I'd like to
prepare   some   views  in  Firebird  and make them available for some
assistants (creating mail merges). 

There  is  no  problem  in  MS Excel (via MSQuery), but using the same
*.dqy  throws  "unable  to  connect to datasource: library 'C:\program
files\Firebi'   failed   to  load",  with  an  additional  information
"SQL-Status 08004, return code: SQL_ERROR".

Creating   a new connection throws "Unable to retrieve table metadata"
(original   in  German:  "Es  konnten  keine  Tabellenlisten  von  der
Datenquelle bezogen werden").

using driver .152

thanks for any hint.


------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with

Solution for 32Bit/64Bit mixed environment

André Knappstein — 2013-03-07T11:15:52

I know that this is problem caused by very bad design by MS.
But maybe someone already found a workaround and would share it here.

I  need  to call the same DSN sometimes from a 32-Bit application, and
sometimes  from  a  64-Bit  application. So I need a DSN with the same
name  once  created  with  the  32-Bit  ODBCAD32.exe and once with the
64-Bit ODBCAD32.exe.

One  therefore has to reference the 32-Bit version of FBClient.dll and
the other references the 64-Bit version.
No  problem  for  System DSNs.
The different settings do not mess with each other.

For  User-DSNs  though, you must decide whether a DSN is either 32- or
64-Bit  because  no matter which version of ODBCAD32.exe you are using
to  create/manage  the DSNs, they will both be stored in the very same
registry  key,  which  basically  means  that  any  setting  in either
ODBCAD32.exe will overwrite the other, and therefore the last selected
version of FBClient.dll will win.

Sounds  like  there is no solution for this, and I can't even start to

Re: ODBC regsvr32 LoadLibrary not found

Werner F. Bruhin — 2013-03-05T12:36:29

Hi,

Got a solution on the InnoSetup list.  I had a quote to many.

But I also learned about the "regserver" flag which is a much better way 
of handling the registration in an InnoSetup installer.

Werner

On 05/03/2013 13:19, Werner F. Bruhin wrote:

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb

ODBC regsvr32 LoadLibrary not found

Werner F. Bruhin — 2013-03-05T12:19:39

Hi,

I have an InnoSetup installer which installs besides by application also 
the FB ODBC driver, in case users want to access the db from e.g. 
LibreOffice.

On some machines I get the following error when the installer runs:

LoadLibrary(c:\windows\system32\odbcfb.dll -s) failed to load

On MS site a possible reason could be that a dependency is not present.

But I doubt that is the reason as when I run the following manually, it 
works.

regsvr32 c:\windows\system32\odbcfb.dll

Any pointers what might be wrong?

Werner

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb

Re: ODBC and Bigint in MS Access

W O — 2013-03-01T03:56:25

A similar problem happens with Visual FoxPro, the bigints fields of
Firebird are translated as character(19)

Why?

No idea, but so it is. The solution is easy, the VAL() function solves the
problem by casting the character(19) field to a numeric field, but at first
it is annoying.

I have to live with that.

Greetings.

Walter.




On Thu, Feb 28, 2013 at 4:41 AM, <bjoern.reimer-d40JDW7QUjc< at >public.gmane.org> wrote:

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb_______________________________________________
Firebird-odbc-devel mailing list
Firebird-odbc-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f< at >public.gmane.org
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

ODBC and Bigint in MS Access

2013-02-28T08:41:10

Hello,

  we  stepped  over  a  small  problem with current odbc driver and MS
  Access:

  BIGINT  (in  our  Db  primary keys) fields are presented as text 255
  fields in access.

  Trying  another  client  via odbc they are presented as flaot fields
  wich  seems to be a littel bit better than text 255 but not what I'd
  expect.

  Can  anybody give me the info where there could be a problem and how
  to get bigint as a number to access via odbc?

  There  must be  a  problem  in  Access  as I found people mentioning
  similar problems with MS SQL Server and Access.





    Björn

unable to login to tracker.firebirdsql.org

Jojakim — 2013-02-27T14:10:28

Hello,
In the past, I could login and use the firebird tracker w/o problem.
Today I wanted to login again, and the system told me, that I may not login
(no permission). Thought I used the wrong pwd, tried others, w/o success.
Clicked on "forgot pwd", entered email, and then the system showed an
exception message. Did not receive any email, tried again, now the system
tells me, user does not exist. Checked the buglist of the ODBC project where
I reported bugs recently: my clear name isn't shown any more, instead just my
login name.
Is there someone who can have a look on this please?
Thanks.
--
Joja


------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb

ODBC performance Firebird and Windows 7 X64

Olaf Kluge — 2013-02-27T09:15:34

Hello,

 

I use firebird 2.1 cs and the 32 Bit newest ODBC Driver on Windows 7 x64. If
I link my tables in ms access to my local database, it takes 4 seconds to
open a query. Now If I link the tables to our Server (same fb version
running), it takes one minute to open the same query. On Windows XP with the
same configuration It takes only 5 seconds.

 

What can I do? Perhaps it is possible to change some options on my odbc
driver? What is safe thread? Some identifiers options?

 

Thank you very much for hints and tips.

 

Best regards.

 

Olaf

 

 

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb_______________________________________________
Firebird-odbc-devel mailing list
Firebird-odbc-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f< at >public.gmane.org
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

Betr.: Re: Connection failure

Peter Stalpers — 2013-02-26T16:01:21

Thnx

<1356447022.20130226165812-hmoGJ7fHJEW4Zbc9CfNGILNAH6kLmebB< at >public.gmane.org> door André Knappstein
<Knappstein-hmoGJ7fHJEW4Zbc9CfNGILNAH6kLmebB< at >public.gmane.org> geschreven:
if you are not the SYSDBA, nor the owner:
you  must use a correct username and the corresponding password.
you can not change the privileges

if you are the owner:
you can change privileges using "Grant..." (see FB documentation)

if you are the SYSDBA:
you can even create new users

If  you  *are*  SYSDBA  and still have no luck, the original master of
that database might have locked out future/foreign SYSDBAs.

If  all  this  is  not  the  case  and you are indeed the one-and-only
SYSDBA,  check  if  you  used  capital  letters  for  logging into the
connection.
If  you  use  "sysdba"  instead  of "SYSDBA" you will not get an error
message,  but  will  be  assigned the privileges of "PUBLIC" (1.5.2, I
don't know if it is still the same today)


column.......(#-551)







kwaadaardige programmatuur.

---------------------------

Re: Connection failure

André Knappstein — 2013-02-26T15:58:12

if you are not the SYSDBA, nor the owner:
you  must use a correct username and the corresponding password.
you can not change the privileges

if you are the owner:
you can change privileges using "Grant..." (see FB documentation)

if you are the SYSDBA:
you can even create new users

If  you  *are*  SYSDBA  and still have no luck, the original master of
that database might have locked out future/foreign SYSDBAs.

If  all  this  is  not  the  case  and you are indeed the one-and-only
SYSDBA,  check  if  you  used  capital  letters  for  logging into the
connection.
If  you  use  "sysdba"  instead  of "SYSDBA" you will not get an error
message,  but  will  be  assigned the privileges of "PUBLIC" (1.5.2, I
don't know if it is still the same today)













mit freundlichen Grüßen,

André Knappstein
EDV und Controlling
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH
Hafenweg 4
59192 Bergkamen-Rünthe

Telefon: +49 2389 9240 140
Telefax

Connection failure

Peter Stalpers — 2013-02-26T14:21:06

I'm still a newby with firebird

After creating an ODBC-link between a firebird db and Access I linked the Firebird tables to an access-application.
When I try to open a table I get the message: [ODBC Firebird Driver][Firebird]no permission for read/select access to column.......(#-551)

I have got this message on each table I'll try to open.

How can I set the rights to read these files????

Met vriendelike groet,

Peter Stalpers

Systeem/Netwerkbeheer TweeSteden ziekenhuis / Stafmedewerker Informatisering Ziekenhuis Apotheek Midden-Brabant
Tel. + 31 (0) 13 46 55 692
PStalpers-Vb2TCoiMdgY< at >public.gmane.org


============================
De informatie verzonden met dit e-mailbericht (en bijlagen) is uitsluitend bestemd voor de geadresseerde(n) en zij die van de geadresseerde(n) toestemming hebben dit bericht te lezen. Gebruik door anderen dan geadresseerde(n) is verboden. De informatie in dit e-mailbericht (en bijlagen) kan vertrouwelijk van aard zijn en kan binnen het bereik vallen van een geheimhoudingsplic