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

Re: [Firebird-odbc-devel] MS Access #deleted with varchar UTF8 primary key

[Jorge A. B. <li...@da...>]

Hi.

I´m using 2.0.3.154 odbc driver and a similar issue.

Was the patch merged into ODBC driver?

Thanks!

El 23/05/2011 08:50 a.m., Henner Kollmann escribió:
> This is a problem using UTF-8.
>
> It's described here:
>
> http://www.easysoft.com/support/kb/kb00929.html.
>
>
> I patched the driver source to return a SQL_C_CHAR instead of SQL_C_WCHAR
> and created a new MsVc90 project to generate an odbc driver named "Firebird
> driver for MS Access".
>
> This new driver works with MS Access 2003 and 2007 with Unicode databases.
>
> Regards,
> Henner
>
>> -----Ursprüngliche Nachricht-----
>> Von: Carsten Ulrich [mailto:Car...@mo...]
>> Gesendet: Mittwoch, 18. Mai 2011 15:50
>> An: fir...@li...
>> Betreff: [Firebird-odbc-devel] MS Access #deleted with varchar UTF8
> primary
>> key
>>
>> Hello,
>> I want to open a table where the primary key is a varchar(50) Column with
>> charset utf8. MS Access (2010) shows the Value #deleted for all columns.
> If I
>> change the charset of the primary key column to ISO8859_1 it works.
>>
>> I use ODBC driver version 2.00.00.151
>>
>> Thanks
>> Carsten
>>
>>
> ----------------------------------------------------------------------------
> --
>> What Every C/C++ and Fortran developer Should Know!
>> Read this article and learn how Intel has extended the reach of its next-
>> generation tools to help Windows* and Linux* C/C++ and Fortran developers
>> boost performance applications - including clusters.
>> http://p.sf.net/sfu/intel-dev2devmay
>> _______________________________________________
>> Firebird-odbc-devel mailing list
>> Fir...@li...
>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>
> ------------------------------------------------------------------------------
> What Every C/C++ and Fortran developer Should Know!
> Read this article and learn how Intel has extended the reach of its
> next-generation tools to help Windows* and Linux* C/C++ and Fortran
> developers boost performance applications - including clusters.
> http://p.sf.net/sfu/intel-dev2devmay
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>
>

-- 
Jorge Andrés Brugger
Departamento de Informática
DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
Comodoro Rivadavia, Chubut, Argentina
Teléfono (0297) 446-4444 int. 103
Correo electrónico: jbr...@da...
Website: www.dasu.com.ar

"No podemos resolver problemas pensando de la misma manera que cuando los creamos" (Albert Einstein)


--
Antes de imprimir este mensaje, piense si es verdaderamente necesario hacerlo.

[Firebird-odbc-devel] ODBC Driver 2.0.2 Problem with FB ODBC driver in case of unstable network

[Egor K. <pom...@gm...>]

Hello,

There is a bug http://tracker.firebirdsql.org/browse/ODBC-183

FB ODBC Driver crash in case of unstable network
Backtrace:























*#0 0x00007fffeda87885 in raise () from /lib64/libc.so.6 #1
0x00007fffeda89065 in abort () from /lib64/libc.so.6 #2 0x00007fffee34ea7d
in __gnu_cxx::__verbose_terminate_handler() () from
/usr/lib64/libstdc++.so.6 #3 0x00007fffee34cc06 in ?? () from
/usr/lib64/libstdc++.so.6 #4 0x00007fffee34bb99 in ?? () from
/usr/lib64/libstdc++.so.6 #5 0x00007fffee34c5f1 in __gxx_personality_v0 ()
from /usr/lib64/libstdc++.so.6 #6 0x00007fffede06323 in ?? () from
/lib64/libgcc_s.so.1 #7 0x00007fffede063f7 in _Unwind_Resume () from
/lib64/libgcc_s.so.1 #8 0x00007fffe2524836 in
IscDbcLibrary::IscResultSet::~IscResultSet() () from
/usr/lib64/libOdbcFb.so #9 0x00007fffe2514828 in
IscDbcLibrary::IscMetaDataResultSet::~IscMetaDataResultSet() () from
/usr/lib64/libOdbcFb.so #10 0x00007fffe251cf44 in
IscDbcLibrary::IscProceduresResultSet::~IscProceduresResultSet() () from
/usr/lib64/libOdbcFb.so #11 0x00007fffe251b471 in
IscDbcLibrary::IscConnection::getCountInputParamFromProcedure(char const*,
int&, int&, bool&) () from /usr/lib64/libOdbcFb.so #12 0x00007fffe251ac2a
in IscDbcLibrary::IscConnection::getNativeSql(char const*, int, char*, int,
int*) () from /usr/lib64/libOdbcFb.so #13 0x00007fffe257aeee in
OdbcJdbcLibrary::OdbcStatement::sqlPrepare(unsigned char*, int) () from
/usr/lib64/libOdbcFb.so #14 0x00007fffe254723f in SQLPrepare () from
/usr/lib64/libOdbcFb.so #15 0x00007fffec90f5df in SQLPrepare () from
/usr/lib64/libodbc.so.2 #16 0x00007ffff7bae60b in
odbc::PreparedStatement::_prepare (this=<value optimized out>) at
preparedstatement.cpp:86 #17 0x00007ffff7bae8c0 in
odbc::PreparedStatement::PreparedStatement (this=0x7e32e4e0, con=<value
optimized out>, hstmt=<value optimized out>, sql=<value optimized out>,
resultSetType=<value optimized out>, resultSetConcurrency=<value optimized
out>, defaultDirection=1) at preparedstatement.cpp:69 #18
0x00007ffff7ba4ad1 in odbc::Connection::prepareStatement (this=0x7dffa680,
sql="{ call SYS_ADD_STAT_COUNTER(?,?,?,?) };", resultSetType=0,
resultSetConcurrency=0) at connection.cpp:480 #19 0x0000000000470ab1 in
STAT::CfStatFBDBAppender::flushCounter (this=0xdb5140,
name="SOAPRA_sendAnswers", type=<value optimized out>, val="0") at
../../../viper/src/framework/statistics/CfStatFBDBAppender.cpp:218 #20
0x0000000000476ebc in STAT::CfStatistics::thread () at
../../../viper/src/framework/statistics/CfStatistics.cpp:470 #21
0x00007ffff7564aa3 in thread_proxy () from
/usr/local/lib/libboost_thread.so.1.51.0 #22 0x00007fffef0b07f1 in
start_thread () from /lib64/libpthread.so.0 #23 0x00007fffedb3a70d in clone
() from /lib64/libc.so.6 *

Stdout:

*terminate called after throwing an instance of
'IscDbcLibrary::SQLError'   what(): std::exception *

I've investigated a problem and I think that in
IscDbcLibrary::IscConnection::getCountInputParamFromProcedure function
exception is thrown and in the process of stack unwinding the second
exception is thrown in destuctor:



*IscResultSet::~IscResultSet() {      close(); } *

After this the program is terminated.
Help me, please, I must know if it is our problem or FB ODBC Driver problem.

Best Regards,
Egor Kromberg

Re: [Firebird-odbc-devel] ODBC Driver 2.0.3 COUNT Return Variable Type

[<jf...@ru...>]

Yes, and that's apparently came into play as a result of Firebird 3's change to return COUNT() as a BIGINT rather than integer.  So the ODBC driver is declared innocent.  Thanks to all for having helped figure out what's happening.

Jonathan Finch
Principal Consultant
Rushmore Information Services, LLC

> On December 3, 2014 at 3:42 PM "Walter R. Ojeda Valiente" <sis...@gm...> wrote:
> 
> 
> With Visual FoxPro, a column BIGINT is returned as type character, not as
> type integer.
> 
> But it can be easily converted to integer, with the VAL() function.
> 
> Greetings.
> 
> Walter.
> 
> 
> On Wed, Dec 3, 2014 at 4:02 PM, Dimitry Sibiryakov <sd...@ib...> wrote:
> 
> > 03.12.2014 20:40, jf...@ru... wrote:
> > > In my tests of SQL statements using ODBC driver version 2.0.3.154 with
> > the Firebird 3.0 Beta 1, COUNT(*) is apparently returning a character
> > variable.
> >
> >    It should return value of SQL_BIGINT or SQL_NUMERIC types. Perhaps,
> > your software is
> > not ready to work with these types and ask for conversion to text
> > internally?..
> >
> > --
> >    WBR, SD.
> >
> >
> > ------------------------------------------------------------------------------
> > Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> > from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> > with Interactivity, Sharing, Native Excel Exports, App Integration & more
> > Get technology previously reserved for billion-dollar corporations, FREE
> >
> > http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
> > _______________________________________________
> > Firebird-odbc-devel mailing list
> > Fir...@li...
> > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
> >
> ------------------------------------------------------------------------------
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREE
> http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk_______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

Re: [Firebird-odbc-devel] ODBC Driver 2.0.3 COUNT Return Variable Type

[Walter R. O. V. <sis...@gm...>]

With Visual FoxPro, a column BIGINT is returned as type character, not as
type integer.

But it can be easily converted to integer, with the VAL() function.

Greetings.

Walter.


On Wed, Dec 3, 2014 at 4:02 PM, Dimitry Sibiryakov <sd...@ib...> wrote:

> 03.12.2014 20:40, jf...@ru... wrote:
> > In my tests of SQL statements using ODBC driver version 2.0.3.154 with
> the Firebird 3.0 Beta 1, COUNT(*) is apparently returning a character
> variable.
>
>    It should return value of SQL_BIGINT or SQL_NUMERIC types. Perhaps,
> your software is
> not ready to work with these types and ask for conversion to text
> internally?..
>
> --
>    WBR, SD.
>
>
> ------------------------------------------------------------------------------
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREE
>
> http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>

Re: [Firebird-odbc-devel] ODBC Driver 2.0.3 COUNT Return Variable Type

[<jf...@ru...>]

Thanks for the quick reply.  If the driver is working as designed, then perhaps the issue is indeed with the client app's language.  I will test further.  In any case I know I can solve the problem by CASTING the returned variable to the type needed.

Jonathan Finch
Principal Consultant
Rushmore Information Services, LLC

> On December 3, 2014 at 3:02 PM Dimitry Sibiryakov <sd...@ib...> wrote:
> 
> 
> 03.12.2014 20:40, jf...@ru... wrote:
> > In my tests of SQL statements using ODBC driver version 2.0.3.154 with the Firebird 3.0 Beta 1, COUNT(*) is apparently returning a character variable.
> 
>    It should return value of SQL_BIGINT or SQL_NUMERIC types. Perhaps, your software is
> not ready to work with these types and ask for conversion to text internally?..
> 
> --
>    WBR, SD.
> 
> ------------------------------------------------------------------------------
> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
> with Interactivity, Sharing, Native Excel Exports, App Integration & more
> Get technology previously reserved for billion-dollar corporations, FREE
> http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

Re: [Firebird-odbc-devel] ODBC Driver 2.0.3 COUNT Return Variable Type

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

03.12.2014 20:40, jf...@ru... wrote:
> In my tests of SQL statements using ODBC driver version 2.0.3.154 with the Firebird 3.0 Beta 1, COUNT(*) is apparently returning a character variable.

   It should return value of SQL_BIGINT or SQL_NUMERIC types. Perhaps, your software is 
not ready to work with these types and ask for conversion to text internally?..

-- 
   WBR, SD.

[Firebird-odbc-devel] ODBC Driver 2.0.3 COUNT Return Variable Type

[<jf...@ru...>]

In my tests of SQL statements using ODBC driver version 2.0.3.154 with the Firebird 3.0 Beta 1, COUNT(*) is apparently returning a character variable.  This is causing some errors in my apps that have always expected COUNT to yield an integer, which is what version 2.0.2.153 of the driver returns, at least with Firebird 2.5 data bases.  Perhaps a driver change was made for consistency with other aggregate functions like SUM(), which did return a character under 2.02?  To get the integer my apps
expect, looks like I'd need to change numerous SQL commands to something like CAST(COUNT(*) AS INTEGER) AS TABLECOUNT.  Anyone else experienced this issue?

Jonathan Finch
Principal Consultant
Rushmore Information Services, LLC

Re: [Firebird-odbc-devel] firebird newbies question: firebird->odbc

[Jan B. <ja...@fl...>]

Thanks a lot, I am connected ;-) (BTW the next questions lurk beneath 
the surface :-D )

Regards, Jan

Am 14.10.2014 18:47, schrieb Woody:
> If you installed the 32 bit version ODBC, then you have to go to the 32 bit ODBC driver configuration of Windows by executing c:\windows\sysWOW64\odbcad32.exe on the run menu.
>
> If you use the control panel, you are using the 64 bit ODBC and it won’t work that way.
>
> HTH,
>
> Woody

[Firebird-odbc-devel] named parameters - have a chance?

[Oleg M. <o_m...@ma...>]

    Hi All.
I tried to migrate my project from (OLEDB) IBProvider to ODBC, but got a unresolvable problem: named parameters.
Many sources says "In ODBC, named parameters are used only in calls to stored procedures and cannot be used in other SQL statements."

http://msdn.microsoft.com/en-us/library/ms715435%28v=vs.85%29.aspx 
as example

May be it possible as undocumented feature, optionaly allowed?

Re: [Firebird-odbc-devel] firebird newbies question: firebird->odbc

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

If you installed the 32 bit version ODBC, then you have to go to the 32 bit ODBC driver configuration of Windows by executing c:\windows\sysWOW64\odbcad32.exe on the run menu.

If you use the control panel, you are using the 64 bit ODBC and it won’t work that way.

HTH,

Woody

From: Jan Bleiss 
Sent: Tuesday, October 14, 2014 11:36 AM
To: fir...@li... 
Subject: [Firebird-odbc-devel] firebird newbies question: firebird->odbc

Hi,

I installed firebird 2.5 (32 bit) and the 32-bit Frebird odbc driver local on my machine today. I have created two users and one database successful. Now I try to connect the database to odbc. I have opened the Windows odbc admin tool (Windows 8.1 64 bit). I added the DNS, the localisation of database, my users name and the password. When I click on "test connection" I get the message "open database D:\FSM-FIREBIRD\FSMDB.FDB failed". What could be the reason for that.

Thank you, kind regards
Jan 


--------------------------------------------------------------------------------
------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho 


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

Re: [Firebird-odbc-devel] Firebird ODBC 2.0.2.153 with Excel 2007

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

On 13.11.2013 0:50, Steve Boyd wrote:
> That fixed it. Thank you very much for your prompt response.
>
> I assume that this will get released as an installer image at some point?
Of course.

>
>
> On 11/12/13 2:42 PM, Alexander Potapchenko wrote:
>> I have attached 64-bit driver too.
>>
>> On 12.11.2013 22:50, Steve Boyd wrote:
>>> When I replace \windows\system32\odbcfb.dll with this one I can no 
>>> longer access the datasource at all. I get an DLL load error. Is the 
>>> supplied DLL the 32-bit or 64-bit version? If 32-bit, can I get the 
>>> 64-bit?
>>>
>>> Thanks
>>>
>>> On 11/12/13 1:10 PM, Alexander Potapchenko wrote:
>>>> Fixed.
>>>>
>>>> On 12.11.2013 19:18, Steve Boyd wrote:
>>>>> Done!
>>>>>
>>>>> On 11/11/13 3:27 PM, Alexander Potapchenko wrote:
>>>>>> When trying to retrieve data into Excel from a Firebird 2.5 
>>>>>> database using the Firebird ODBC driver V2.0.2.153 I get an error 
>>>>>> after I click OK on the Import Data dialogue. The error is:
>>>>>>
>>>>>> Dynamic SQL error
>>>>>> SQL error code = -104
>>>>>> Unknown token Line 1 column 27 '.'
>>>>>>
>>>>>> Since this clearly had something to do with the SELECT statement 
>>>>>> I tried clicking the Properties button on the Import Data 
>>>>>> dialogue. The SELECT statement generated by Excel is as follows:
>>>>>>
>>>>>> Select * from "Operations"."Accounts"
>>>>>>
>>>>>> where Operations in the ODBC data source name.
>>>>>>
>>>>>> The Firebird ODBC driver apparently doesn't like this very much 
>>>>>> since removing "Operations". from the query gets everything 
>>>>>> working. While this bit of manual command editing doesn't bother 
>>>>>> me overly much it would be a big issue to end users who are 
>>>>>> trying to pull their data into a spreadsheet.
>>>>>
>>>>>
>>>>>
>>>>> ------------------------------------------------------------------------
>>>>> <http://www.avast.com/> 	
>>>>>
>>>>> This email is free from viruses and malware because avast! 
>>>>> Antivirus <http://www.avast.com/> protection is active.
>>>>>
>>>>>
>>>>>
>>>>> ------------------------------------------------------------------------------
>>>>> November Webinars for C, C++, Fortran Developers
>>>>> Accelerate application performance with scalable programming models. Explore
>>>>> techniques for threading, error checking, porting, and tuning. Get the most
>>>>> from the latest Intel processors and coprocessors. See abstracts and register
>>>>> http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Firebird-odbc-devel mailing list
>>>>> Fir...@li...
>>>>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>>>>
>>>>
>>>> -- 
>>>> Alexander Potapchenko
>>>> Team leader
>>>> LASP Technologies, http://www.lasptech.ru
>>>>
>>>>
>>>> ------------------------------------------------------------------------------
>>>> November Webinars for C, C++, Fortran Developers
>>>> Accelerate application performance with scalable programming models. Explore
>>>> techniques for threading, error checking, porting, and tuning. Get the most
>>>> from the latest Intel processors and coprocessors. See abstracts and register
>>>> http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
>>>>
>>>>
>>>> _______________________________________________
>>>> Firebird-odbc-devel mailing list
>>>> Fir...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>>>
>>>
>>>
>>> ------------------------------------------------------------------------
>>> <http://www.avast.com/> 	
>>>
>>> This email is free from viruses and malware because avast! Antivirus 
>>> <http://www.avast.com/> protection is active.
>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> November Webinars for C, C++, Fortran Developers
>>> Accelerate application performance with scalable programming models. Explore
>>> techniques for threading, error checking, porting, and tuning. Get the most
>>> from the latest Intel processors and coprocessors. See abstracts and register
>>> http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
>>>
>>>
>>> _______________________________________________
>>> Firebird-odbc-devel mailing list
>>> Fir...@li...
>>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>>
>>
>> -- 
>> Alexander Potapchenko
>> Team leader
>> LASP Technologies, http://www.lasptech.ru
>>
>>
>> ------------------------------------------------------------------------------
>> DreamFactory - Open Source REST&  JSON Services for HTML5&  Native Apps
>> OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
>> Free app hosting. Or install the open source package on any LAMP server.
>> Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
>> http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
>>
>>
>> _______________________________________________
>> Firebird-odbc-devel mailing list
>> Fir...@li...
>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>
>
>
> ------------------------------------------------------------------------
> <http://www.avast.com/> 	
>
> This email is free from viruses and malware because avast! Antivirus 
> <http://www.avast.com/> protection is active.
>
>
>
> ------------------------------------------------------------------------------
> DreamFactory - Open Source REST&  JSON Services for HTML5&  Native Apps
> OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
> Free app hosting. Or install the open source package on any LAMP server.
> Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
> http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
>
>
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel


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

Re: [Firebird-odbc-devel] Firebird ODBC 2.0.2.153 with Excel 2007

[Steve B. <sbo...@gm...>]

That fixed it. Thank you very much for your prompt response.

I assume that this will get released as an installer image at some point?


On 11/12/13 2:42 PM, Alexander Potapchenko wrote:
> I have attached 64-bit driver too.
>
> On 12.11.2013 22:50, Steve Boyd wrote:
>> When I replace \windows\system32\odbcfb.dll with this one I can no 
>> longer access the datasource at all. I get an DLL load error. Is the 
>> supplied DLL the 32-bit or 64-bit version? If 32-bit, can I get the 
>> 64-bit?
>>
>> Thanks
>>
>> On 11/12/13 1:10 PM, Alexander Potapchenko wrote:
>>> Fixed.
>>>
>>> On 12.11.2013 19:18, Steve Boyd wrote:
>>>> Done!
>>>>
>>>> On 11/11/13 3:27 PM, Alexander Potapchenko wrote:
>>>>> When trying to retrieve data into Excel from a Firebird 2.5 
>>>>> database using the Firebird ODBC driver V2.0.2.153 I get an error 
>>>>> after I click OK on the Import Data dialogue. The error is:
>>>>>
>>>>> Dynamic SQL error
>>>>> SQL error code = -104
>>>>> Unknown token Line 1 column 27 '.'
>>>>>
>>>>> Since this clearly had something to do with the SELECT statement I 
>>>>> tried clicking the Properties button on the Import Data dialogue. 
>>>>> The SELECT statement generated by Excel is as follows:
>>>>>
>>>>> Select * from "Operations"."Accounts"
>>>>>
>>>>> where Operations in the ODBC data source name.
>>>>>
>>>>> The Firebird ODBC driver apparently doesn't like this very much 
>>>>> since removing "Operations". from the query gets everything 
>>>>> working. While this bit of manual command editing doesn't bother 
>>>>> me overly much it would be a big issue to end users who are trying 
>>>>> to pull their data into a spreadsheet.
>>>>
>>>>
>>>>
>>>> ------------------------------------------------------------------------
>>>> <http://www.avast.com/> 	
>>>>
>>>> This email is free from viruses and malware because avast! 
>>>> Antivirus <http://www.avast.com/> protection is active.
>>>>
>>>>
>>>>
>>>> ------------------------------------------------------------------------------
>>>> November Webinars for C, C++, Fortran Developers
>>>> Accelerate application performance with scalable programming models. Explore
>>>> techniques for threading, error checking, porting, and tuning. Get the most
>>>> from the latest Intel processors and coprocessors. See abstracts and register
>>>> http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
>>>>
>>>>
>>>> _______________________________________________
>>>> Firebird-odbc-devel mailing list
>>>> Fir...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>>>
>>>
>>> -- 
>>> Alexander Potapchenko
>>> Team leader
>>> LASP Technologies, http://www.lasptech.ru
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> November Webinars for C, C++, Fortran Developers
>>> Accelerate application performance with scalable programming models. Explore
>>> techniques for threading, error checking, porting, and tuning. Get the most
>>> from the latest Intel processors and coprocessors. See abstracts and register
>>> http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
>>>
>>>
>>> _______________________________________________
>>> Firebird-odbc-devel mailing list
>>> Fir...@li...
>>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>>
>>
>>
>> ------------------------------------------------------------------------
>> <http://www.avast.com/> 	
>>
>> This email is free from viruses and malware because avast! Antivirus 
>> <http://www.avast.com/> protection is active.
>>
>>
>>
>> ------------------------------------------------------------------------------
>> November Webinars for C, C++, Fortran Developers
>> Accelerate application performance with scalable programming models. Explore
>> techniques for threading, error checking, porting, and tuning. Get the most
>> from the latest Intel processors and coprocessors. See abstracts and register
>> http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
>>
>>
>> _______________________________________________
>> Firebird-odbc-devel mailing list
>> Fir...@li...
>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>
>
> -- 
> Alexander Potapchenko
> Team leader
> LASP Technologies, http://www.lasptech.ru
>
>
> ------------------------------------------------------------------------------
> DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
> OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
> Free app hosting. Or install the open source package on any LAMP server.
> Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
> http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
>
>
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel



---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

Re: [Firebird-odbc-devel] Firebird ODBC 2.0.2.153 with Excel 2007

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

I have attached 64-bit driver too.

