Re: [Firebird-devel] Firebird on Android + Delphi + Firedac - numerics issue
Did you try to fetch numerics using isql? i do not know how to run isql on Android Can you attach from your application to remote host? If yes what does happen with numerics in that case? I have tried without success. i have tried by TCP/IP over USB and also by WIFI. I always got "unavaiable database". Should i put copy of firebird.conf in same dir as client lib to support remote connections? I have firebird.conf configured only Providers = Engine12. But client library is in "\Firebird\lib\" and firebird.conf is above in "\Firebird\" regards, Karol Bieniaszewski -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-5887) Allow the use of management statements in PSQL blocks
Allow the use of management statements in PSQL blocks - Key: CORE-5887 URL: http://tracker.firebirdsql.org/browse/CORE-5887 Project: Firebird Core Issue Type: Improvement Components: Engine Reporter: Adriano dos Santos Fernandes Current management (SET ... / ALTER SESSION) statements are valid only as top-level statements (and hence in EXECUTE STATEMENT too), i.e., cannot be in EXECUTE BLOCK or stored routine. This is a problem, as some of these statements are good to be executed in ON CONNECT triggers. I propose a simple way to allow them in PSQL. There is no reason to create BLR codes for them. DSQL can generate them as EXECUTE STATEMENT (blr_exec_sql). They will be validated (dsqlPass) as others statements in prepare time, and will be validated as now when executed. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-odbc-devel] Access and DSN ODBC
El 09/08/2018 a las 11:02 a. m., Dimitry Sibiryakov escribió: 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? 3.0.2 (64 bits) -- 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- int. 103 / 406-3278 Correo electrónico: jbrug...@dasu.com.ar Website: www.dasu.com.ar “Un experto es una persona que ha cometido todos los errores que se pueden cometer en un determinado campo.” (Niels Bohr) -- Antes de imprimir este mensaje, piense si es verdaderamente necesario hacerlo. -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Firebird-odbc-devel mailing list Firebird-odbc-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
[Firebird-odbc-devel] Access and DSN ODBC
Hi all.
I have a DSN pointing to a remote (LAN) Firebird database.
I´ve linked tables in Access.
If I close Access and reopen the same database (ACCDB), I get an error
when I try to open a table.
Trace log contains (full log atached):
Farmadev 2788-2e4c EXIT SQLDriverConnectW with return code -1
(SQL_ERROR)
HDBC 0x0036E7D0
HWND 0x004B08E4
WCHAR * 0x07FEDB7230D8 [ -3] "**\ 0"
SWORD -3
WCHAR * 0x07FEDB7230D8
SWORD -3
SWORD * 0x
UWORD 3
DIAG [08004] [ODBC Firebird Driver]Unable to complete network
request to host "xnet://Global\FIREBIRD". (-902)
Farmadev 2788-2e4c ENTER SQLErrorW
HENV 0x11EF8280
HDBC 0x0036E7D0
HSTMT 0x
WCHAR * 0x00279858
SDWORD * 0x00279834
WCHAR * 0x0B6DE040
SWORD 4095
SWORD * 0x00279830
Farmadev 2788-2e4c EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 0x11EF8280
HDBC 0x0036E7D0
HSTMT 0x
WCHAR * 0x00279858 [ 5] "08004"
SDWORD * 0x00279834 (-902)
WCHAR * 0x0B6DE040 [ 90] "[ODBC Firebird
Driver]Unable to complete network request to host "xnet://Global\FIREBIRD"."
SWORD 4095
SWORD * 0x00279830 (90)
I have to update linked tables ("refresh") from the MS Access Linked
Table Manager ("select all", "Ok") to get it work.
Can I fix this issue someway? It´s an Access bug? FBODBC bug?
Thanks
--
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- int. 103 / 406-3278
Correo electrónico: jbrug...@dasu.com.ar
Website: www.dasu.com.ar
“Un experto es una persona que ha cometido todos los errores que se pueden
cometer en un determinado campo.” (Niels Bohr)
--
Antes de imprimir este mensaje, piense si es verdaderamente necesario hacerlo.
Farmadev2788-2e4c ENTER SQLAllocEnv
HENV * 0x00279E38
Farmadev2788-2e4c EXIT SQLAllocEnv with return code 0
(SQL_SUCCESS)
HENV * 0x00279E38 ( 0x11EF8280)
Farmadev2788-2e4c ENTER SQLAllocConnect
HENV0x11EF8280
HDBC * 0x00279938
Farmadev2788-2e4c EXIT SQLAllocConnect with return code 0
(SQL_SUCCESS)
HENV0x11EF8280
HDBC * 0x00279938 ( 0x0036E7D0)
Farmadev2788-2e4c ENTER SQLSetConnectOptionW
HDBC0x0036E7D0
SQLINTEGER 103
SQLPOINTER20
Farmadev2788-2e4c EXIT SQLSetConnectOptionW with return code 0
(SQL_SUCCESS)
HDBC0x0036E7D0
SQLINTEGER 103
SQLPOINTER20
Farmadev2788-2e4c ENTER SQLSetConnectAttrW
SQLHDBC 0x0036E7D0
SQLINTEGER 30002
SQLPOINTER [Unknown attribute 30002]
SQLINTEGER -3
Farmadev2788-2e4c EXIT SQLSetConnectAttrW with return code 0
(SQL_SUCCESS)
SQLHDBC 0x0036E7D0
SQLINTEGER 30002
SQLPOINTER [Unknown attribute 30002]
SQLINTEGER -3
Farmadev2788-2e4c ENTER SQLDriverConnectW
HDBC0x0036E7D0
HWND0x004B08E4
WCHAR * 0x07FEDB7230D8 [ -3] "**\ 0"
SWORD -3
WCHAR * 0x07FEDB7230D8
SWORD -3
SWORD * 0x
UWORD3
Farmadev2788-2e4c EXIT SQLDriverConnectW with return code -1
(SQL_ERROR)
HDBC0x0036E7D0
HWND0x004B08E4
WCHAR * 0x07FEDB7230D8 [ -3] "**\ 0"
SWORD -3
WCHAR * 0x07FEDB7230D8
SWORD -3
SWORD * 0x
UWORD3
DIAG [08004] [ODBC Firebird
