Menu
▾
▴
firebird-odbc-devel — All about development of Firebird ODBC driver donated by IBPhoenix
You can subscribe to this list here.
| 2001 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
(23) |
Sep
(6) |
Oct
(2) |
Nov
(2) |
Dec
(5) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2002 |
Jan
|
Feb
(14) |
Mar
(16) |
Apr
(14) |
May
(25) |
Jun
(38) |
Jul
(22) |
Aug
(39) |
Sep
(3) |
Oct
(13) |
Nov
(47) |
Dec
(3) |
| 2003 |
Jan
(38) |
Feb
(39) |
Mar
(24) |
Apr
(57) |
May
(30) |
Jun
|
Jul
(39) |
Aug
(90) |
Sep
(41) |
Oct
(141) |
Nov
(158) |
Dec
(137) |
| 2004 |
Jan
(86) |
Feb
(169) |
Mar
(100) |
Apr
(83) |
May
(94) |
Jun
(77) |
Jul
(85) |
Aug
(54) |
Sep
(45) |
Oct
(36) |
Nov
(42) |
Dec
(70) |
| 2005 |
Jan
(46) |
Feb
(44) |
Mar
(50) |
Apr
(73) |
May
(90) |
Jun
(87) |
Jul
(41) |
Aug
(47) |
Sep
(28) |
Oct
(23) |
Nov
(44) |
Dec
(81) |
| 2006 |
Jan
(21) |
Feb
(9) |
Mar
(82) |
Apr
(14) |
May
(109) |
Jun
(175) |
Jul
(188) |
Aug
(44) |
Sep
(5) |
Oct
(47) |
Nov
(15) |
Dec
(34) |
| 2007 |
Jan
(75) |
Feb
(24) |
Mar
(30) |
Apr
(4) |
May
(28) |
Jun
(9) |
Jul
(13) |
Aug
(13) |
Sep
(29) |
Oct
(15) |
Nov
(19) |
Dec
(12) |
| 2008 |
Jan
(7) |
Feb
(19) |
Mar
(1) |
Apr
(7) |
May
(13) |
Jun
(19) |
Jul
(17) |
Aug
(29) |
Sep
(15) |
Oct
(37) |
Nov
(18) |
Dec
(29) |
| 2009 |
Jan
(23) |
Feb
(12) |
Mar
(8) |
Apr
(16) |
May
(11) |
Jun
(1) |
Jul
(2) |
Aug
(1) |
Sep
|
Oct
(9) |
Nov
(17) |
Dec
(31) |
| 2010 |
Jan
(15) |
Feb
(5) |
Mar
(4) |
Apr
(8) |
May
(1) |
Jun
(5) |
Jul
(17) |
Aug
(2) |
Sep
(12) |
Oct
(33) |
Nov
(14) |
Dec
(24) |
| 2011 |
Jan
(11) |
Feb
(2) |
Mar
(34) |
Apr
(11) |
May
(12) |
Jun
(3) |
Jul
(6) |
Aug
(11) |
Sep
(10) |
Oct
(1) |
Nov
(8) |
Dec
|
| 2012 |
Jan
(16) |
Feb
(2) |
Mar
|
Apr
(2) |
May
(6) |
Jun
(2) |
Jul
(7) |
Aug
|
Sep
|
Oct
(7) |
Nov
(22) |
Dec
(2) |
| 2013 |
Jan
(1) |
Feb
(24) |
Mar
(15) |
Apr
(2) |
May
(3) |
Jun
|
Jul
(2) |
Aug
|
Sep
(2) |
Oct
(6) |
Nov
(10) |
Dec
|
| 2014 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(4) |
Nov
|
Dec
(5) |
| 2015 |
Jan
(1) |
Feb
(4) |
Mar
(3) |
Apr
(3) |
May
|
Jun
(3) |
Jul
(1) |
Aug
(2) |
Sep
|
Oct
|
Nov
|
Dec
(1) |
| 2016 |
Jan
(1) |
Feb
(9) |
Mar
(4) |
Apr
|
May
(6) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(7) |
Nov
(13) |
Dec
|
| 2017 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
(1) |
Aug
|
Sep
(12) |
Oct
(4) |
Nov
|
Dec
|
| 2018 |
Jan
(6) |
Feb
|
Mar
|
Apr
|
May
(6) |
Jun
|
Jul
(9) |
Aug
(4) |
Sep
(2) |
Oct
|
Nov
|
Dec
|
| 2019 |
Jan
(1) |
Feb
|
Mar
(4) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2020 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(2) |
Jul
(3) |
Aug
|
Sep
|
Oct
(3) |
Nov
|
Dec
|
| 2021 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(4) |
Jun
|
Jul
(2) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2023 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
| 2025 |
Jan
|
Feb
(2) |
Mar
|
Apr
(2) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Steve C. <ste...@sc...> - 2010-10-05 14:28:13
|
I guess this the source of the problem I had earlier this year. > I am using Perl on Linux (Kubuntu 9.10) with Firebird 2.1. I > wanted to use > ODBC, but in the end I gave up using it because I couldn't > get the DATE or > number formats to work. Instead I used the DBI::Interbase > driver, while it > works, it is subject to occasional crashes, so I'd like to go > back to trying > ODBC. I'd still like to use ODBC, but for the moment, I'm putting up with DBI. Do we have any idea when the next release will be available? If I can help with testing, I'd be happy to. Regards Steve |
|
From: bill l. <cbi...@gm...> - 2010-10-05 10:31:52
|
Втр, 05 Окт 2010, Alexander Potapchenko писал(а): > On 05.10.2010 13:28, bill lam wrote: > > Hi, is this driver still maintained? I also found other bugs but want a > > confirmation from maintainers before further reporting. > > > > Thanks. > > > Hi, this question is discussed now. > Most likely that I will develop the driver to final release 2.0 and then > I will work on version 2.1.. > Hi Alexander, I'm glad to hear this, thank you for your effect. I browsed the source and found it use long instead of int in various places, and assign sizeof(long) to buffer length for SQLINTEGER. Hopefully this and other 64-bit and unicode issues can be cleaned up. -- regards, ==================================================== GPG key 1024D/4434BAB3 2008-08-24 gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3 |
|
From: Alexander P. <ale...@gm...> - 2010-10-05 10:15:18
|
On 05.10.2010 13:28, bill lam wrote: > Hi, is this driver still maintained? I also found other bugs but want a > confirmation from maintainers before further reporting. > > Thanks. > Hi, this question is discussed now. Most likely that I will develop the driver to final release 2.0 and then I will work on version 2.1.. Best regards, Alexander -- Alexander Potapchenko Senior developer |
|
From: bill l. <cbi...@gm...> - 2010-10-05 09:28:48
|
Hi, is this driver still maintained? I also found other bugs but want a confirmation from maintainers before further reporting. Thanks. -- regards, ==================================================== GPG key 1024D/4434BAB3 2008-08-24 gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3 |
|
From: Michael M. <m.m...@mb...> - 2010-10-04 18:48:59
|
Maybe it helps if you replace IP or HOSTNAME of YOUR server with your
values! Its either the IP or the hostname of the server ;-)))
From: Ing. Alfredo Jimenez [mailto:sa...@gm...]
Sent: Monday, October 04, 2010 6:22 PM
To: fir...@li...
Subject: Re: [Firebird-odbc-devel] Hi I need help Firebird ODBC drivers
Thank you very much for the code, but not that I put in DbName
I get the following error:
-2147217843
[ODBC Firebird Driver] Unable to complete network request to host
"IPorHOSTNAMEofYOURserver."
Failed to locate host machine.
The name specified was not found in the hosts file or Domain Name Services.
This is the code I'm using
Function connect ()
ConFirebird As String Dim
ConDB As ADODB.Connection Dim
On Error GoTo out
conFirebird = "DRIVER = (Firebird / InterBase (r) driver);" & _
"Uid = SYSDBA;" & _
"Pwd = masterkey;" & _
"DIALECT = 3;" & _
"Dbname = IPorHOSTNAMEofYOURserver: \ \ PCDC02 \ Data \
DBNAME.FDB"
September conDB = New ADODB.Connection
conDB.CursorLocation = adUseClient
conFirebird conDB.Open
Exit Function
Output:
MsgBox Err.Description
End Function
2010/10/2 Michael Möhle <m.m...@mb...>
Hi Alfredo,
this way:
Dim conFirebird as string
conFirebird = "DRIVER={Firebird/InterBase(r) driver};" & _
"Uid=SYSDBA; " & _
"Pwd=YOURPASSWORD; " & _
"DIALECT=3;" & _
"DbName=IPorHOSTNAMEofYOURserver:C:\pathToYourDB\DBNAME.fdb"
Dim conDB as new ADODB.Connection
conDB.CursorLocation = adUseClient
conDB.Open conFirebird
DIALECT depends on your Database, newer ones should have DIALECT=3 older
ones coming from Interbase maybe have DIALECT=1
Br
Michael
From: Ing. Alfredo Jimenez [mailto:sa...@gm...]
Sent: Friday, October 01, 2010 5:09 PM
To: fir...@li...
Subject: [Firebird-odbc-devel] Hi I need help Firebird ODBC drivers
Hi I need help
Use Visual Basic and I need to create a connection via ODBC to a firebird
database 2.1,
as I can do it?
----------------------------------------------------------------------------
--
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
|
|
From: Ing. A. J. <sa...@gm...> - 2010-10-04 16:22:27
|
Thank you very much for the code, but not that I put in DbName
I get the following error:
*-2147217843*
*[ODBC Firebird Driver] Unable to complete network request to host
"IPorHOSTNAMEofYOURserver."
Failed to locate host machine.
The name specified was not found in the hosts file or Domain Name Services.*
This is the code I'm using
*Function connect ()
ConFirebird As String Dim
ConDB As ADODB.Connection Dim
On Error GoTo out
conFirebird = "DRIVER = (Firebird / InterBase (r) driver);" & _
"Uid = SYSDBA;" & _
"Pwd = masterkey;" & _
"DIALECT = 3;" & _
"Dbname = IPorHOSTNAMEofYOURserver: \ \ PCDC02 \ Data \
DBNAME.FDB"
September conDB = New ADODB.Connection
conDB.CursorLocation = adUseClient
conFirebird conDB.Open
Exit Function
Output:
MsgBox Err.Description
End Function*
2010/10/2 Michael Möhle <m.m...@mb...>
> Hi Alfredo,
>
>
>
> this way:
>
> Dim conFirebird as string
>
>
>
> conFirebird = "DRIVER={Firebird/InterBase(r) driver};" & _
>
> "Uid=SYSDBA; " & _
>
> "Pwd=YOURPASSWORD; " & _
>
> "DIALECT=3;" & _
>
>
> "DbName=IPorHOSTNAMEofYOURserver:C:\pathToYourDB\DBNAME.fdb"
>
>
>
> Dim conDB as new ADODB.Connection
>
>
>
> conDB.CursorLocation = adUseClient
>
> conDB.Open conFirebird
>
> DIALECT depends on your Database, newer ones should have DIALECT=3 older
> ones coming from Interbase maybe have DIALECT=1
>
>
>
> Br
>
> Michael
>
>
>
> *From:* Ing. Alfredo Jimenez [mailto:sa...@gm...]
> *Sent:* Friday, October 01, 2010 5:09 PM
> *To:* fir...@li...
> *Subject:* [Firebird-odbc-devel] Hi I need help Firebird ODBC drivers
>
>
>
> Hi I need help
> Use Visual Basic and I need to create a connection via ODBC to a firebird
> database 2.1,
> as I can do it?
>
>
> ------------------------------------------------------------------------------
> Start uncovering the many advantages of virtual appliances
> and start using them to simplify application deployment and
> accelerate your shift to cloud computing.
> http://p.sf.net/sfu/novell-sfdev2dev
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>
>
|
|
From: Michael M. <m.m...@mb...> - 2010-10-02 16:54:13
|
Hi Alfredo,
this way:
Dim conFirebird as string
conFirebird = "DRIVER={Firebird/InterBase(r) driver};" & _
"Uid=SYSDBA; " & _
"Pwd=YOURPASSWORD; " & _
"DIALECT=3;" & _
"DbName=IPorHOSTNAMEofYOURserver:C:\pathToYourDB\DBNAME.fdb"
Dim conDB as new ADODB.Connection
conDB.CursorLocation = adUseClient
conDB.Open conFirebird
DIALECT depends on your Database, newer ones should have DIALECT=3 older
ones coming from Interbase maybe have DIALECT=1
Br
Michael
From: Ing. Alfredo Jimenez [mailto:sa...@gm...]
Sent: Friday, October 01, 2010 5:09 PM
To: fir...@li...
Subject: [Firebird-odbc-devel] Hi I need help Firebird ODBC drivers
Hi I need help
Use Visual Basic and I need to create a connection via ODBC to a firebird
database 2.1,
as I can do it?
|
|
From: Ing. A. J. <sa...@gm...> - 2010-10-01 15:09:34
|
Hi I need help Use Visual Basic and I need to create a connection via ODBC to a firebird database 2.1, as I can do it? |
|
From: bill l. <cbi...@gm...> - 2010-10-01 14:28:49
|
Using the latest v.2 odbcfb driver against the same fb 2.5 server, I found the octet buffer length as reported by SqlDescribeCol for SQL_INTEGER is incorrect for the linux 64-bit odbcfb. It should be 4 (window version is correct) but it reported 8. When retrieving data using column binding, it actual fill 8 bytes or each SQL_INTEGER, with garbage in the upper 4 bytes. I also found the it failed to update correctly using sqlbindparameter for SQL_INTEGER, it did report any error but all field following the integer field were in fact not updated. It might related to this bug. No problem for the other 3 combinations: W64 W32 L32. window 64-bit driver +-----------+---------+-----------------+-----------+-------------+ |COLUMN_NAME|DATA_TYPE|TYPE_NAME |COLUMN_SIZE|BUFFER_LENGTH| +-----------+---------+-----------------+-----------+-------------+ |CODEN |4 |INTEGER |10 |4 | +-----------+---------+-----------------+-----------+-------------+ |DESCR1 |_9 |VARCHAR |10 |30 | +-----------+---------+-----------------+-----------+-------------+ |DESCR2 |_9 |VARCHAR |10 |30 | +-----------+---------+-----------------+-----------+-------------+ |TYPEN |4 |INTEGER |10 |4 | +-----------+---------+-----------------+-----------+-------------+ |MAXN |4 |INTEGER |10 |4 | +-----------+---------+-----------------+-----------+-------------+ |MEMO1 |_4 |BLOB SUB_TYPE BLR|2147483647 |2147483647 | +-----------+---------+-----------------+-----------+-------------+ linux 64-bit driver +-----------+---------+-----------------+-----------+-------------+ |COLUMN_NAME|DATA_TYPE|TYPE_NAME |COLUMN_SIZE|BUFFER_LENGTH| +-----------+---------+-----------------+-----------+-------------+ |CODEN |4 |INTEGER |10 |8 | +-----------+---------+-----------------+-----------+-------------+ |DESCR1 |_9 |VARCHAR |10 |30 | +-----------+---------+-----------------+-----------+-------------+ |DESCR2 |_9 |VARCHAR |10 |30 | +-----------+---------+-----------------+-----------+-------------+ |TYPEN |4 |INTEGER |10 |8 | +-----------+---------+-----------------+-----------+-------------+ |MAXN |4 |INTEGER |10 |8 | +-----------+---------+-----------------+-----------+-------------+ |MEMO1 |_4 |BLOB SUB_TYPE BLR|2147483647 |2147483647 | +-----------+---------+-----------------+-----------+-------------+ -- regards, ==================================================== GPG key 1024D/4434BAB3 2008-08-24 gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3 |
|
From: Michael M. <m.m...@mb...> - 2010-10-01 14:23:33
|
Which can be found under: C:\WINDOWS\SysWOW64\odbcad32.exe -----Original Message----- From: Dimitry Sibiryakov [mailto:sd...@ib...] Sent: Friday, October 01, 2010 1:32 PM To: fir...@li... Subject: Re: [Firebird-odbc-devel] Firebird ODBC drivers 01.10.2010 13:16, Pier Nardin wrote: > I have found that the 32 bit Firebird ODBC driver does not work on 64 bit Windows Server > 2008. Most likely you just failed to find 32bits ODBC manager. -- SY, SD. ---------------------------------------------------------------------------- -- Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev _______________________________________________ Firebird-odbc-devel mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel |
|
From: Dimitry S. <sd...@ib...> - 2010-10-01 11:33:04
|
01.10.2010 13:16, Pier Nardin wrote: > I have found that the 32 bit Firebird ODBC driver does not work on 64 bit Windows Server > 2008. Most likely you just failed to find 32bits ODBC manager. -- SY, SD. |
|
From: Pier N. <pi...@ra...> - 2010-10-01 11:18:29
|
I have found that the 32 bit Firebird ODBC driver does not work on 64 bit Windows Server 2008. I have been told on a Delphi newsgroup that Delphi will not work with 64 bit drivers. What can I do? Pier |
|
From: Kjell R. <kje...@da...> - 2010-09-20 08:03:27
|
Dimitry Sibiryakov skriver: > 20.09.2010 6:31, Kjell Rilbe wrote: >> So, then what does the "safe thread" option in the odbc driver add? > > Every API call is serialized using mutex. So, if you call routines from different > threads they won't work in parallel. Crystal clear! Thank you! Kjell -- -------------------------------------- Kjell Rilbe DataDIA AB E-post: kj...@da... Telefon: 08-761 06 55 Mobil: 0733-44 24 64 |
|
From: Dimitry S. <sd...@ib...> - 2010-09-20 07:42:08
|
20.09.2010 6:31, Kjell Rilbe wrote: > So, then what does the "safe thread" option in the odbc driver add? Every API call is serialized using mutex. So, if you call routines from different threads they won't work in parallel. -- SY, SD. |
|
From: Kjell R. <kje...@da...> - 2010-09-20 04:31:50
|
Yes, but that only confirms that the client library is thread safe in such a way that it works if you use separate connection(s) for each thread. So, then what does the "safe thread" option in the odbc driver add? Kjell Jorge Andrés Brugger skriver: > http://tech.dir.groups.yahoo.com/group/firebird-support/message/100655 > > El 17/09/2010 0:41, Kjell Rilbe escribió: >> OK, so what it means is that with "Safe thread" off, I can't even use >> one connection per thread? I was under the impression that fbclient *is* >> thread safe provided you use seperate connection(s) for each thread. Is >> this incorrect? >> >> Thanks, >> Kjell >> >> Jorge Andrés Brugger skriver: >>> It's very simple: ODBC driver does what fbclient doesn't. You develop >>> multi-thread apps (meaning "one connect by thread", not "one connection, >>> multiple threads using same connection)? Check the box "safe thread". >>> You dont? Dont check that box. >>> >>> Regards. >>> >>> El 16/09/2010 13:22, Kjell Rilbe escribió: >>>> Thanks Jorge, but I'm sorry to say that your reply didn't tell me anything. >>>> >>>> In what way does the option affect the behavior of the ODBC driver? >>>> What, exactly, can be done in the "on" mode that can't be done in the >>>> "off" mode? And vice versa? What are the pros and cons of each mode? >>>> >>>> I know very weel what threading is about and how you write threaded >>>> apps. I just don't know how this option affects the ODBC driver. I need >>>> to know that, to be able to use it correctly in case I want to use >>>> threads in my apps. >>>> >>>> Thanks, >>>> Kjell >>>> >>>> Jorge Andrés Brugger skriver: >>>>> It´s for multi-thread apps, like Clarion ones, because fbclient is not >>>>> thread-safe (until FB 2.1, I think F 2.5 fbclient is thread-safe) >>>>> >>>>> Regards >>>>> >>>>> El 02/09/2010 8:20, Kjell Rilbe escribió: >>>>>> Hi, >>>>>> >>>>>> What does the ODBC data source configuration option "safe thread" mean? >>>>>> It's a checkbox down to the left. >>>>>> >>>>>> I can't see that it's documented in the online help. >>>>>> >>>>>> Thanks, >>>>>> Kjell >>>>>> >>>>>> >>>>>> ------------------------------------------------------------------------------ >>>>>> Start uncovering the many advantages of virtual appliances >>>>>> and start using them to simplify application deployment and >>>>>> accelerate your shift to cloud computing. >>>>>> http://p.sf.net/sfu/novell-sfdev2dev >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Firebird-odbc-devel mailing list >>>>>> Fir...@li... >>>>>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >>>>> ------------------------------------------------------------------------------ >>>>> Start uncovering the many advantages of virtual appliances >>>>> and start using them to simplify application deployment and >>>>> accelerate your shift to cloud computing. >>>>> http://p.sf.net/sfu/novell-sfdev2dev >>>>> _______________________________________________ >>>>> Firebird-odbc-devel mailing list >>>>> Fir...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >>>>> . >>>>> >>> >>> ------------------------------------------------------------------------------ >>> Start uncovering the many advantages of virtual appliances >>> and start using them to simplify application deployment and >>> accelerate your shift to cloud computing. >>> http://p.sf.net/sfu/novell-sfdev2dev >>> _______________________________________________ >>> Firebird-odbc-devel mailing list >>> Fir...@li... >>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >>> . >>> > > > ------------------------------------------------------------------------------ > Start uncovering the many advantages of virtual appliances > and start using them to simplify application deployment and > accelerate your shift to cloud computing. > http://p.sf.net/sfu/novell-sfdev2dev > _______________________________________________ > Firebird-odbc-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > . > -- -------------------------------------- Kjell Rilbe DataDIA AB E-post: kj...@da... Telefon: 08-761 06 55 Mobil: 0733-44 24 64 |
|
From: Jorge A. B. <li...@da...> - 2010-09-17 16:20:55
|
http://tech.dir.groups.yahoo.com/group/firebird-support/message/100655 El 17/09/2010 0:41, Kjell Rilbe escribió: > OK, so what it means is that with "Safe thread" off, I can't even use > one connection per thread? I was under the impression that fbclient *is* > thread safe provided you use seperate connection(s) for each thread. Is > this incorrect? > > Thanks, > Kjell > > Jorge Andrés Brugger skriver: >> It's very simple: ODBC driver does what fbclient doesn't. You develop >> multi-thread apps (meaning "one connect by thread", not "one connection, >> multiple threads using same connection)? Check the box "safe thread". >> You dont? Dont check that box. >> >> Regards. >> >> El 16/09/2010 13:22, Kjell Rilbe escribió: >>> Thanks Jorge, but I'm sorry to say that your reply didn't tell me anything. >>> >>> In what way does the option affect the behavior of the ODBC driver? >>> What, exactly, can be done in the "on" mode that can't be done in the >>> "off" mode? And vice versa? What are the pros and cons of each mode? >>> >>> I know very weel what threading is about and how you write threaded >>> apps. I just don't know how this option affects the ODBC driver. I need >>> to know that, to be able to use it correctly in case I want to use >>> threads in my apps. >>> >>> Thanks, >>> Kjell >>> >>> Jorge Andrés Brugger skriver: >>>> It´s for multi-thread apps, like Clarion ones, because fbclient is not >>>> thread-safe (until FB 2.1, I think F 2.5 fbclient is thread-safe) >>>> >>>> Regards >>>> >>>> El 02/09/2010 8:20, Kjell Rilbe escribió: >>>>> Hi, >>>>> >>>>> What does the ODBC data source configuration option "safe thread" mean? >>>>> It's a checkbox down to the left. >>>>> >>>>> I can't see that it's documented in the online help. >>>>> >>>>> Thanks, >>>>> Kjell >>>>> >>>>> >>>>> ------------------------------------------------------------------------------ >>>>> Start uncovering the many advantages of virtual appliances >>>>> and start using them to simplify application deployment and >>>>> accelerate your shift to cloud computing. >>>>> http://p.sf.net/sfu/novell-sfdev2dev >>>>> >>>>> >>>>> _______________________________________________ >>>>> Firebird-odbc-devel mailing list >>>>> Fir...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >>>> ------------------------------------------------------------------------------ >>>> Start uncovering the many advantages of virtual appliances >>>> and start using them to simplify application deployment and >>>> accelerate your shift to cloud computing. >>>> http://p.sf.net/sfu/novell-sfdev2dev >>>> _______________________________________________ >>>> Firebird-odbc-devel mailing list >>>> Fir...@li... >>>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >>>> . >>>> >> >> ------------------------------------------------------------------------------ >> Start uncovering the many advantages of virtual appliances >> and start using them to simplify application deployment and >> accelerate your shift to cloud computing. >> http://p.sf.net/sfu/novell-sfdev2dev >> _______________________________________________ >> Firebird-odbc-devel mailing list >> Fir...@li... >> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >> . >> |
|
From: Kjell R. <kje...@da...> - 2010-09-17 03:41:28
|
OK, so what it means is that with "Safe thread" off, I can't even use one connection per thread? I was under the impression that fbclient *is* thread safe provided you use seperate connection(s) for each thread. Is this incorrect? Thanks, Kjell Jorge Andrés Brugger skriver: > It's very simple: ODBC driver does what fbclient doesn't. You develop > multi-thread apps (meaning "one connect by thread", not "one connection, > multiple threads using same connection)? Check the box "safe thread". > You dont? Dont check that box. > > Regards. > > El 16/09/2010 13:22, Kjell Rilbe escribió: >> Thanks Jorge, but I'm sorry to say that your reply didn't tell me anything. >> >> In what way does the option affect the behavior of the ODBC driver? >> What, exactly, can be done in the "on" mode that can't be done in the >> "off" mode? And vice versa? What are the pros and cons of each mode? >> >> I know very weel what threading is about and how you write threaded >> apps. I just don't know how this option affects the ODBC driver. I need >> to know that, to be able to use it correctly in case I want to use >> threads in my apps. >> >> Thanks, >> Kjell >> >> Jorge Andrés Brugger skriver: >>> It´s for multi-thread apps, like Clarion ones, because fbclient is not >>> thread-safe (until FB 2.1, I think F 2.5 fbclient is thread-safe) >>> >>> Regards >>> >>> El 02/09/2010 8:20, Kjell Rilbe escribió: >>>> Hi, >>>> >>>> What does the ODBC data source configuration option "safe thread" mean? >>>> It's a checkbox down to the left. >>>> >>>> I can't see that it's documented in the online help. >>>> >>>> Thanks, >>>> Kjell >>>> >>>> >>>> ------------------------------------------------------------------------------ >>>> Start uncovering the many advantages of virtual appliances >>>> and start using them to simplify application deployment and >>>> accelerate your shift to cloud computing. >>>> http://p.sf.net/sfu/novell-sfdev2dev >>>> >>>> >>>> _______________________________________________ >>>> Firebird-odbc-devel mailing list >>>> Fir...@li... >>>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >>> >>> ------------------------------------------------------------------------------ >>> Start uncovering the many advantages of virtual appliances >>> and start using them to simplify application deployment and >>> accelerate your shift to cloud computing. >>> http://p.sf.net/sfu/novell-sfdev2dev >>> _______________________________________________ >>> Firebird-odbc-devel mailing list >>> Fir...@li... >>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >>> . >>> > > > ------------------------------------------------------------------------------ > Start uncovering the many advantages of virtual appliances > and start using them to simplify application deployment and > accelerate your shift to cloud computing. > http://p.sf.net/sfu/novell-sfdev2dev > _______________________________________________ > Firebird-odbc-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > . > -- -------------------------------------- Kjell Rilbe DataDIA AB E-post: kj...@da... Telefon: 08-761 06 55 Mobil: 0733-44 24 64 |
|
From: Jorge A. B. <li...@da...> - 2010-09-16 16:45:38
|
It's very simple: ODBC driver does what fbclient doesn't. You develop multi-thread apps (meaning "one connect by thread", not "one connection, multiple threads using same connection)? Check the box "safe thread". You dont? Dont check that box. Regards. El 16/09/2010 13:22, Kjell Rilbe escribió: > Thanks Jorge, but I'm sorry to say that your reply didn't tell me anything. > > In what way does the option affect the behavior of the ODBC driver? > What, exactly, can be done in the "on" mode that can't be done in the > "off" mode? And vice versa? What are the pros and cons of each mode? > > I know very weel what threading is about and how you write threaded > apps. I just don't know how this option affects the ODBC driver. I need > to know that, to be able to use it correctly in case I want to use > threads in my apps. > > Thanks, > Kjell > > Jorge Andrés Brugger skriver: >> It´s for multi-thread apps, like Clarion ones, because fbclient is not >> thread-safe (until FB 2.1, I think F 2.5 fbclient is thread-safe) >> >> Regards >> >> El 02/09/2010 8:20, Kjell Rilbe escribió: >>> Hi, >>> >>> What does the ODBC data source configuration option "safe thread" mean? >>> It's a checkbox down to the left. >>> >>> I can't see that it's documented in the online help. >>> >>> Thanks, >>> Kjell >>> >>> >>> ------------------------------------------------------------------------------ >>> Start uncovering the many advantages of virtual appliances >>> and start using them to simplify application deployment and >>> accelerate your shift to cloud computing. >>> http://p.sf.net/sfu/novell-sfdev2dev >>> >>> >>> _______________________________________________ >>> Firebird-odbc-devel mailing list >>> Fir...@li... >>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >> >> ------------------------------------------------------------------------------ >> Start uncovering the many advantages of virtual appliances >> and start using them to simplify application deployment and >> accelerate your shift to cloud computing. >> http://p.sf.net/sfu/novell-sfdev2dev >> _______________________________________________ >> Firebird-odbc-devel mailing list >> Fir...@li... >> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >> . >> |
|
From: Kjell R. <kje...@da...> - 2010-09-16 16:22:26
|
Thanks Jorge, but I'm sorry to say that your reply didn't tell me anything. In what way does the option affect the behavior of the ODBC driver? What, exactly, can be done in the "on" mode that can't be done in the "off" mode? And vice versa? What are the pros and cons of each mode? I know very weel what threading is about and how you write threaded apps. I just don't know how this option affects the ODBC driver. I need to know that, to be able to use it correctly in case I want to use threads in my apps. Thanks, Kjell Jorge Andrés Brugger skriver: > It´s for multi-thread apps, like Clarion ones, because fbclient is not > thread-safe (until FB 2.1, I think F 2.5 fbclient is thread-safe) > > Regards > > El 02/09/2010 8:20, Kjell Rilbe escribió: >> Hi, >> >> What does the ODBC data source configuration option "safe thread" mean? >> It's a checkbox down to the left. >> >> I can't see that it's documented in the online help. >> >> Thanks, >> Kjell >> >> >> ------------------------------------------------------------------------------ >> Start uncovering the many advantages of virtual appliances >> and start using them to simplify application deployment and >> accelerate your shift to cloud computing. >> http://p.sf.net/sfu/novell-sfdev2dev >> >> >> _______________________________________________ >> Firebird-odbc-devel mailing list >> Fir...@li... >> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > > > ------------------------------------------------------------------------------ > Start uncovering the many advantages of virtual appliances > and start using them to simplify application deployment and > accelerate your shift to cloud computing. > http://p.sf.net/sfu/novell-sfdev2dev > _______________________________________________ > Firebird-odbc-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > . > -- -------------------------------------- Kjell Rilbe DataDIA AB E-post: kj...@da... Telefon: 08-761 06 55 Mobil: 0733-44 24 64 |
|
From: Jorge A. B. <li...@da...> - 2010-09-16 16:17:17
|
It´s for multi-thread apps, like Clarion ones, because fbclient is not thread-safe (until FB 2.1, I think F 2.5 fbclient is thread-safe) Regards El 02/09/2010 8:20, Kjell Rilbe escribió: > Hi, > > What does the ODBC data source configuration option "safe thread" mean? > It's a checkbox down to the left. > > I can't see that it's documented in the online help. > > Thanks, > Kjell > > > ------------------------------------------------------------------------------ > Start uncovering the many advantages of virtual appliances > and start using them to simplify application deployment and > accelerate your shift to cloud computing. > http://p.sf.net/sfu/novell-sfdev2dev > > > _______________________________________________ > Firebird-odbc-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel |
|
From: Kjell R. <kje...@da...> - 2010-09-09 14:02:28
|
Hi,
I just migrated a working ASP (not aspx) application from a 32 bit
Windows server to a Windows 2008 Wed 64 bit. Firebird 2.1.3.18185 64 bit
classic. ODBC driver Firebird_ODBC_2.0.0.148_x64.exe.
After the migration I have problems with null values. I have a select
that returns one row and in some columns it returns null. When I try to
access a null field's Value from VBScript I get an error.
Any ideas?
Here's a printout when I try to access all the Field object's properties
one by one:
Name: FirstName
ActualSize: Error 458: Variable uses an Automation type not supported in
VBScript
Attributes: 100
DefinedSize: 50
NumericScale: 255
OriginalValue: Error 3251: Current Recordset does not support updating.
This may be a limitation of the provider, or of the selected locktype.
Precision: 255
Status: 0
Type: 200
UnderlyingValue: Error 3251: Current provider does not support
refreshing underlying values.
Value: Error -2147217887: Multiple-step OLE DB operation generated
errors. Check each OLE DB status value, if available. No work was done.
ADO error info:
Description: Multiple-step OLE DB operation generated errors. Check
each OLE DB status value, if available. No work was done.
Help context: 0
Help file:
Native error: 0
Error number: -2147217887 (0x80040E21)
Error source: Microsoft OLE DB Provider for ODBC Drivers
SQL state:
Properties.Count: 20
Properties(0): BASECATALOGNAME =
Properties(1): BASECOLUMNNAME = FirstName
Properties(2): BASESCHEMANAME =
Properties(3): BASETABLENAME = Users
Properties(4): CLSID =
Properties(5): COLLATINGSEQUENCE =
Properties(6): COMPUTEMODE =
Properties(7): DATETIMEPRECISION =
Properties(8): DEFAULTVALUE =
Properties(9): DOMAINCATALOG =
Properties(10): DOMAINSCHEMA =
Properties(11): DOMAINNAME =
Properties(12): HASDEFAULT =
Properties(13): ISAUTOINCREMENT = False
Properties(14): ISCASESENSITIVE = True
Properties(15): ISSEARCHABLE = Error 458: Variable uses an Automation
type not supported in VBScript
Properties(16): ISUNIQUE =
Properties(17): OCTETLENGTH = 50
Properties(18): KEYCOLUMN = False
Properties(19): OPTIMIZE = False
Regards,
Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kj...@da...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
.
|
|
From: Kjell R. <kje...@da...> - 2010-09-09 13:45:32
|
Hi, I just migrated a working ASP (not aspx) application from a 32 bit Windows server to a Windows 2008 Wed 64 bit. Firebird 2.1.3.18185 64 bit classic. ODBC driver Firebird_ODBC_2.0.0.148_x64.exe. After the migration I have problems with null values. I have a select that returns one row and in some columns it returns null. When I try to access a null field's Value from VBScript I get an error. Any ideas? Here's a printout when I try to access all the Field object's properties one by one: Name: FirstName ActualSize: Error 458: Variable uses an Automation type not supported in VBScript Attributes: 100 DefinedSize: 50 NumericScale: 255 OriginalValue: Error 3251: Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype. Precision: 255 Status: 0 Type: 200 UnderlyingValue: Error 3251: Current provider does not support refreshing underlying values. Value: Error -2147217887: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. ADO error info: Description: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. Help context: 0 Help file: Native error: 0 Error number: -2147217887 (0x80040E21) Error source: Microsoft OLE DB Provider for ODBC Drivers SQL state: Properties.Count: 20 Properties(0): BASECATALOGNAME = Properties(1): BASECOLUMNNAME = FirstName Properties(2): BASESCHEMANAME = Properties(3): BASETABLENAME = Users Properties(4): CLSID = Properties(5): COLLATINGSEQUENCE = Properties(6): COMPUTEMODE = Properties(7): DATETIMEPRECISION = Properties(8): DEFAULTVALUE = Properties(9): DOMAINCATALOG = Properties(10): DOMAINSCHEMA = Properties(11): DOMAINNAME = Properties(12): HASDEFAULT = Properties(13): ISAUTOINCREMENT = False Properties(14): ISCASESENSITIVE = True Properties(15): ISSEARCHABLE = Error 458: Variable uses an Automation type not supported in VBScript Properties(16): ISUNIQUE = Properties(17): OCTETLENGTH = 50 Properties(18): KEYCOLUMN = False Properties(19): OPTIMIZE = False Regards, Kjell -- -------------------------------------- Kjell Rilbe DataDIA AB E-post: kj...@da... Telefon: 08-761 06 55 Mobil: 0733-44 24 64 |
|
From: Kjell R. <kje...@da...> - 2010-09-02 11:20:23
|
Hi, What does the ODBC data source configuration option "safe thread" mean? It's a checkbox down to the left. I can't see that it's documented in the online help. Thanks, Kjell -- ------------------------------ Kjell Rilbe DataDIA AB E-post: kje...@da... Telefon: 08-761 06 55 Mobil: 0733-44 24 64 |
|
From: Kjell R. <kje...@da...> - 2010-09-01 08:26:45
|
Hi, What does the ODBC data source configuration option "safe thread" mean? It's a checkbox down to the left. I can't see that it's documented in the online help. Thanks, Kjell -- ------------------------------ Kjell Rilbe DataDIA AB E-post: kje...@da... Telefon: 08-761 06 55 Mobil: 0733-44 24 64 |
|
From: Luis R. <lr...@gm...> - 2010-08-02 19:06:22
|
Hi all, I'm trying to connect to a FireBird 1.5 database with the IBPhoenix 2.0 ODBC driver and I keep getting "Open Database [DB Path] Failed" on test of connection. I've got a version 1.2 of this same driver, and it connects fine. I'm using all the same settings with the 2.0 one, but to no avail. The reason why I'm trying to upgrade is because the 1.2 version seems to have an issue with the .NET decimal type, it does not map the decimal type correctly (I've got a DECIMAL(12,4) field setup and the values in the DB for this field always have four zeros (0000) appended at the end. Thanks, -Luis |
71 messages has been excluded from this view by a project administrator.