On 12.11.2013 22:50, Steve Boyd wrote:
> When I replace \windows\system32\odbcfb.dll with this one I can no 
> longer access the datasource at all. I get an DLL load error. Is the 
> supplied DLL the 32-bit or 64-bit version? If 32-bit, can I get the 
> 64-bit?
>
> Thanks
>
> On 11/12/13 1:10 PM, Alexander Potapchenko wrote:
>> Fixed.
>>
>> On 12.11.2013 19:18, Steve Boyd wrote:
>>> Done!
>>>
>>> On 11/11/13 3:27 PM, Alexander Potapchenko wrote:
>>>> When trying to retrieve data into Excel from a Firebird 2.5 
>>>> database using the Firebird ODBC driver V2.0.2.153 I get an error 
>>>> after I click OK on the Import Data dialogue. The error is:
>>>>
>>>> Dynamic SQL error
>>>> SQL error code = -104
>>>> Unknown token Line 1 column 27 '.'
>>>>
>>>> Since this clearly had something to do with the SELECT statement I 
>>>> tried clicking the Properties button on the Import Data dialogue. 
>>>> The SELECT statement generated by Excel is as follows:
>>>>
>>>> Select * from "Operations"."Accounts"
>>>>
>>>> where Operations in the ODBC data source name.
>>>>
>>>> The Firebird ODBC driver apparently doesn't like this very much 
>>>> since removing "Operations". from the query gets everything 
>>>> working. While this bit of manual command editing doesn't bother me 
>>>> overly much it would be a big issue to end users who are trying to 
>>>> pull their data into a spreadsheet.
>>>
>>>
>>>
>>> ------------------------------------------------------------------------
>>> <http://www.avast.com/> 	
>>>
>>> This email is free from viruses and malware because avast! Antivirus 
>>> <http://www.avast.com/> protection is active.
>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> November Webinars for C, C++, Fortran Developers
>>> Accelerate application performance with scalable programming models. Explore
>>> techniques for threading, error checking, porting, and tuning. Get the most
>>> from the latest Intel processors and coprocessors. See abstracts and register
>>> http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
>>>
>>>
>>> _______________________________________________
>>> Firebird-odbc-devel mailing list
>>> Fir...@li...
>>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>>
>>
>> -- 
>> Alexander Potapchenko
>> Team leader
>> LASP Technologies, http://www.lasptech.ru
>>
>>
>> ------------------------------------------------------------------------------
>> November Webinars for C, C++, Fortran Developers
>> Accelerate application performance with scalable programming models. Explore
>> techniques for threading, error checking, porting, and tuning. Get the most
>> from the latest Intel processors and coprocessors. See abstracts and register
>> http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
>>
>>
>> _______________________________________________
>> Firebird-odbc-devel mailing list
>> Fir...@li...
>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>
>
>
> ------------------------------------------------------------------------
> <http://www.avast.com/> 	
>
> This email is free from viruses and malware because avast! Antivirus 
> <http://www.avast.com/> protection is active.
>
>
>
> ------------------------------------------------------------------------------
> November Webinars for C, C++, Fortran Developers
> Accelerate application performance with scalable programming models. Explore
> techniques for threading, error checking, porting, and tuning. Get the most
> from the latest Intel processors and coprocessors. See abstracts and register
> http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
>
>
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel


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

Re: [Firebird-odbc-devel] Firebird ODBC 2.0.2.153 with Excel 2007

[Steve B. <sbo...@gm...>]

When I replace \windows\system32\odbcfb.dll with this one I can no 
longer access the datasource at all. I get an DLL load error. Is the 
supplied DLL the 32-bit or 64-bit version? If 32-bit, can I get the 64-bit?

Thanks

On 11/12/13 1:10 PM, Alexander Potapchenko wrote:
> Fixed.
>
> On 12.11.2013 19:18, Steve Boyd wrote:
>> Done!
>>
>> On 11/11/13 3:27 PM, Alexander Potapchenko wrote:
>>> When trying to retrieve data into Excel from a Firebird 2.5 database 
>>> using the Firebird ODBC driver V2.0.2.153 I get an error after I 
>>> click OK on the Import Data dialogue. The error is:
>>>
>>> Dynamic SQL error
>>> SQL error code = -104
>>> Unknown token Line 1 column 27 '.'
>>>
>>> Since this clearly had something to do with the SELECT statement I 
>>> tried clicking the Properties button on the Import Data dialogue. 
>>> The SELECT statement generated by Excel is as follows:
>>>
>>> Select * from "Operations"."Accounts"
>>>
>>> where Operations in the ODBC data source name.
>>>
>>> The Firebird ODBC driver apparently doesn't like this very much 
>>> since removing "Operations". from the query gets everything working. 
>>> While this bit of manual command editing doesn't bother me overly 
>>> much it would be a big issue to end users who are trying to pull 
>>> their data into a spreadsheet.
>>
>>
>>
>> ------------------------------------------------------------------------
>> <http://www.avast.com/> 	
>>
>> This email is free from viruses and malware because avast! Antivirus 
>> <http://www.avast.com/> protection is active.
>>
>>
>>
>> ------------------------------------------------------------------------------
>> November Webinars for C, C++, Fortran Developers
>> Accelerate application performance with scalable programming models. Explore
>> techniques for threading, error checking, porting, and tuning. Get the most
>> from the latest Intel processors and coprocessors. See abstracts and register
>> http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
>>
>>
>> _______________________________________________
>> Firebird-odbc-devel mailing list
>> Fir...@li...
>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>
>
> -- 
> Alexander Potapchenko
> Team leader
> LASP Technologies, http://www.lasptech.ru
>
>
> ------------------------------------------------------------------------------
> November Webinars for C, C++, Fortran Developers
> Accelerate application performance with scalable programming models. Explore
> techniques for threading, error checking, porting, and tuning. Get the most
> from the latest Intel processors and coprocessors. See abstracts and register
> http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
>
>
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel



---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

Re: [Firebird-odbc-devel] Firebird ODBC 2.0.2.153 with Excel 2007

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

Fixed.

On 12.11.2013 19:18, Steve Boyd wrote:
> Done!
>
> On 11/11/13 3:27 PM, Alexander Potapchenko wrote:
>> When trying to retrieve data into Excel from a Firebird 2.5 database 
>> using the Firebird ODBC driver V2.0.2.153 I get an error after I 
>> click OK on the Import Data dialogue. The error is:
>>
>> Dynamic SQL error
>> SQL error code = -104
>> Unknown token Line 1 column 27 '.'
>>
>> Since this clearly had something to do with the SELECT statement I 
>> tried clicking the Properties button on the Import Data dialogue. The 
>> SELECT statement generated by Excel is as follows:
>>
>> Select * from "Operations"."Accounts"
>>
>> where Operations in the ODBC data source name.
>>
>> The Firebird ODBC driver apparently doesn't like this very much since 
>> removing "Operations". from the query gets everything working. While 
>> this bit of manual command editing doesn't bother me overly much it 
>> would be a big issue to end users who are trying to pull their data 
>> into a spreadsheet.
>
>
>
> ------------------------------------------------------------------------
> <http://www.avast.com/> 	
>
> This email is free from viruses and malware because avast! Antivirus 
> <http://www.avast.com/> protection is active.
>
>
>
> ------------------------------------------------------------------------------
> November Webinars for C, C++, Fortran Developers
> Accelerate application performance with scalable programming models. Explore
> techniques for threading, error checking, porting, and tuning. Get the most
> from the latest Intel processors and coprocessors. See abstracts and register
> http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
>
>
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel


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

Re: [Firebird-odbc-devel] FB3.0 and ODBC with boolean fields problem

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

ODBC driver does not support Firebird boolean type fully (only reading).

On 12.11.2013 11:27, liviuslivius wrote:
> Hi,
> i try current snapshot of ODBC driver and i have problem to insert 
> data with it to table with boolean fields
> is this ODBC driver problem or FB itself?
> With normal table without boolean all work ok.
> From application i get "conversion error from string "0"
> from trace i get this
> 2013-10-30T09:46:08.1990 (1724:01B63730) ERROR AT JStatement::execute
>  C:\FIREBIRDDB\TESTOWA.TEST (ATT_8, SYSDBA:NONE, NONE, TCPv4:192.168.16.1)
>  P:\RidoToFB\Win32\Debug\RIDO_To_FB.exe:9200
> 335544569 : Dynamic SQL Error
> 335544436 : SQL error code = -303
> 335544334 : conversion error from string "0"
> regards,
> Karol Bieniaszewski
>
>
> ------------------------------------------------------------------------------
> November Webinars for C, C++, Fortran Developers
> Accelerate application performance with scalable programming models. Explore
> techniques for threading, error checking, porting, and tuning. Get the most
> from the latest Intel processors and coprocessors. See abstracts and register
> http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
>
>
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel


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

[Firebird-odbc-devel] FB3.0 and ODBC with boolean fields problem

[liviuslivius <liv...@po...>]

Hi,
 
i try current snapshot of ODBC driver and i have problem to insert data with it to table with boolean fields
is this ODBC driver problem or FB itself?
With normal table without boolean all work ok.
 
>From application i get "conversion error from string "0"
 
from trace i get this
 
2013-10-30T09:46:08.1990 (1724:01B63730) ERROR AT JStatement::execute
 C:\FIREBIRDDB\TESTOWA.TEST (ATT_8, SYSDBA:NONE, NONE, TCPv4:192.168.16.1)
 P:\RidoToFB\Win32\Debug\RIDO_To_FB.exe:9200
335544569 : Dynamic SQL Error
335544436 : SQL error code = -303
335544334 : conversion error from string "0"
 
 
regards,
Karol Bieniaszewski

Re: [Firebird-odbc-devel] Firebird ODBC 2.0.2.153 with Excel 2007

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

Hi Steve,

It is a bug in the Firebird ODBC driver. Create issue in the bug tracker 
http://tracker.firebirdsql.org/browse/ODBC please.

On 11.11.2013 23:23, Steve Boyd wrote:
> When trying to retrieve data into Excel from a Firebird 2.5 database 
> using the Firebird ODBC driver V2.0.2.153 I get an error after I click 
> OK on the Import Data dialogue. The error is:
>
> Dynamic SQL error
> SQL error code = -104
> Unknown token Line 1 column 27 '.'
>
> Since this clearly had something to do with the SELECT statement I 
> tried clicking the Properties button on the Import Data dialogue. The 
> SELECT statement generated by Excel is as follows:
>
> Select * from "Operations"."Accounts"
>
> where Operations in the ODBC data source name.
>
> The Firebird ODBC driver apparently doesn't like this very much since 
> removing "Operations". from the query gets everything working. While 
> this bit of manual command editing doesn't bother me overly much it 
> would be a big issue to end users who are trying to pull their data 
> into a spreadsheet.
>
> Is there any chance that this peculiar SQL syntax could be recognized 
> by the ODBC driver?
>
> Thanks
>
>
>
>
> ------------------------------------------------------------------------
> <http://www.avast.com/> 	
>
> This email is free from viruses and malware because avast! Antivirus 
> <http://www.avast.com/> protection is active.
>
>
>
> ------------------------------------------------------------------------------
> November Webinars for C, C++, Fortran Developers
> Accelerate application performance with scalable programming models. Explore
> techniques for threading, error checking, porting, and tuning. Get the most
> from the latest Intel processors and coprocessors. See abstracts and register
> http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
>
>
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel


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

