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: Franz B. <fra...@sp...> - 2011-09-05 09:04:04
|
Hi all,
Since I use ODBC driver WI_T2.0.0.151 = OdbcFb.dll = v2-0 I encounter the
behaviour described below.
This is different from the previous version I have used, OdbcFb32.dll =
WI_T2.0.0.142 = v2-0-beta
I use Delphi 7 or XE (does not matter) and odbcfb.dll, Firebird 2.1.4
Host system is Windows XP or Win7, does not matter.
For test purpose I have also used Firebird 2.5, but this does not change the
situation.
It rather seems to be a matter of the ODBC driver than the DB (=datbase)
version.
The DB is accessed from Delphi via ADO and ODBC using the Delphi ADODB
components.
Situation:
I create a test DB, an appropriate ODBC connection to it, and start 2 (test-)
programs acessing the same table concurrently through Delphi ADO Query like
"select * from users"
and display the contents on a Delphi TDbGrid and a TDbNavigator.
the I enter some records, and modify them.
The connection string for the TADOConnection is:
Provider=MSDASQL.1;Password=masterkey;Persist Security Info=True;User
ID=SYSDBA;Data Source=TRANSACTION_TEST
When I start 2 programs concurrently which access the same table, and modify som
records with the firtst program, the oldest transaction does not increment.
The consequece (my assumption) seems to be that the database grows rapidly.
I have originally observed this in a production environment, where records are
updated very frequently, and read by a second program for evaluation purpose.
There I became aware of the unusual growth.
I could reproduce the situation with a small test program. In the production
environment the difference between oldest and next transaction grows to e.g.
100000, but the situation is basically the same as with the test programs.
This can be observerved with:
> gstat -h
D:\FUJITSO\G\SyLab\BT4300\DB_Firebird_uppercase_II\TRANSACTION_TEST.FDB
Database
"D:\FUJITSO\G\SyLab\BT4300\DB_Firebird_uppercase_II\TRANSACTION_TEST.FDB"
Database header page information:
Flags 0
Checksum 12345
Generation 188
Page size 4096
ODS version 11.2
Oldest transaction 149
Oldest active 150
Oldest snapshot 150
Next transaction 181
Bumped transaction 1
Sequence number 0
Next attachment ID 22
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Sep 1, 2011 16:13:59
Attributes force write
Variable header data:
*END*
This behaviour differs from the old ODBC driver version 2.0.0.142.
When I use the old driver, the next transaction will increment in the same way,
but the oldest transaction will also do, so that the difference willl normally
be only 3.
1. How can I overcome this situation?
2. Is there a possibilty to specify a connection parameter to achieve the old
behaviour?
3. I have not found a way to directly issue ODBC statements over the Delphi
ADODB. This component seems to encapsulate ODBC completely. So it might be
difficult to do this, if this is the solution.
Thank you very much
Best regards
Franz Batik
|
|
From: Peter B. <pba...@ra...> - 2011-09-02 12:54:03
|
No. The client is 64-bit (fbclient64.dll) Peter From: Alexander Potapchenko [mailto:ale...@gm...] Sent: Friday, September 02, 2011 8:20 AM To: fir...@li... Subject: Re: [Firebird-odbc-devel] 32 bit ODBC connection on 64 bit machine On 02.09.2011 15:59, Peter Barrett wrote: Hello, I am trying to make a connection between MS Access 2010 32 bit and a Firebird database(Fishbowl Inventory) using ODBC. I am running Windows 7 Home Premium ver. 6.17601 SP 1 on a 64 bit machine. I have installed both the 32 bit and 64 bit Firebird/InterbaseR ODBC drivers ver. 2.00.00.151. I can successfully connect to the database with a system DSN using the 64 bit driver. I cannot make a connection with the 32 bit driver which I believe I need to use with MS Access 32 bit. Any ideas? Would migrating to MS Office 64 bit work? Thanks. Peter Hi, 32-bit ODBC driver requires the 32-bit firebird client (fbclient.dll). Do you have this client version on your computer? Alexander -- Alexander Potapchenko Lead developer LASP technology, http://www.lasptech.ru |
|
From: Alexander P. <ale...@gm...> - 2011-09-02 12:17:48
|
On 02.09.2011 15:59, Peter Barrett wrote: > > Hello, > > I am trying to make a connection between MS Access 2010 32 bit and a > Firebird database(Fishbowl Inventory) using ODBC. I am running Windows > 7 Home Premium ver. 6.17601 SP 1 on a 64 bit machine. I have installed > both the 32 bit and 64 bit Firebird/Interbase® ODBC drivers ver. > 2.00.00.151. I can successfully connect to the database with a system > DSN using the 64 bit driver. I cannot make a connection with the 32 > bit driver which I believe I need to use with MS Access 32 bit. Any > ideas? Would migrating to MS Office 64 bit work? > > Thanks. > > Peter > > Hi, 32-bit ODBC driver requires the 32-bit firebird client (fbclient.dll). Do you have this client version on your computer? Alexander -- Alexander Potapchenko Lead developer LASP technology, http://www.lasptech.ru |
|
From: Peter B. <pba...@ra...> - 2011-09-02 11:59:21
|
Hello, I am trying to make a connection between MS Access 2010 32 bit and a Firebird database(Fishbowl Inventory) using ODBC. I am running Windows 7 Home Premium ver. 6.17601 SP 1 on a 64 bit machine. I have installed both the 32 bit and 64 bit Firebird/InterbaseR ODBC drivers ver. 2.00.00.151. I can successfully connect to the database with a system DSN using the 64 bit driver. I cannot make a connection with the 32 bit driver which I believe I need to use with MS Access 32 bit. Any ideas? Would migrating to MS Office 64 bit work? Thanks. Peter |
|
From: Franz B. <fra...@sp...> - 2011-09-02 09:59:20
|
Hi all,
Since I use ODBC driver WI_T2.0.0.151 = OdbcFb.dll = v2-0 I encounter the
behaviour described below.
This is different from the previous version I have used, OdbcFb32.dll =
WI_T2.0.0.142 = v2-0-beta
I use Delphi 7 or XE (does not matter) and odbcfb.dll, Firebird 2.1.4
Host system is Windows XP or Win7, does not matter.
For test purpose I have also used Firebird 2.5, but this does not change the
situation.
It rather seems to be a matter of the ODBC driver than the DB (=datbase)
version.
The DB is accessed from Delphi via ADO and ODBC using the Delphi ADODB
components.
Situation:
I create a test DB, an appropriate ODBC connection to it, and start 2 (test-)
programs acessing the same table concurrently through Delphi ADO Query like
"select * from users"
and display the contents on a Delphi TDbGrid and a TDbNavigator.
the I enter some records, and modify them.
The connection string for the TADOConnection is:
Provider=MSDASQL.1;Password=masterkey;Persist Security Info=True;User
ID=SYSDBA;Data Source=TRANSACTION_TEST
When I start 2 programs concurrently which access the same table, and modify som
records with the firtst program, the oldest transaction does not increment.
The consequece (my assumption) seems to be that the database grows rapidly.
I have originally observed this in a production environment, where records are
updated very frequently, and read by a second program for evaluation purpose.
There I became aware of the unusual growth.
I could reproduce the situation with a small test program. In the production
environment the difference between oldest and next transaction grows to e.g.
100000, but the situation is basically the same as with the test programs.
This can be observerved with:
> gstat -h
D:\FUJITSO\G\SyLab\BT4300\DB_Firebird_uppercase_II\TRANSACTION_TEST.FDB
Database
"D:\FUJITSO\G\SyLab\BT4300\DB_Firebird_uppercase_II\TRANSACTION_TEST.FDB"
Database header page information:
Flags 0
Checksum 12345
Generation 188
Page size 4096
ODS version 11.2
Oldest transaction 149
Oldest active 150
Oldest snapshot 150
Next transaction 181
Bumped transaction 1
Sequence number 0
Next attachment ID 22
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Sep 1, 2011 16:13:59
Attributes force write
Variable header data:
*END*
This behaviour differs from the old ODBC driver version 2.0.0.142.
When I use the old driver, the next transaction will increment in the same way,
but the oldest transaction will also do, so that the difference willl normally
be only 3.
1. How can I overcome this situation?
2. Is there a possibilty to specify a connection parameter to achieve the old
behaviour?
3. I have not found a way to directly issue ODBC statements over the Delphi
ADODB. This component seems to encapsulate ODBC completely. So it might be
difficult to do this, if this is the solution.
Thank you very much
Best regards
Franz Batik
|
|
From: sadek <sad...@gm...> - 2011-08-28 14:30:02
|
Hello, I have the same issue using SSIS 2008, ZZ did you find a workaround. Thanks, Sadek -- View this message in context: http://firebird.1100200.n4.nabble.com/SSIS-ODBC-ISSUE-tp3497997p3774454.html Sent from the firebird-odbc-devel mailing list archive at Nabble.com. |
|
From: ZZ <ru...@ya...> - 2011-08-15 15:19:06
|
anyone, please...some idea -- View this message in context: http://firebird.1100200.n4.nabble.com/SSIS-ODBC-ISSUE-tp3497997p3744840.html Sent from the firebird-odbc-devel mailing list archive at Nabble.com. |
|
From: Buchas <val...@gm...> - 2011-08-11 14:14:24
|
Yeah, I know that it works from FB. But I want an application which is running on Oracle to access the logic of some other application that is based on Firebird procedures. I was wondering if it can be made using DB link from Oracle to FireBird. -- View this message in context: http://firebird.1100200.n4.nabble.com/Execute-Firebird-procedure-from-Oracle-tp3712219p3735963.html Sent from the firebird-odbc-devel mailing list archive at Nabble.com. |
|
From: Dimitry S. <sd...@ib...> - 2011-08-11 14:12:56
|
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. |
|
From: NickUpson <nic...@gm...> - 2011-08-11 14:10:15
|
that is a different issue, if you run the "select ...." against the firebird database directly it will work -- View this message in context: http://firebird.1100200.n4.nabble.com/Execute-Firebird-procedure-from-Oracle-tp3712219p3735943.html Sent from the firebird-odbc-devel mailing list archive at Nabble.com. |
|
From: Buchas <val...@gm...> - 2011-08-11 14:04:52
|
It does not work. Oracle says "Table or view does not exist." -- View this message in context: http://firebird.1100200.n4.nabble.com/Execute-Firebird-procedure-from-Oracle-tp3712219p3735927.html Sent from the firebird-odbc-devel mailing list archive at Nabble.com. |
|
From: <ul...@gm...> - 2011-08-10 14:50:27
|
Vielen Dank fr Ihr e-mail. Ich bin bis einschlielich 14.8. August mit meiner Familie im verdienten Urlaub. In dringenden Fllen wenden Sie sich bitte an unsere Hotline unter ho...@gm... Ulrich Hutter Programmierung & Geschftsfhrung und stolzer Vater: www.hutter.at/konrad & www.hutter.at/Olivia GMS Zentrale 5582 St.Michael im Lungau, Katschberg 423 Tel: +43/4734/627 50, Fax: +43/4734/627 51 ul...@gm..., www.gms.info Firma: GMS Hutter GmbH & Co KG, Rechtsform: GmbH & Co KG, Firmensitz: Salzburg, Firmenbuchnummer: FN 172325 w, Firmenbuchgericht: Handelsgericht Salzburg, DVR: 1042688, Komplementr: Hutter GmbH, Sitz: 5582 St. Michael, Katschberg 423, FB-Gericht Salzburg, FN 196476k Wichtiger Hinweis: Diese E-Mail kann Betriebs- oder Geschftsgeheimnisse oder sonstige vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtmlich erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine Vervielfltigung oder Weitergabe der E-Mail ausdrcklich untersagt. Bitte benachrichtigen Sie uns und vernichten Sie die empfangene E-Mail. Vielen Dank. such a procedure needs to be called as if it were a table select * from <myprocname> -- View this message in context: http://firebird.1100200.n4.nabble.com/Execute-Firebird-procedure-from-Oracle-tp3712219p3733098.html Sent from the firebird-odbc-devel mailing list archive at Nabble.com. ------------------------------------------------------------------------------ uberSVN's rich system and user administration capabilities and model configuration take the hassle out of deploying and managing Subversion and the tools developers use with it. Learn more about uberSVN and get a free download at: http://p.sf.net/sfu/wandisco-dev2dev _______________________________________________ Firebird-odbc-devel mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel To: fir...@li... |
|
From: NickUpson <nic...@gm...> - 2011-08-10 14:42:39
|
such a procedure needs to be called as if it were a table select * from <myprocname> -- View this message in context: http://firebird.1100200.n4.nabble.com/Execute-Firebird-procedure-from-Oracle-tp3712219p3733098.html Sent from the firebird-odbc-devel mailing list archive at Nabble.com. |
|
From: ZZ <ru...@ya...> - 2011-08-04 18:18:39
|
Hi all, I get in trouble with this again. Recently I have to add a fuzzy lookup to my package, and there is a bug running fuzzy lookup transformation in 32bit mode not resolved at this time ( http://connect.microsoft.com/SQLServer/feedback/details/488387/fuzzy-lookup-triggers-sqldumper-even-with-very-small-dataset-with-run64bitruntime-set-to-false details here ) , so I need to run in 64 (for lookup) but then I can´t make ODBC 2.0 to work with varchar fields. Please, any ideas? -- View this message in context: http://firebird.1100200.n4.nabble.com/SSIS-ODBC-ISSUE-tp3497997p3719461.html Sent from the firebird-odbc-devel mailing list archive at Nabble.com. |
|
From: Buchas <val...@gm...> - 2011-08-02 12:50:23
|
Hello,
I have the following procedure in Firebird:
Code: [Select all] [Show/ hide]
SET TERM ^ ;
ALTER PROCEDURE PINGAS
RETURNS (
RESULT Smallint )
AS
begin
Result = 1;
SUSPEND;
end^
SET TERM ; ^
GRANT EXECUTE
ON PROCEDURE PINGAS TO SYSDBA;
I have created a DB_LINKas from Oracle to Firebird connected to user SYSDBA,
and I am able to access tables from Firebird.
How can I execute the procedure? (It should return 1)
Those tries do not work:
declare
i int;
begin
i:= SYSDBA.PINGAS@STEKAS ;
--Error: identifier 'SYSDBA.PINGAS@DB_LINKas' must be declared.
end;
declare
begin
SYSDBA.PINGAS@STEKAS ;
--Error: identifier 'SYSDBA.PINGAS@DB_LINKas' must be declared.
end;
SELECT p.RESULT FROM PINGAS@DB_LINKas p
--Error: Table or view does not exist
--
View this message in context: http://firebird.1100200.n4.nabble.com/Execute-Firebird-procedure-from-Oracle-tp3712219p3712219.html
Sent from the firebird-odbc-devel mailing list archive at Nabble.com.
|
|
From: Gerardo L. <gl...@ad...> - 2011-07-12 18:12:18
|
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi, I try to connect to a firebird 2 database via php - odbc driver,
but i can't.<br>
<br>
My php code is<br>
<?php<br>
$dbh = odbc_connect('bd1','',''); <br>
$res = odbc_exec($dbh, 'select * from personas');<br>
?><br>
<br>
And when execute results in this error:<br>
<br>
<b>Warning</b>: odbc_exec() [<a
href="http://nicasio/MisPhp/Clipper/prottv/function.odbc-exec">function.odbc-exec</a>]:
SQL error: [unixODBC][ODBC Firebird Driver][Firebird]invalid database
handle (no active connection), SQL state S1000 in SQLExecDirect in <b>/media/windowsd/Informacion/Gerardo/MisPhp/Clipper/prottv/prueba1.php</b>
on line <b>3</b><br>
<br>
Is like, the connection fails isn't it? But when I try to connect from
other sources, like OpenOfficeBase or the utility "DataManager" from
unixodbc i can connect. Even had some problems with the utility
ODBCConfig from unixodbc. When i try use it for create de Dsn drivers,
it show a error message "Could not construct a property list for
(Firebird)" and fires me away. Then I create the content of the
odbcinst.ini odbc.ini with a scite text procesor.<br>
<br>
Well I triying to resolve this five days ago , find documentation, the
web etc. etc. and I can't solve it.<br>
<br>
Could you helpme ? Below (some aditional data about my configuration
files)<br>
Thanks in advance from Uruguay<br>
Gerardo<br>
<br>
I' Using Ubuntu Linux 8.04 LTS<br>
Install unixodbc, and the firebird driver (libOdbcFb.so in
/usr/lib/odbc) and restart the lighty web server.<br>
<br>
<b>My odbcinst.ini file on /etc is</b><br>
<br>
<br>
[ODBC]<br>
FileDSNPath = /etc/ODBCDataSources/<br>
<br>
[Firebird]<br>
Description = InterBase/Firebird ODBC Driver<br>
Driver = /usr/lib/odbc/libOdbcFb.so<br>
Driver64 = <br>
Setup = /usr/lib/odbc/libOdbcFb.so<br>
Setup64 = <br>
UsageCount = <br>
CPTimeout = <br>
CPReuse = <b><br>
<br>
My odbc.ini file on /etc is </b><br>
<br>
[BDBam]<br>
Description = Otra base Firebird <br>
Driver = Firebird<br>
Dbname =
localhost:/media/windowsd/Informacion/Gerardo/MisPhp/Clipper/BDBam.fdb<br>
User = sysdba<br>
Password =masterkey<br>
[bd1]<br>
Description = Prototitpo TodoTv. base firebird<br>
Driver = Firebird<br>
Dbname =
nicasio:/media/windowsd/Informacion/Gerardo/MisPhp/Clipper/bdProTTV.fdb<br>
User = sysdba<br>
Password =masterkey<br>
Role =<br>
CharacterSet =<br>
ReadOnly = No<br>
NoWait = No<br>
<br>
<br>
</body>
</html>
|
|
From: W O <sis...@gm...> - 2011-07-11 10:21:30
|
Thank you very much Nikolay. I believe that I had achieved that, later I'll try with another computer, one that never had Firebird neither ODBC installed. If I get good results then I'll share my findings. Walter. On Mon, Jul 11, 2011 at 5:29 AM, Nikolay Samofatov < nik...@re...> wrote: > ** > It is possible to use driver without registration. In fact we helped > implement "Flash Start" edition for one program. > > One way to do this is to load driver directly, without using driver > manager. > Another way is to use special "proxy" DLL which transparently replaces ODBC > driver manager. > > > On 10.07.2011 23:55, W O wrote: > > Hello everybody > > I want to make an application portable, so the user just plug the pen-drive > and the application works. > > But my application needs an ODBC driver. > > It would be possible to use the ODBC driver without the user installing it? > > Thanks in advance. > > Walter. > > > ------------------------------------------------------------------------------ > All of the data generated in your IT infrastructure is seriously valuable. > Why? It contains a definitive record of application performance, security > threats, fraudulent activity, and more. Splunk takes this data and makes > sense of it. IT sense. And common sense. > http://p.sf.net/sfu/splunk-d2d-c2 > > > _______________________________________________ > Firebird-odbc-devel mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > > > > -- > Nikolay Samofatov, MBA > Red Soft Corporation+7 495 668 3735 > > > > ------------------------------------------------------------------------------ > All of the data generated in your IT infrastructure is seriously valuable. > Why? It contains a definitive record of application performance, security > threats, fraudulent activity, and more. Splunk takes this data and makes > sense of it. IT sense. And common sense. > http://p.sf.net/sfu/splunk-d2d-c2 > _______________________________________________ > Firebird-odbc-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > > |
|
From: Nikolay S. <nik...@re...> - 2011-07-11 10:10:10
|
It is possible to use driver without registration. In fact we helped implement "Flash Start" edition for one program. One way to do this is to load driver directly, without using driver manager. Another way is to use special "proxy" DLL which transparently replaces ODBC driver manager. On 10.07.2011 23:55, W O wrote: > Hello everybody > > I want to make an application portable, so the user just plug the pen-drive and the application works. > > But my application needs an ODBC driver. > > It would be possible to use the ODBC driver without the user installing it? > > Thanks in advance. > > Walter. > > > ------------------------------------------------------------------------------ > All of the data generated in your IT infrastructure is seriously valuable. > Why? It contains a definitive record of application performance, security > threats, fraudulent activity, and more. Splunk takes this data and makes > sense of it. IT sense. And common sense. > http://p.sf.net/sfu/splunk-d2d-c2 > > > _______________________________________________ > Firebird-odbc-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel -- Nikolay Samofatov, MBA Red Soft Corporation +7 495 668 3735 |
|
From: W O <sis...@gm...> - 2011-07-11 01:08:38
|
Ok, excellent, I can do the registration without user's intervention.
Thank you.
Walter.
On Sun, Jul 10, 2011 at 5:29 PM, Alexander Potapchenko <
ale...@gm...> wrote:
> On 10.07.2011 23:55, W O wrote:
>
> Hello everybody
>
> I want to make an application portable, so the user just plug the pen-drive
> and the application works.
>
> But my application needs an ODBC driver.
>
> It would be possible to use the ODBC driver without the user installing it?
>
> Hi,
>
> You can store the Firebird ODBC driver files(OdbcFb.dll, OdbcFb.chm)
> together with your application, but the driver registration in system is
> required.
> Command - regsvr32.exe /s {dir}\OdbcFb.dll
>
> Regards,
> --
> Alexander Potapchenko
> Lead developer
> LASP technology, http://www.lasptech.ru
>
>
> ------------------------------------------------------------------------------
> All of the data generated in your IT infrastructure is seriously valuable.
> Why? It contains a definitive record of application performance, security
> threats, fraudulent activity, and more. Splunk takes this data and makes
> sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-d2d-c2
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>
>
|
|
From: Alexander P. <ale...@gm...> - 2011-07-10 21:28:03
|
On 10.07.2011 23:55, W O wrote:
> Hello everybody
>
> I want to make an application portable, so the user just plug the
> pen-drive and the application works.
>
> But my application needs an ODBC driver.
>
> It would be possible to use the ODBC driver without the user
> installing it?
>
Hi,
You can store the Firebird ODBC driver files(OdbcFb.dll, OdbcFb.chm)
together with your application, but the driver registration in system is
required.
Command - regsvr32.exe /s {dir}\OdbcFb.dll
Regards,
--
Alexander Potapchenko
Lead developer
LASP technology, http://www.lasptech.ru
|
|
From: W O <sis...@gm...> - 2011-07-10 19:55:17
|
Hello everybody I want to make an application portable, so the user just plug the pen-drive and the application works. But my application needs an ODBC driver. It would be possible to use the ODBC driver without the user installing it? Thanks in advance. Walter. |
|
From: Hussein, E. <EHu...@ap...> - 2011-06-22 17:03:09
|
Hi,
I have installed FireBird v2 (32bit) on windows 2008 server that has MS
SQL 2008 R2 installed. I am able to create system DSN ODBC to connect to
my interbase database on different server. However, When I try to import
data from interbase using import/export wizard on SQL, I keep getting
this error :
TITLE: SQL Server Import and Export Wizard
------------------------------
Column information for the source and destination data could not be
retrieved.
"CARRIERS" -> [dbo].[CARRIERS]:
- Index was outside the bounds of the array.
------------------------------
ADDITIONAL INFORMATION:
Index was outside the bounds of the array.
(Microsoft.DataTransformationServices.Controls)
However, I was able to create a linked server to that interbase database
with no problem.
Would you please help fix this issue?
Thanks.
Ehab
|
|
From: Michael M. <m.m...@mb...> - 2011-06-01 08:19:10
|
Hello, for all of you who uses ADODB (MDAC) and a developer machine under windows 7 SP1 http://social.msdn.microsoft.com/Forums/en/windowsgeneraldevelopmentissues/t hread/3a4ce946-effa-4f77-98a6-34f11c6b5a13 Best regards Michael Möhle |
|
From: Vishal B. <vrb...@gm...> - 2011-06-01 04:57:10
|
Hi I had the older version of the ODBC driver installed initially, I uninstalled the ODBC driver and used the following install "Firebird_ODBC_2.0.0.151_Win32.exe" to install the new edition. I Get the Error as in the Screen shop from this System. Should i Uninstall the current odbc driver 2.0.0.151, delete the odbcfb32dll manually ( if for some reason it is still on the system ? ) and then reinstall. Will this new edition solve the problems I am having ? Do you think "Windows Restore" is reserecting the file somehow when i install the new edition even after uninstalling the old one ? Thank you for you time. Best regard Vishal |
|
From: Kirill <pro...@ya...> - 2011-05-27 08:01:25
|
Hello!
I have troubles while integrating Firebird 64bit ODBC driver with Oracle Heterogeneous Connectivity (DG4ODBC).
The ODBC driver version is OdbcFb-LIB-2.0.0151.amd64.tar.gz
The Firebird clients libs is FirebirdCS-2.5.0.26074-0.amd64.rpm
But on the other hand, the 32-bit version Firebird ODBC driver works fine.
Seems to program crashes with an segfault error.
At that time the oracle process generates dump file:
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
shcstkdmp()+110 call kgdsdst() 000000000 ? 000000000 ?
7FFFED89D048 ? 000000001 ?
000000001 ? 000000003 ?
hsssexhd()+85 call shcstkdmp() 000000000 ? 000000000 ?
7FFFED89D048 ? 000000001 ?
000000001 ? 000000003 ?
__sighandler() call hsssexhd() 00000000B ? 000000000 ?
7FFFED89D048 ? 000000001 ?
000000001 ? 000000003 ?
_ZN15OdbcJdbcLibrar signal __sighandler() 00125BB50 ? 00127DDD0 ?
y11OdbcConvert21con 000000001 ? 00126AE10 ?
vVarStringToStringE FEFEFEFEFEFEFEFF ?
PNS_10DescRecordES2 000002177 ?
_()+305
_ZN15OdbcJdbcLibrar call _ZN15OdbcJdbcLibrar 00125BE40 ? 00126B590 ?
y13OdbcStatement27r y11OdbcConvert21con 00126AE10 ? 00126AE10 ?
eturnDataFromExtend vVarStringToStringE FEFEFEFEFEFEFEFF ?
edFetchEv()+323 PNS_10DescRecordES2 000002177 ?
_()
_ZN15OdbcJdbcLibrar call _ZN15OdbcJdbcLibrar 00125BB50 ? 00126B590 ?
y13OdbcStatement9fe y13OdbcStatement27r 00126AE10 ? 00126AE10 ?
tchDataEv()+721 eturnDataFromExtend FEFEFEFEFEFEFEFF ?
edFetchEv() 000002177 ?
_ZN15OdbcJdbcLibrar call _ZN15OdbcJdbcLibrar 00125BB50 ? 00126B590 ?
y13OdbcStatement8sq y13OdbcStatement9fe 00126AE10 ? 00126AE10 ?
lFetchEv()+302 tchDataEv() FEFEFEFEFEFEFEFF ?
000002177 ?
SQLFetch()+34 call _ZN15OdbcJdbcLibrar 00125BB50 ? 00126B590 ?
y13OdbcStatement8sq 00126AE10 ? 00126AE10 ?
lFetchEv() FEFEFEFEFEFEFEFF ?
000002177 ?
SQLFetch()+212 call SQLFetch() 00125BB50 ? 00126B590 ?
00126AE10 ? 00126AE10 ?
FEFEFEFEFEFEFEFF ?
000002177 ?
hgoulcp()+7745 call SQLFetch() 001266C10 ? 00126B590 ?
00126AE10 ? 00126AE10 ?
FEFEFEFEFEFEFEFF ?
000002177 ?
hoxulcp()+160 call hgoulcp() 0011EFBB0 ? 7FFFED8A2B24 ?
7FFFED8A2B28 ? 7FFFED8A2B30 ?
7FFFED8A2B38 ? 00122E6A8 ?
hortrZ_ReceiveUploa call hoxulcp() 0011EFBB0 ? 7FFFED8A2B24 ?
dCaps()+205 7FFFED8A2B28 ? 7FFFED8A2B30 ?
7FFFED8A2B38 ? 00122E6A8 ?
hotker_ExecuteRpcs( call hortrZ_ReceiveUploa 0011EADF0 ? 001219C88 ?
)+2014 dCaps() 0011EFBB0 ?
FFFFFFFFB7FCECAC ?
7FFFED8A2B38 ? 00122E6A8 ?
homtwfr_WaitForRPCs call hotker_ExecuteRpcs( 0011EFBB0 ? 7FFFED8A30C0 ?
()+444 ) 000000000 ? 0011EB360 ?
0011EADF0 ? 00122E6A8 ?
shorm()+329 call homtwfr_WaitForRPCs 0011ECD40 ? 7FFFED8A30C0 ?
() 000000000 ? 0011EB360 ?
0011EADF0 ? 00122E6A8 ?
__do_global_ctors_a call shorm() 000000002 ? 7FFFED8A3C88 ?
ux()+107 000000000 ? 0011EB360 ?
0011EADF0 ? 00122E6A8 ?
__libc_start_main() call __do_global_ctors_a 000000002 ? 7FFFED8A3C88 ?
+244 ux() 000000000 ? 0011EB360 ?
0011EADF0 ? 00122E6A8 ?
_start()+36 call __libc_start_main() 000403AB8 ? 000000002 ?
7FFFED8A3C88 ? 000000000 ?
0011EADF0 ? 000000002 ?
--
Best regards,
Kirill
|
71 messages has been excluded from this view by a project administrator.
