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

[Stefan Genov via Firebird-odbc-devel]

Hello all :)
I need to use firebird with a windows application which does not have admin 
rights for install or run.I cannot figure out how can I use odbc driver without 
installing it - I don't even know if it's possible.
I searched the net, found almost no information
In this article it is stated that it is easy - just specify the OdbcFb.dll in 
the connection 
string.https://stackoverflow.com/questions/54826254/connect-odbc-without-driver-installed
But the post also says that I have to link the OdbcFb.lib in my exe. I use 
Delphi (XE7) for that project and I think I cannot link a lib file.Maybe I 
could build a small c++ app just for executing the lib file somehow before 
starting my Delphi app? 
Other things I tried were writing a odbc.ini, odbcinst.ini files in my app 
folder and trying to describe the provider name and dll name there.
The error remains pretty much the same:[Microsoft][ODBC Driver Manager] Data 
source name not found and no default driver specified.

Please help - is there a way to use the odbc driver on windows without 
installing it from a Delphi application.
Thanks in advance,Stefan.___
Firebird-odbc-devel mailing list
Firebird-odbc-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-6024) FB3.0.4.33063 vs FB3.0.5.33100 manual plan cause "index cannot be used in the specified plan"

[Karol Bieniaszewski (JIRA)]

FB3.0.4.33063 vs FB3.0.5.33100 manual plan cause "index cannot be used in the 
specified plan"
-

 Key: CORE-6024
 URL: http://tracker.firebirdsql.org/browse/CORE-6024
 Project: Firebird Core
  Issue Type: Bug
 Environment: Windows 2008R2
FB3.0.5.33100
Reporter: Karol Bieniaszewski


Something was broken between versions FB3.0.4.33063 vs FB3.0.5.33100
Under FB3.0.4.33063 there was possibility to specify ordered plan for this 
query now in FB3.0.5.33100 it is not possible.

Also look why this ordered plan is not default generated by the engine.


CREATE TABLE WPLATA
(
  DYR_ID Smallint NOT NULL,
  OKRES_NUMER Char(7) NOT NULL,
  INSP_ID Smallint NOT NULL,
  KONTO_ID Smallint NOT NULL,
  WPLATA_DATA_WYCIAGU Date NOT NULL,  
  WPLATA_NR_WYCIAGU Varchar(10) NOT NULL,
  WPLATA_NR_POZYCJI Smallint NOT NULL,
  CONSTRAINT PK_WPLATA PRIMARY KEY 
(DYR_ID,INSP_ID,KONTO_ID,WPLATA_DATA_WYCIAGU,WPLATA_NR_WYCIAGU,WPLATA_NR_POZYCJI)
);

CREATE INDEX IXA_WPLATA__KONTRAHENT__PK ON WPLATA (WPLATA_KONTRAHENT_ID,DYR_ID);

-

SELECT
W.DYR_ID
, W.INSP_ID
, W.KONTO_ID
, W.WPLATA_DATA_WYCIAGU
, W.WPLATA_DATA_WPLATY
, W.WPLATA_NR_WYCIAGU
, W.WPLATA_NR_POZYCJI
FROM
WPLATA W
WHERE 
W.WPLATA_KONTRAHENT_ID IN (1452)
AND W.DYR_ID = 6  
PLAN(W ORDER PK_WPLATA INDEX(IXA_WPLATA__KONTRAHENT__PK))  
ORDER BY
W.DYR_ID
, W.INSP_ID
, W.KONTO_ID
, W.WPLATA_DATA_WYCIAGU
, W.WPLATA_NR_WYCIAGU
, W.WPLATA_NR_POZYCJI

-

index PK_WPLATA cannot be used in the specified plan.


engine generate PLAN SORT (W INDEX (IXA_WPLATA__KONTRAHENT__PK)) which is not 
efficient


-- 
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




Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel