Re: [Firebird-odbc-devel] Fatal Memory Error

2021-05-14 Thread Dimitry Sibiryakov
14.05.2021 11:33, Dimitry Sibiryakov wrote: Delete headers sql*.h from them to make sure that system ones are used. Clarification: it must be only sql.h and sqlext.h. -- WBR, SD. ___ Firebird-odbc-devel mailing list Firebird-odbc-devel

Re: [Firebird-odbc-devel] Fatal Memory Error

2021-05-14 Thread Dimitry Sibiryakov
14.05.2021 00:04, Ken Hutchins wrote: Does anyone have any idea of how to make this work on Ubuntu Server 20 Build the driver from sources. Delete headers sql*.h from them to make sure that system ones are used. -- WBR, SD. ___ Firebird-odbc-

Re: [Firebird-odbc-devel] ODBC/JDBC

2020-07-10 Thread Dimitry Sibiryakov
10.07.2020 18:04, Paul Reeves wrote: I think JDBC was used as the inspiration for an OO wrapper around isc api. There is no other link with JDBC as far as I am aware. So the driver is a simple ODBC driver with some JDBC-like pieces used internally, nothing more? And it was never supposed to

[Firebird-odbc-devel] ODBC/JDBC

2020-07-10 Thread Dimitry Sibiryakov
Hello, All. Our driver claims to be ODBC/JDBC driver but did anyone used or tested its JDBC part? -- WBR, SD. ___ Firebird-odbc-devel mailing list Firebird-odbc-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-

[Firebird-odbc-devel] Source repository

2020-06-05 Thread Dimitry Sibiryakov
Hello, All. What is the official driver's source repository? Github or still Sourceforge? -- WBR, SD. ___ Firebird-odbc-devel mailing list Firebird-odbc-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-odbc-deve

Re: [Firebird-odbc-devel] Using the odbc driver on windows without installing it from a Delphi application

2019-03-15 Thread Dimitry Sibiryakov
15.03.2019 13:41, Stefan Genov via Firebird-odbc-devel wrote: Please help - is there a way to use the odbc driver on windows without installing it from a Delphi application. The simplest way for Delphi is to use direct access components and get rid of ODBC at all. -- WBR, SD. _

Re: [Firebird-odbc-devel] Access and DSN ODBC

2018-08-09 Thread Dimitry Sibiryakov
09.08.2018 14:44, Jorge Andrés Brugger wrote: "xnet://Global\FIREBIRD" It doesn't look like "remote (LAN) Firebird database". What version of fbclient.dll is used? -- WBR, SD. -- Check out the vibrant tech comm

Re: [Firebird-odbc-devel] Unable to complete network request im windows network

2018-07-24 Thread Dimitry Sibiryakov
24.07.2018 17:28, Helge Schild wrote: Is there a different firebird server for TCP/IP connections than for connections thru a local file path? The latter works fine. With Firebird 3 local file path in connection string usually end up in using embedded mode which don't need running server.

Re: [Firebird-odbc-devel] Unable to complete network request im windows network

2018-07-24 Thread Dimitry Sibiryakov
24.07.2018 14:17, Helge Schild wrote: What could be wrong? A lot of things. The most obvious one: Firebird server is not run. -- WBR, SD. -- Check out the vibrant tech community on one of the world's most engagin

Re: [Firebird-odbc-devel] issues with PowerBi (Microsoft) and firebird database

2018-05-28 Thread Dimitry Sibiryakov
28.05.2018 6:34, Matz Wentingmann wrote: The value SQL_CONVERT_GUID is expected with ODBC 3.x, but the driver does not know it. IIRC, Firebird ODBC supports ODBC v2 only. -- WBR, SD. -- Check out the vibrant tec

Re: [Firebird-odbc-devel] reading the just generated identity throws an exception

2018-05-14 Thread Dimitry Sibiryakov
14.05.2018 12:46, Michael von Boetticher wrote: I need to know the generated ID for further actions in other subtables. Has somebody the same issue and even better - a solution for this? Use INSERT RETURNING. -- WBR, SD. ---

Re: [Firebird-odbc-devel] MS Access 2016 crashing when using two Firebird ODBCs

2017-09-06 Thread Dimitry Sibiryakov
06.09.2017 13:23, Morten H Pedersen wrote: here is what I got debugging from Visual Studio: I see no sign of Firebird ODBC here. I think this is a question for MS support, not Firebird one. -- WBR, SD. -- Check

Re: [Firebird-odbc-devel] MS Access 2016 crashing when using two Firebird ODBCs

2017-09-06 Thread Dimitry Sibiryakov
06.09.2017 13:06, hoegge wrote: > When I link tables from more databases on same > server Access crashes all the time. Did you look at call stack on crash? -- WBR, SD. -- Check out the vibrant tech community on one

Re: [Firebird-odbc-devel] Question about ODBC SQLGetConnectAttr() call.

2016-11-17 Thread Dimitry Sibiryakov
17.11.2016 11:51, ML wrote: > It looks like the driver does not populate its database name attribute from > the connection > string. According to MSDN, it must not. But it must return SQL_NO_DATA. Register ticket in tracker, please. -- WBR, SD.

Re: [Firebird-odbc-devel] Question about ODBC SQLGetConnectAttr() call.

2016-11-16 Thread Dimitry Sibiryakov
16.11.2016 20:32, d4t4f...@gmail.com wrote: > I'm calling SQLGetConnectAttr() with the SQL_ATTR_CURRENT_CATALOG attribute, > but it does > not seem to return anything meaningful. Do you check its return value? It must be SQL_NO_DATA if you didn't call SQLSetConnectAttr() beforehand. --

Re: [Firebird-odbc-devel] Access odbc firebird

2016-11-08 Thread Dimitry Sibiryakov
08.11.2016 12:50, gmist...@gmail.com wrote: > ? tcip/IP string ? what do you mean ? > it like \\192.168.1.1\sharedfolder\data\file.FDB ? It like is written in Firebird Quick Start Guide and Language Reference. -- WBR, SD. -

Re: [Firebird-odbc-devel] Access odbc firebird

2016-11-08 Thread Dimitry Sibiryakov
08.11.2016 12:41, gmist...@gmail.com wrote: > I have installed firebird in local machine but the FDB file is on network > shared folder Firebird cannot work with databases on network folders. -- WBR, SD. -- Devel

Re: [Firebird-odbc-devel] Access odbc firebird

2016-11-08 Thread Dimitry Sibiryakov
08.11.2016 12:16, gmist...@gmail.com wrote: > the path are correct and the database is present > I don't understand Something may block named pipes. Try to use TCP/IP connection string. -- WBR, SD. -- Developer A

Re: [Firebird-odbc-devel] Access odbc firebird

2016-11-08 Thread Dimitry Sibiryakov
08.11.2016 11:35, gmist...@gmail.com wrote: > do you have a idea for this problem ? Yes: you must have Firbird server running on the host where database is. -- WBR, SD. -- Developer Access Program for Intel Xeon

Re: [Firebird-odbc-devel] SQL-Error using ODBC-Driver 2.0.4 and Crystal Reports 2016

2016-10-12 Thread Dimitry Sibiryakov
12.10.2016 16:04, Antonio Cambule (STÜBER SYSTEMS) wrote: > Any idea if this can be solved? Turn on server-side trace and see what is the real query after ODBC driver transformed ODBC join into ANSI join. Avoid mixing of these types of joins in one query. -- WBR, SD. --

Re: [Firebird-odbc-devel] ODBC-Problems

2016-05-12 Thread Dimitry Sibiryakov
12.05.2016 17:48, Olaf Kluge wrote: > Now, after we call a sp access gets not in every time the new records (the sp > inserts for > example one), only after the formular is closes (or the entire access), the > records will > be shown. This is obviously a problem with Access transactions handl

Re: [Firebird-odbc-devel] Problems with odbc and null fields ODBC Driver version 2.0.3.154

2016-03-09 Thread Dimitry Sibiryakov
09.03.2016 13:40, Lawrence Bridger wrote: > Please can anybody suggest a solution or advise me what I might be doing > incorrectly to > solve this? If you want a field to get default value, you must not mention the field in INSERT query. -- WBR, SD. -

Re: [Firebird-odbc-devel] Problem installing ODBC driver on CentOS 7 linux

2016-02-09 Thread Dimitry Sibiryakov
09.02.2016 20:40, Nagy Szilveszter wrote: > Now i have another error: sqltypes.h is missing. > > What package should i install to have it? http://xmodulo.com/how-to-find-what-package-file-belongs-to-on-centos-fedora.html -- WBR, SD. ---

Re: [Firebird-odbc-devel] Problem installing ODBC driver on CentOS 7 linux

2016-02-09 Thread Dimitry Sibiryakov
09.02.2016 1:17, Nagy Szilveszter wrote: > First i installed firebird-superserver, > ../../IscDbc/IscDbc.h:33:19: fatal error: ibase.h: No such file or directory Error is obviously telling that you either didn't install Firebird or CentOS package doesn't put headers into /usr/include. --

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

2014-12-03 Thread Dimitry Sibiryakov
03.12.2014 20:40, jfi...@rushmoreinfo.com 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

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

2013-10-08 Thread Dimitry Sibiryakov
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

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

2013-10-07 Thread Dimitry Sibiryakov
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(

Re: [Firebird-odbc-devel] SQLxxxW functions

2013-02-04 Thread Dimitry Sibiryakov
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 d

Re: [Firebird-odbc-devel] SQLxxxW functions

2013-02-04 Thread Dimitry Sibiryakov
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

Re: [Firebird-odbc-devel] Problems with PC clients

2012-11-29 Thread Dimitry Sibiryakov
29.11.2012 18:47, Steffen Heil (Mailinglisten) wrote: > Just make sure to check the correct msdn article. > NOT the references one. Huh? Do you know any difference in LoadLibrary() between Windows editions? -- WBR, SD. --

Re: [Firebird-odbc-devel] Problems with PC clients

2012-11-29 Thread Dimitry Sibiryakov
29.11.2012 18:12, Maury Markowitz wrote: > What is the "default accessible path" in this case? RTFM: http://msdn.microsoft.com/en-us/library/ms886736.aspx -- WBR, SD. -- Keep yourself connected to Go Parallel: VERIF

Re: [Firebird-odbc-devel] Problems with PC clients

2012-11-29 Thread Dimitry Sibiryakov
29.11.2012 17:45, Maury Markowitz wrote: > I changed the Client= to the path to the DLL on the local machine Install fbclient.dll to default accessible path using instclient and remove "Client" part from connection string at all. Every client machine must have firebird client properly inst

Re: [Firebird-odbc-devel] Execute Firebird procedure from Oracle

2011-08-11 Thread Dimitry Sibiryakov
11.08.2011 16:04, Buchas wrote: > It does not work. Oracle says "Table or view does not exist." Use DBMS_HS_PASSTHROUGH package. -- SY, SD. -- Get a FREE DOWNLOAD! and learn more about uberSVN rich system, user a