Re: [Firebird-odbc-devel] Odbc driver with support for FB3.0 Boolean

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

Hi,

Firebird ODBC driver 2.0.2 has minimal support for Boolean type.

On 24.10.2013 15:16, liviuslivius wrote:
> Hi,
> is somwhere version of ODBC driver whit Firebird 3.0 Boolean type support?
> regards,
> Karol Bieniaszewski
>
>
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
> the latest Intel processors and coprocessors. See abstracts and register>
> http://pubads.g.doubleclick.net/gampad/clk?id=60135991&iu=/4140/ostg.clktrk
>
>
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel


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

[Firebird-odbc-devel] Odbc driver with support for FB3.0 Boolean

[liviuslivius <liv...@po...>]

Hi,
 
is somwhere version of ODBC driver whit Firebird 3.0 Boolean type support?
 
regards,
Karol Bieniaszewski

Re: [Firebird-odbc-devel] SQLColumns() and transaction

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

I think such functions should start local transactions, but in current 
implementation that's not so.
You can add this issue into the bug tracker.

On 08.10.2013 12:24, Dimitry Sibiryakov wrote:
> 08.10.2013 9:21, Alexander Potapchenko wrote:
>> SQLColumns() gets data from system tables and it starts transaction of
>> course and therefore If auto-commit mode off, driver considers that this
>> transaction remains active.
>     But the question is whether it should start connection-wide transaction or a local one.
>

Re: [Firebird-odbc-devel] SQLColumns() and transaction

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

08.10.2013 9:21, Alexander Potapchenko wrote:
> SQLColumns() gets data from system tables and it starts transaction of
> course and therefore If auto-commit mode off, driver considers that this
> transaction remains active.

   But the question is whether it should start connection-wide transaction or a local one.

-- 
   WBR, SD.

Re: [Firebird-odbc-devel] SQLColumns() and transaction

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

Hi Dimitry,

SQLColumns() gets data from system tables and it starts transaction of 
course and therefore If auto-commit mode off, driver considers that this 
transaction remains active.

On 08.10.2013 1:04, Dimitry Sibiryakov wrote:
>     Should call of SQLColumns() start transaction?
>
>     I wonder because now with auto-commit mode off, this call_does_  start transaction and
> following call of SQLDisconnect() without SQLEndTran() return 25000 error code.
>     It is not clear for me from ODBC docs whether SQLColumns() is "an SQL statement that
> can be contained within a transaction" or not.

[Firebird-odbc-devel] SQLColumns() and transaction

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

   Hello, All.

   Should call of SQLColumns() start transaction?

   I wonder because now with auto-commit mode off, this call _does_ start transaction and 
following call of SQLDisconnect() without SQLEndTran() return 25000 error code.
   It is not clear for me from ODBC docs whether SQLColumns() is "an SQL statement that 
can be contained within a transaction" or not.

-- 
   WBR, SD.

Re: [Firebird-odbc-devel] ODBC to networked computer

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

At 10:05 a.m. 19/09/2013, Craig Fogg wrote:
>Friends,
>
>I have a database installed on a central computer 


>(not running a server OS) 

What does that mean, exactly?

>that I am trying to connect to two clients. 

Clients connect to databases, not the other way around.  And remote clients do so *only* through a running Firebird server.

>The database folder is 
>shared on the network as L:\database\  

Firebird is not a file-served system so this (purposely) will not work.

>All PC's are running Windows 7. 
>For one client simply connecting to L:\Database|{dbname} in the ODBC 
>configuration worked fine. 

Check that one again.  There's no reason it should work.

>For the other, I cannot connect no matter 
>what string I use. Following the Help documentation I have tried all 
>combinations suggested. But each time I cannot connect. Both client PC's 
>are running the same, newly updated 2.0.2.153 ODBC Driver. Any 
>suggestions?? 

The connection string is hostname:D:\path\to\database_file, where "D:" MUST BE the actual drive letter of a drive that is under the control of the machine that is running the Firebird server.  Better, use an alias for the "D:\path\to\database_file" segment.

That's TCP/IP protocol.  You could alternatively use Named Pipes protocol with a string like 

\\hostname\D:\path\to\database_file

Although valid, it is deprecated and is a noisy protocol.

>Why did L:{etc} work when this not documented as a valid 
>connect string/method? Something hiding in the code we don't know about?

It's not valid and it would be astonishing if it actually does work.  But if it really does then stop right now, as working with a database in any location that isn't under the control of Firebird's hosts is kamikaze.  (With a setting in firebird.conf, you can do it on some non-Windoze platforms, at your peril.)



Helen Borrie, Support Consultant, IBPhoenix (Pacific)
Author of "The Firebird Book" and "The Firebird Book Second Edition"
http://www.firebird-books.net
__________________________________________________________________