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

[Firebird-odbc-devel] Betr.: Re: Connection failure

[Peter S. <pst...@ts...>]

Thnx

>>> Op Dinsdag 26 Februari 2013 om 16:58 is in bericht
<135...@be...> door André Knappstein
<Kna...@be...> 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)

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


> ============================
> 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 communicatie 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 
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li... 
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel 



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:  kna...@be... 

Amtsgericht Hamm Nr. B 420
Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus

USt-IDNr.: DE 125215402


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

========================================================
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 communicatie en overbrenging van virussen en andere kwaadaardige programmatuur.

Re: [Firebird-odbc-devel] Connection failure

[André K. <Kna...@be...>]

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)

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


> ============================
> 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 communicatie 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
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel



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:  kna...@be...

Amtsgericht Hamm Nr. B 420
Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus

USt-IDNr.: DE 125215402

[Firebird-odbc-devel] Connection failure

[Peter S. <pst...@ts...>]

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


============================
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 communicatie en overbrenging van virussen en andere kwaadaardige programmatuur.

Re: [Firebird-odbc-devel] Betr.: Re: What do I do wrong with thisODBC-connection

[Paul R. <pr...@ib...>]

On Friday 22 February 2013 16:37:14 Peter Stalpers wrote:
>
> Any suggestions??
>

Bitness often catches people out. You need to match the bitness of your client 
application on XP to the bitness of the ODBC driver. The fact that 1.5 on the 
server is 32-bit (and running on a 64-bit OS) has nothing to do with the 
client side.

And it doesn't help that MS hide the 32-bit ODBC client.

Just a thought.


Paul
-- 
Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird

Re: [Firebird-odbc-devel] Betr.: Re: What do I do wrong with thisODBC-connection

[B. S. <sc...@de...>]

hmmm..

his your username/password ok  ?
has the server process read/write access right to your database?

Viele Grüße,
B. Schulte

Am 22.02.2013 16:37, schrieb Peter Stalpers:
> Hi Bernhard,
>
> If I'm using "win-triakel01:D:\TestDbTriakel\TRIAKEL_TEST.FDB" and use the test connection-button I get the message:
>
> Open database 'win-triakel01:D:\TestDbTriakel\TRIAKEL_TEST.FDB' failed
>
> win-triakel01 is the servername
> D:\TestDbTriakel\TRIAKEL_TEST.FDB is the location and filename on that server.
>
> Any suggestions??
>
> best regards,
> Peter Stalpers
>
>
> Met vriendelike groet,
>
> Peter Stalpers
>
> Systeem/Netwerkbeheer TweeSteden ziekenhuis / Stafmedewerker Informatisering Ziekenhuis Apotheek Midden-Brabant
> Tel. + 31 (0) 13 46 55 692
> PSt...@ts...
>
>
>>>> "B. Schulte" <sc...@de...> 22-02-2013 16:01 >>>
> Hi Peter,
>
> I guess the database location i swrong:
>
> win-triakel01:TestDbTriakel:/Triakel_Test.fdb
>
> the correct syntax is:  [servername] : [localpath\to\your\database.fdb]
> Remember, that the local path is the path on your database server. It
> must not be a network drive.
>
> best regards
> Bernhard Schulte
>
> Am 22.02.2013 15:51, schrieb Peter Stalpers:
>> Location database is: win-triakel01:TestDbTriakel:/Triakel_Test.fdb
>
> ------------------------------------------------------------------------------
> 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
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>
>
> =====================================================
> 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 communicatie 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
>
>
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

[Firebird-odbc-devel] Betr.: Re: What do I do wrong with thisODBC-connection

[Peter S. <pst...@ts...>]

Hi Bernhard,

If I'm using "win-triakel01:D:\TestDbTriakel\TRIAKEL_TEST.FDB" and use the test connection-button I get the message:

Open database 'win-triakel01:D:\TestDbTriakel\TRIAKEL_TEST.FDB' failed

win-triakel01 is the servername
D:\TestDbTriakel\TRIAKEL_TEST.FDB is the location and filename on that server.

Any suggestions??

best regards,
Peter Stalpers


Met vriendelike groet,

Peter Stalpers

Systeem/Netwerkbeheer TweeSteden ziekenhuis / Stafmedewerker Informatisering Ziekenhuis Apotheek Midden-Brabant
Tel. + 31 (0) 13 46 55 692
PSt...@ts...


>>> "B. Schulte" <sc...@de...> 22-02-2013 16:01 >>>
Hi Peter,

I guess the database location i swrong:

win-triakel01:TestDbTriakel:/Triakel_Test.fdb

the correct syntax is:  [servername] : [localpath\to\your\database.fdb]
Remember, that the local path is the path on your database server. It 
must not be a network drive.

best regards
Bernhard Schulte

Am 22.02.2013 15:51, schrieb Peter Stalpers:
> Location database is: win-triakel01:TestDbTriakel:/Triakel_Test.fdb


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


============================
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 communicatie en overbrenging van virussen en andere kwaadaardige programmatuur.

Re: [Firebird-odbc-devel] What do I do wrong with this ODBC-connection

[B. S. <sc...@de...>]

Hi Peter,

I guess the database location i swrong:

win-triakel01:TestDbTriakel:/Triakel_Test.fdb

the correct syntax is:  [servername] : [localpath\to\your\database.fdb]
Remember, that the local path is the path on your database server. It 
must not be a network drive.

best regards
Bernhard Schulte

Am 22.02.2013 15:51, schrieb Peter Stalpers:
> Location database is: win-triakel01:TestDbTriakel:/Triakel_Test.fdb

[Firebird-odbc-devel] What do I do wrong with this ODBC-connection

[Peter S. <pst...@ts...>]

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:pst...@ts...
N:Stalpers;Peter
TITLE:Stafmedewerker
END:VCARD

Re: [Firebird-odbc-devel] special question Win 7 fb odbc

[Olaf K. <ola...@sa...>]

Hello Werner,

 

On 08/02/2013 08:50, Olaf Kluge wrote:

Hello,

 

I use firebird 2.1 32 Bit cs on Server 2008.

 

On my pc (Win 7 64 Bit) I have installed Access 2010 32 Bit and the Firebird
ODBC Driver 32 Bit. The Firebird Tables are linked to ms access. If I open a
Form with a query the first time, the records were displayed in a short
time. The second time it will take some more time. Other forms and querys
will be slower after this.

 

For example, in Windows XP with Access 2003 and the firebird odbc driver the
data are displayed much faster, every time!

 

If I install the Gemini ODBC Driver under Windows 7 64 Bit and with Access
2010, the records will open constant faster as with the firebird odbc
driver.

 

What can I do? I have check this with the last and the previous Version of
the firebird odbc driver. The Gemini driver will no longer be supported.

 

The extension of my database is gdb.

That is the first thing to change.  Use ".fdb" as is recommended in many
posts.  IIRC 'gdb' gets backed up by some windows "feature".

Werner

 

Yes, I know. The database extension is unchanged for 10 years. But now I
have change it for my test with exact the same result.

 

The queries are always slower even with this extension.

 

The newer Gemini driver (now tested) is slower than old but much faster than
the firebird odbc one.

 

Thanks for your help.

Re: [Firebird-odbc-devel] special question Win 7 fb odbc

[Werner F. B. <wer...@fr...>]

On 08/02/2013 08:50, Olaf Kluge wrote:
>
> Hello,
>
> I use firebird 2.1 32 Bit cs on Server 2008.
>
> On my pc (Win 7 64 Bit) I have installed Access 2010 32 Bit and the 
> Firebird ODBC Driver 32 Bit. The Firebird Tables are linked to ms 
> access. If I open a Form with a query the first time, the records were 
> displayed in a short time. The second time it will take some more 
> time. Other forms and querys will be slower after this.
>
> For example, in Windows XP with Access 2003 and the firebird odbc 
> driver the data are displayed much faster, every time!
>
> If I install the Gemini ODBC Driver under Windows 7 64 Bit and with 
> Access 2010, the records will open constant faster as with the 
> firebird odbc driver.
>
> What can I do? I have check this with the last and the previous 
> Version of the firebird odbc driver. The Gemini driver will no longer 
> be supported.
>
> The extension of my database is gdb.
>
That is the first thing to change.  Use ".fdb" as is recommended in many 
posts.  IIRC 'gdb' gets backed up by some windows "feature".

Werner

[Firebird-odbc-devel] special question Win 7 fb odbc

[Olaf K. <ola...@sa...>]

Hello,

 

I use firebird 2.1 32 Bit cs on Server 2008.

 

On my pc (Win 7 64 Bit) I have installed Access 2010 32 Bit and the Firebird
ODBC Driver 32 Bit. The Firebird Tables are linked to ms access. If I open a
Form with a query the first time, the records were displayed in a short
time. The second time it will take some more time. Other forms and querys
will be slower after this.

 

For example, in Windows XP with Access 2003 and the firebird odbc driver the
data are displayed much faster, every time!

 

If I install the Gemini ODBC Driver under Windows 7 64 Bit and with Access
2010, the records will open constant faster as with the firebird odbc
driver.

 

What can I do? I have check this with the last and the previous Version of
the firebird odbc driver. The Gemini driver will no longer be supported.

 

The extension of my database is gdb.

 

Thanks in advance.

 

Best regards.

 

Olaf

 

Re: [Firebird-odbc-devel] BLOB Text data codepage conversion for SQL_C_WCHAR

[Jojakim <joj...@jo...>]

On 07.02.2013 12:14:06, "Jojakim" wrote:
> ...But in the case of BLOB,
> subtype is not used to indicate the specified BLOB SUB_TYPE ...

Sorry, there is a typo: Must be:

But in the case of BLOB, subtype _is_ used to indicate the specified BLOB
SUB_TYPE

[Firebird-odbc-devel] BLOB Text data codepage conversion for SQL_C_WCHAR

[Jojakim <joj...@jo...>]

Dear specialists,
I need your advice for the following problem:

(see also http://tracker.firebirdsql.org/browse/ODBC-161)

I bound a BLOB SUB_TYPE 1 CHARACHTER SET UTF8 field to SQL_C_WCHAR /
SQL_LONGVARCHAR via SQLBindParameter on an insert operation. Then encountered
problems when using SQLPutData to put in my chardata. Connection charset is
UTF8.

1. I found, that in the IPD the concise type is set to SQL_C_BINARY. Is this
also a good/valid choice for BLOB SUB_TYPE 1, or for this BLOB type wouldn't
it be better to set it to SQL_C_CHAR?

2. The wcstombs and vice versa codepage translation function is setup with a
call to getAdressWcsToMbs / getAdressMbsToWcs which in turn passes
qlda->getSubType( index ) to adressWcsToMbs/adressMbsToWcs. For normal CHAR
or VARCHAR database fields, the subtype contains 3=UNICODE_FSS or 4=UTF8 or
in general I assume the fb charset id. But in the case of BLOB, subtype is
not used to indicate the specified BLOB SUB_TYPE (again, I can't prove but I
assume based on the values found while debugging). So my question is, how, in
case of a BLOB, I can find the fb charset id to use, and then make a link to
the correct codepage conversion function?

All thanks for your help !

--
Joja

Re: [Firebird-odbc-devel] SQLGetDescRecord usage

[Jojakim <joj...@jo...>]

I update myself :-)

MS states in the docu:
http://msdn.microsoft.com/en-us/library/windows/desktop/ms710188(v=vs.85).aspx

SQLDescribeParam returns the description of a parameter marker associated
with a prepared SQL statement. This information is also available in the
fields of the IPD.

That means, that the driver's SQLGetDescXXX function is buggy, at least for
the IPD case.

--
Joja

On 04.02.2013 12:31:49, "Jojakim" wrote:
> Dear all,
> Apparently, my first post on this subject didn't arrive in the list. So I
> try again.
> 
> I assumed, that SQLGetDescXXX functions are OBBC 3 replacements of i.e.
> SQLDescribeParam. Is this right, or, in ODBC 3 SQLDescribeParam is the
> right way to get parameter information on a prepared statement?
> 
> I tried to prepare "insert into x values (?,?,?)" and SQLGetDescRecord for
> an APD did return an error message (sqlstate=HY021, native=0, [ODBC
> Firebird Driver]Inconsistent descriptor information), and for an IPD did
> return unreasonable data. Is this correct behavior?
> 
> ---
> 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_jan
> 

Re: [Firebird-odbc-devel] SQLxxxW functions

[Tiesheng W. <t....@qm...>]

Sorry, I sent out the previous email by mistake.

-----Original Message-----
From: Tiesheng Wu [mailto:t....@qm...] 
Sent: 04 February 2013 11:01
To: fir...@li...
Subject: Re: [Firebird-odbc-devel] SQLxxxW functions

OK

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Tiesheng Wu
Computer Manager
Wolfson Institute of Preventive Medicine Queen Mary, University of London
Charterhouse Square London EC1M 6BQ
Tel: 020 7882 6285
Fax: 020 7882 6270
Email: t....@qm...
Web: http://www.wolfson.qmul.ac.uk/



-----Original Message-----
From: Dimitry Sibiryakov [mailto:sd...@ib...]
Sent: 04 February 2013 10:57
To: fir...@li...
Subject: Re: [Firebird-odbc-devel] SQLxxxW functions

04.02.2013 11:25, Jojakim wrote:
> What is the experts opinion on how octetLength, length, precision, 
> scale and displaySize should be handled, and what should they containg 
> depending on the FB data type?

   IMHO, standard description is quite clear. For string data length and
display size are size in characters while octet length is size in bytes.

-- 
   WBR, SD.

----------------------------------------------------------------------------
--
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_jan
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel


----------------------------------------------------------------------------
--
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_jan
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

[Firebird-odbc-devel] SQLGetDescRecord usage

[Jojakim <joj...@jo...>]

Dear all,
Apparently, my first post on this subject didn't arrive in the list. So I try
again.

I assumed, that SQLGetDescXXX functions are OBBC 3 replacements of i.e.
SQLDescribeParam. Is this right, or, in ODBC 3 SQLDescribeParam is the right
way to get parameter information on a prepared statement?

I tried to prepare "insert into x values (?,?,?)" and SQLGetDescRecord for an
APD did return an error message (sqlstate=HY021, native=0, [ODBC Firebird
Driver]Inconsistent descriptor information), and for an IPD did return
unreasonable data. Is this correct behavior?

--- 
Joja

Re: [Firebird-odbc-devel] SQLxxxW functions

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

04.02.2013 12:10, Jojakim wrote:
> But my question was, how these fields are (or should be) used in the driver
> sources. Is this like the standard, or do they have some internal meanings or
> special treatments in special cases. And how should they be set up from the
> FBs meta data info.

   It depends on coercion between FB data types and ODBC C-types. If, for example, 
SQL_VARYING is coerced to SQL_C_WCHAR, and FB character set is UTF8, octets length should 
be = sqllen/2, display length = sqllen/4. For single-byte character sets octets length = 
sqllen*2, display length = sqllen.
   Of course, all this in case if WCHAR is stay for UCS2. For UTF-16 I have no idea whet 
to do if some characters in FB data ends up in four bytes in UTF-16 and how to detect it.

-- 
   WBR, SD.

Re: [Firebird-odbc-devel] SQLxxxW functions

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

Hi,

The issues with these functions are unknown.
Add information how to reproduce issues into the Tracker - 
http://tracker.firebirdsql.org/browse/ODBC


On 04.02.2013 14:25, Jojakim wrote:
> Dear all - and especially the maintainer,
>
> I try to use the SQLxxxW functions and SQL_C_WCHAR type for accissing the
> driver and discovered problems with string data trucation etc.
>
> Are there knows issues with these functions?
>
> As, in the past, I already fixed minor problems in the driver, I wanted to
> fix this problem. After fixing (thought so at least) the string size
> calculation in OdbcStatement sqlPutData, I discovered other problems. When
> investigating the code, in my opinion there is an inconsistend handling of
> i.e. DescRecord length and octetLength fields.
>
> To understand the current implementation and what the ODBC standard requires,
> I started to implement a test suite. While doing this, I raised the
> SQLGetDescRecord question, which I already posted seperately.
>
> What is the experts opinion on how octetLength, length, precision, scale and
> displaySize should be handled, and what should they containg depending on the
> FB data type?
>
> Thank for any responses to help me understanding and perhaps fixing the
> driver.
>
> ---
> 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_jan
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

Re: [Firebird-odbc-devel] SQLxxxW functions

[Jojakim <joj...@jo...>]

On 04.02.2013 11:56:58, Dimitry Sibiryakov wrote:
> 04.02.2013 11:25, Jojakim wrote:
>> What is the experts opinion on how octetLength, length, precision, scale and
>> displaySize should be handled, and what should they containg depending on the
>> FB data type?
> 
> IMHO, standard description is quite clear. For string data length and
> display size are size in characters while octet length is size in bytes.
> 

That's right, ODBC standard defines are clear.

http://msdn.microsoft.com/en-us/library/windows/desktop/ms712499(v=vs.85).aspx

But my question was, how these fields are (or should be) used in the driver
sources. Is this like the standard, or do they have some internal meanings or
special treatments in special cases. And how should they be set up from the
FBs meta data info.

--
Joja

Re: [Firebird-odbc-devel] SQLxxxW functions

[Tiesheng W. <t....@qm...>]

OK

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Tiesheng Wu
Computer Manager
Wolfson Institute of Preventive Medicine
Queen Mary, University of London
Charterhouse Square
London EC1M 6BQ
Tel: 020 7882 6285
Fax: 020 7882 6270
Email: t....@qm...
Web: http://www.wolfson.qmul.ac.uk/



-----Original Message-----
From: Dimitry Sibiryakov [mailto:sd...@ib...] 
Sent: 04 February 2013 10:57
To: fir...@li...
Subject: Re: [Firebird-odbc-devel] SQLxxxW functions

04.02.2013 11:25, Jojakim wrote:
> What is the experts opinion on how octetLength, length, precision, 
> scale and displaySize should be handled, and what should they containg 
> depending on the FB data type?

   IMHO, standard description is quite clear. For string data length and
display size are size in characters while octet length is size in bytes.

-- 
   WBR, SD.

----------------------------------------------------------------------------
--
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_jan
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

Re: [Firebird-odbc-devel] SQLxxxW functions

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

04.02.2013 11:25, Jojakim wrote:
> What is the experts opinion on how octetLength, length, precision, scale and
> displaySize should be handled, and what should they containg depending on the
> FB data type?

   IMHO, standard description is quite clear. For string data length and display size are 
size in characters while octet length is size in bytes.

-- 
   WBR, SD.

[Firebird-odbc-devel] SQLxxxW functions

[Jojakim <joj...@jo...>]

Dear all - and especially the maintainer,

I try to use the SQLxxxW functions and SQL_C_WCHAR type for accissing the
driver and discovered problems with string data trucation etc.

Are there knows issues with these functions?

As, in the past, I already fixed minor problems in the driver, I wanted to
fix this problem. After fixing (thought so at least) the string size
calculation in OdbcStatement sqlPutData, I discovered other problems. When
investigating the code, in my opinion there is an inconsistend handling of
i.e. DescRecord length and octetLength fields.

To understand the current implementation and what the ODBC standard requires,
I started to implement a test suite. While doing this, I raised the
SQLGetDescRecord question, which I already posted seperately.

What is the experts opinion on how octetLength, length, precision, scale and
displaySize should be handled, and what should they containg depending on the
FB data type?

Thank for any responses to help me understanding and perhaps fixing the
driver.

---
Joja

[Firebird-odbc-devel] Open database '<database>.fdb' failed

[CRMScrum <jon...@ri...>]

Hi,

When I try to set up ODBC connection via "Firebird ODBC Setup" and click on
"Test connection", I receive error message that says "Open database
'<database location...>.fdb' failed" message.

I tried both remotely as well as from localhost and was NOT able to connect. 
I've followed the syntax for remote as well as localhost but still not able
to establish connection.  Port is default 3050 so I am not including port in
the string.

Does anyone know what might be causing this problem?  Could it be a naming
of the fdb?  Our fdb name has spaces (for example: "My First DB.fdb")





--
View this message in context: http://firebird.1100200.n4.nabble.com/Open-database-database-fdb-failed-tp4632722.html
Sent from the firebird-odbc-devel mailing list archive at Nabble.com.

Re: [Firebird-odbc-devel] reserved error (-7748)

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

Hi,

Is it your problem -  http://qc.embarcadero.com/wc/qcmain.aspx?d=108767 ?
If this is so, create the issue here - 
http://tracker.firebirdsql.org/browse/ODBC please.


On 04.12.2012 18:24, bjo...@fa... wrote:
> Hello,
>
>    when trying to link tables from an fb.2.5.2 database (UTF8!) via latest fb odbc driver (Firebird_ODBC_2.0.1.152_Win32.exe) and fb client libs (Firebird-2.5.2.26539_0_Win32.exe - all 32 bit) in an access database (Same result witch access 2003 and 2010) I'm getting a message that a reserved error (-7748) occurs.
>
>    Searching gives me one unanswered question on this list in 2004 and many google hits telling me to ad a reg-key in my odbc driver config called WorkArounds2 with a value of 8192 or some other values, e.g. 40960.
>
>    My question: Does the firebird odbc drivber support this workarround setting or has anyone a solution for me to get this running.
>
>
>    A final remark: Trying to access the tabeles in the firebird db via MS-Access direct queries works. So there can't be a problem with the setup.
>
>
>
>
>      Björn
>


-- 
Alexander Potapchenko
Team leader
LASP Technologies, http://www.lasptech.ru

[Firebird-odbc-devel] reserved error (-7748)

[<bjo...@fa...>]

Hello,

  when trying to link tables from an fb.2.5.2 database (UTF8!) via latest fb odbc driver (Firebird_ODBC_2.0.1.152_Win32.exe) and fb client libs (Firebird-2.5.2.26539_0_Win32.exe - all 32 bit) in an access database (Same result witch access 2003 and 2010) I'm getting a message that a reserved error (-7748) occurs.

  Searching gives me one unanswered question on this list in 2004 and many google hits telling me to ad a reg-key in my odbc driver config called WorkArounds2 with a value of 8192 or some other values, e.g. 40960.

  My question: Does the firebird odbc drivber support this workarround setting or has anyone a solution for me to get this running.


  A final remark: Trying to access the tabeles in the firebird db via MS-Access direct queries works. So there can't be a problem with the setup.




    Björn 

-- 
bjo...@fa...