Using Wide-Functions on unixODBC fails

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;

Using Wide-Functions on unixODBC fails

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;

Using Firebird ODBC in MS Word

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 AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar

Unable to insert into Blob from Alpha 5 v11

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

_______________________________________________
Firebird-odbc-devel mailing list
Firebird-odbc-devel@...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

Solution for 32Bit/64Bit mixed environment

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
imagine which idiot in Redmond let that pass. But, anyway, did anybody
of  you  stumble  across  some workaround, maybe involving some system
hacks?

I  frankly  do  not  even know where all the places are where some 3rd
party tool is making a call to a User-DSN. Users even can create their
own  Excel/LibreOffice/CrystalReport  connections based on an existing
User-DSN.

thanks,
André

------------------------------------------------------------------------------
Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester  
Wave(TM): Endpoint Security, Q1 2013 and "remains a good choice" in the  
endpoint security space. For insight on selecting the right partner to 
tackle endpoint security challenges, access the full report. 
http://p.sf.net/sfu/symantec-dev2dev

ODBC regsvr32 LoadLibrary not found

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

ODBC and Bigint in MS Access

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

--

-- 

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

unable to login to tracker.firebirdsql.org

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

------------------------------------------------------------------------------
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@...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

Connection failure

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

============================
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 geheimhoudingsplicht. Het
TweeSteden ziekenhuis is niet aansprakelijk voor schade ten gevolge van het gebruik van elektronische
middelen van communicatie, daaronder begrepen - maar niet beperkt tot - schade ten gevolge van niet
aflevering of vertraging bij de aflevering van elektronische berichten, onderschepping of
manipulatie van elektronische berichten door derden of door programmatuur/apparatuur gebruikt voor
elektronische communica
 tie en overbrenging van virussen en andere kwaadaardige programmatuur.

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

What do I do wrong with this ODBC-connection

BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:Peter Stalpers
TEL;WORK:013 4655692
ORG:;Apotheek 
TEL;PREF;FAX:013 4672819
EMAIL;WORK;PREF;NGW:pstalpers@...
N:Stalpers;Peter
TITLE:Stafmedewerker
END:VCARD

------------------------------------------------------------------------------
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@...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel