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

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

[Steffen H. (Mailinglisten) <li...@st...>]

Hi

>    Huh? Do you know any difference in LoadLibrary() between Windows
> editions?

Not between "usual" Windows editions, but CE is somewhat special.
See:

http://msdn.microsoft.com/en-us/library/windows/desktop/ms684175%28v=vs.85%2
9.aspx

The function itself does the same in a very similar manner.
However that article includes information about search folders and such.
This is no necessarily equal to CE.

Regards,
  Steffen

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

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

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

[Steffen H. (Mailinglisten) <li...@st...>]

Hi

I don't think Excel is running on Windows CE.
But the cause of the problem might be right.
Just make sure to check the correct msdn article.
NOT the references one.

Regards,
  Steffen


> -----Ursprüngliche Nachricht-----
> Von: Dimitry Sibiryakov [mailto:sd...@ib...]
> Gesendet: Donnerstag, 29. November 2012 18:16
> An: fir...@li...
> Betreff: Re: [Firebird-odbc-devel] Problems with PC clients
> 
> 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:
> VERIFY Test and improve your parallel project with help from experts and
> peers. http://goparallel.sourceforge.net
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

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

[Maury M. <mau...@gm...>]

On 2012-11-29, at 12:45 PM, Jorge Andrés Brugger wrote:

> Use the odbc driver installer 
> (http://www.firebirdsql.org/en/odbc-driver/) on the other machine.

I ran Firebird_ODBC_2.0.0.150_x64 on all of the machines in question.

> Also 
> remove the client part from the connection string.

I did. That causes it to fail on all machines, including the previously working server.

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

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

Use the odbc driver installer 
(http://www.firebirdsql.org/en/odbc-driver/) on the other machine. Also 
remove the client part from the connection string.

El 29/11/2012 01:45 p.m., Maury Markowitz escribió:
> I have an extensive set of reporting tools in Excel that run against the Firebird database in Fishbowl Inventory using a DSN-less ODBC connection string. The string is...
>
> Const cnn = "ODBC;Driver={Firebird/InterBase(r) driver};Client=E:\Fishbowl\odbc\fbclient32.dll;Datasource=192.168.3.200;Database=E:\Fishbowl\database\data\AS SOLAR.FDB;UID=gone;PWD=fishing;"
>
> As you can see, the server has been installed on the E drive, and this sheet works great on that machine.
>
> However, when I move to other machines in the office, I get generic errors - a problem in VBA's reporting of ODBC problems.
>
> So first question... can I point to a client DLL on another machine?
>
> Assuming I could not, I changed the Client= to the path to the DLL on the local machine, but that didn't help.
>
> Any suggestions on how to test this? VBA basically hides all real information in these cases and simply returns "1004"
> ------------------------------------------------------------------------------
> Keep yourself connected to Go Parallel:
> VERIFY Test and improve your parallel project with help from experts
> and peers. http://goparallel.sourceforge.net
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>
>

-- 
Jorge Andrés Brugger
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

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

[Maury M. <mau...@gm...>]

Not the problem then.

On 2012-11-29, at 12:15 PM, Dimitry Sibiryakov wrote:
> 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

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

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

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.

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

[Maury M. <mau...@gm...>]

On 2012-11-29, at 11:57 AM, Dimitry Sibiryakov wrote:
>  Install fbclient.dll to default accessible path using instclient and remove "Client" 
> part from connection string at all.

What is the "default accessible path" in this case?

Fishbowl ships with the 64-bit dll only, installed in it's own Program Files path. Running the installer and pointing it to that dll with the Client line works fine. This is true even on the client machines.

It is only the 32-bit version that appears to be having problems. That was manually installed in the same directory as the 64-bit version. Is this not correct?

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

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

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 installed (not just copied).

-- 
   WBR, SD.

[Firebird-odbc-devel] Problems with PC clients

[Maury M. <mau...@gm...>]

I have an extensive set of reporting tools in Excel that run against the Firebird database in Fishbowl Inventory using a DSN-less ODBC connection string. The string is...

Const cnn = "ODBC;Driver={Firebird/InterBase(r) driver};Client=E:\Fishbowl\odbc\fbclient32.dll;Datasource=192.168.3.200;Database=E:\Fishbowl\database\data\AS SOLAR.FDB;UID=gone;PWD=fishing;"

As you can see, the server has been installed on the E drive, and this sheet works great on that machine.

However, when I move to other machines in the office, I get generic errors - a problem in VBA's reporting of ODBC problems.

So first question... can I point to a client DLL on another machine?

Assuming I could not, I changed the Client= to the path to the DLL on the local machine, but that didn't help.

Any suggestions on how to test this? VBA basically hides all real information in these cases and simply returns "1004"

Re: [Firebird-odbc-devel] Betr.: Re: Which ODBC-driver should I use

[Maury M. <mau...@gm...>]

On 2012-11-27, at 7:27 AM, Peter Stalpers wrote:
> 1. The department bought an application for preparing pharmaceutical medication and this application only supports Firebird as its backend database.
> 2. The department also bought logistcal module and this application only supports Progress as its backend database.
> 3. The department also bought an electronic prescription system and this application only supports a SQL-2005/2008 database.
>  
> And at last I got the question to combine its data.

This is the common case, not the uncommon one. ODBC is perfect for this, although as of late it has not seen the level of attention I think it deserves. I do find it somewhat amusing (ironic?) that this lack of attention stems primarily from MS, who basically invented it. They have shiny new data access methods to play with.

So, my suggestion is to use MS Access as your primary tool to attack this problem. Not in the normal sense of "how one should use Access", but strictly as a forms system and container for VBA. I find using VBA within Access to do ODBC considerably easier than any other tool, say VB or any of the .net languages. The only real downside to Access is that it tends to be rare in many enterprises, and it tends to crash - without data loss however.

Any similar tool will work just as well, and may be more easily redistributed. If such a thing exists, I haven't found it yet.

Maury

Re: [Firebird-odbc-devel] Betr.: Re: Which ODBC-driver should I use

[Kjell R. <kje...@da...>]

<html>
  <head>
    <meta content="text/html; charset=windows-1252"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <br>
    <div class="moz-cite-prefix">Den 2012-11-27 13:27 skrev Peter
      Stalpers såhär:<br>
    </div>
    <blockquote cite="mid:50B...@ts..." type="cite">
      <meta content="text/html; charset=windows-1252"
        http-equiv="Content-Type">
      <meta name="GENERATOR" content="MSHTML 8.00.7601.17514">
      <div>1. The department bought an application for preparing
        pharmaceutical medication and this application only supports
        Firebird as its backend database.</div>
      <div>2. The department also bought logistcal module and this
        application only supports Progress as its backend database.</div>
      <div>3. The department also bought an electronic prescription
        system and this application only supports a SQL-2005/2008
        database.</div>
      <div> </div>
      <div>And at last I got the question to combine its data.</div>
    </blockquote>
    <br>
    You saw it coming, didn't you? :-)<br>
    <br>
    So, what does "combine its data" actually mean?<br>
    Pump data from one system to the other? All directions?<br>
    Analysis and reporting, but not actually copying/moving any data
    around?<br>
    Copying/moving/pumping data from these three systems into a new
    fourth system? And back? And what is the purpose of this fourth
    system, in case it's relevant for us to suggest solutions?<br>
    <br>
    Kjell<br>
    <pre class="moz-signature" cols="72">-- 
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: <a class="moz-txt-link-abbreviated" href="mailto:kj...@da...">kj...@da...</a>
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
</pre>
  </body>
</html>

[Firebird-odbc-devel] 32/64 bit ODBC Firebird Driver Matrix

[mariuz <ma...@ma...>]

I have made a 32/64 bit ODBC Firebird Driver Matrix that could help you
choose the right Firebird odbc driver

http://www.firebirdnews.org/?p=8032

Yes it's related to Firebird odbc driver 32/64 bitness questions on StackOverflow

Re: [Firebird-odbc-devel] Betr.: Re: Which ODBC-driver should I use

[André K. <Kna...@be...>]

> 1. The department bought an application for preparing pharmaceutical
> medication and this application only supports Firebird as its backend
> database.
> 2. The department also bought logistcal module and this application
> only supports Progress as its backend database.
> 3. The department also bought an electronic prescription system and
> this application only supports a SQL-2005/2008 database.
>  
> And at last I got the question to combine its data.

Okay. I agree that it looks a bit weird, but probably the total of all
decisions  still  holds  the most advantages for the entire enterprise
while it might hold downsides for some.

You   should  understand  that  from  our  point  of  view,  using  an
application with Firebird as backend is not the worst you can do ;-).

It's   the  most  stable database even in chaotic environments and the
most  easy  to scale up and/or down that I ever encountered. It offers
the full range of SQL syntax and all types of connectivity.

"Combining"  the  data in your case is not as complicated as it looks.
But I would not necessarily use ODBC for it and so you probably should
direct further questions to another list.

You  need  to  decide  whether  you  want to just look at the data and
analyse  it,  or  if you also want to edit data, probably in all three
applications and probably from only one application.

In the first case you can have a look at basically any reporting tool.

In   the   latter,   personally,   I'd   try  to use .net. to create a
cockpit  to  the  databases.  It   uses  abstraction  for all types of
databases.  Depending on the planned longevity of your project and its
size,  you  can either try to use a RAD approach (drag-drop data items
to  forms) or go in much deeper and create a 3-tier-application with a
data layer of its own.

have fun!
André

[Firebird-odbc-devel] Betr.: Re: Which ODBC-driver should I use

[Peter S. <pst...@ts...>]

1. The department bought an application for preparing pharmaceutical
medication and this application only supports Firebird as its backend
database.
2. The department also bought logistcal module and this application
only supports Progress as its backend database.
3. The department also bought an electronic prescription system and
this application only supports a SQL-2005/2008 database.
 
And at last I got the question to combine its data.

>>> Op Dinsdag 27 November 2012 om 09:22 is in bericht
<50B...@da...> door Kjell Rilbe
<kje...@da...> geschreven:
Den 2012-11-26 12:09 skrev Peter Stalpers såhär:


Can anyone tell me which ODBC-driver I can use for connecting a
Firebird 1.5.6.5026 database to a SQL-2008 R2 server??
Having read this thread with all replies, it's still a bit unclear what
you need to do. You wrote that "the department" has "decided to buy and
use the firebird-application". What does this mean?

1. The department has bought an application for some purpose, and this
application onyl supports Firebird as its backend database?

2. The department has "bought" Firebird and requires that you use it as
"the" database server for your work? In this case "bought" seems odd
considering Firebird is free.

And what is your role in all of this? Is it SQL application
development, installation & administration of a third-party application
with a Firebird backend, or what?

And where does SQL Server 2008 R2 come into the picture apart from
being your preferred database server? (Why?)

I rather do believe there would be somewhat different options depending
on all these factors.

Regards,
Kjell
-- 
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kj...@da...Telefon: 08-761 06 55
Mobil: 0733-44 24 64

========================================================
De informatie verzonden met dit e-mailbericht (en bijlagen) is uitsluitend bestemd voor de geadresseerde(n) en zij die van de geadresseerde(n) toestemming hebben dit bericht te lezen. Gebruik door anderen dan geadresseerde(n) is verboden. De informatie in dit e-mailbericht (en bijlagen) kan vertrouwelijk van aard zijn en kan binnen het bereik vallen van een geheimhoudingsplicht. Het TweeSteden ziekenhuis is niet aansprakelijk voor schade ten gevolge van het gebruik van elektronische middelen van communicatie, daaronder begrepen - maar niet beperkt tot - schade ten gevolge van niet aflevering of vertraging bij de aflevering van elektronische berichten, onderschepping of manipulatie van elektronische berichten door derden of door programmatuur/apparatuur gebruikt voor elektronische communicatie en overbrenging van virussen en andere kwaadaardige programmatuur.

Re: [Firebird-odbc-devel] Which ODBC-driver should I use

[Kjell R. <kje...@da...>]

<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    Den 2012-11-26 12:09 skrev Peter Stalpers s&aring;h&auml;r:<br>
    <blockquote cite="mid:50B...@ts..." type="cite">
      <meta content="text/html; charset=ISO-8859-1"
        http-equiv="Content-Type">
      <meta name="GENERATOR" content="MSHTML 8.00.7601.17514">
      Can anyone tell me which ODBC-driver I can use for connecting a
      Firebird 1.5.6.5026 database to a SQL-2008 R2 server??</blockquote>
    <br>
    Having read this thread with all replies, it's still a bit unclear
    what you need to do. You wrote that "the department" has "decided to
    buy and use the firebird-application". What does this mean?<br>
    <br>
    1. The department has bought an application for some purpose, and
    this application onyl supports Firebird as its backend database?<br>
    <br>
    2. The department has "bought" Firebird and requires that you use it
    as "the" database server for your work? In this case "bought" seems
    odd considering Firebird is free.<br>
    <br>
    And what is your role in all of this? Is it SQL application
    development, installation &amp; administration of a third-party
    application with a Firebird backend, or what?<br>
    <br>
    And where does SQL Server 2008 R2 come into the picture apart from
    being your preferred database server? (Why?)<br>
    <br>
    I rather do believe there would be somewhat different options
    depending on all these factors.<br>
    <br>
    Regards,<br>
    Kjell<br>
    <pre class="moz-signature" cols="72">-- 
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: <a class="moz-txt-link-abbreviated" href="mailto:kj...@da...">kj...@da...</a>
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
</pre>
  </body>
</html>

Re: [Firebird-odbc-devel] Betr.: Re: Which ODBC-driver should I use

[mariuz <ma...@ma...>]

On Mon, Nov 26, 2012 at 06:55:28PM +0100, André Knappstein wrote:
> Firebird _is_ a SQL-dbase.
> 
> "Integration" in that common sense is not possible. MS SQL server will
> not be able to "read" Firebird databases, like it won't read any other
> database format.
> 
> You  're  probably  talking about the "management studio" or any other
> GUI tool which will employ an ODBC driver. You can use the latest ODBC
> driver from www.firebirdsql.org.
> 
> If  you are very much in to using MS SQL, you probably should consider
> using .net provider over ODBC driver.

Another option is to use linked server to firebird database 
but the setup is complex , but doable i only send the steps , you need
to test and try yourself
http://forums.devshed.com/firebird-sql-development-61/linked-server-to-firebird-database-199627.html


> 
> 
> > I just want to integrate Firebird-data into a SQL-dbase. I can use
> > SQL2005 or SQL2008. The department however has decided to buy and use
> > the firebird-application in spite of my comment. I prefer MS-SQL but I
> > have to work with Firebird.
> 
> 
> >>>> Op Maandag 26 November 2012 om 17:17 is in bericht
> > <879...@be...> door André Knappstein
> > <Kna...@be...> geschreven:
> > The easy answer would be: none.
> > Why  would you want to "attach" a Firebird database to a Microsoft SQL
> > Server? These are completely different systems!
> 
> > You  also can't put a DVD into an old style Floppy disk drive; or - if
> > you  can - you will never be able to use the very same DVD again.
> 
> > Suppose that this complete question is not a joke, what is it that you
> > are  trying  to do? Do you have a Firebird database and an application
> > that is reading from a MS SQL server and you want to integrate it?
> 
> 
> 
> >> Hi,
> >>  
> >> Can anyone tell me which ODBC-driver I can use for connecting a
> >> Firebird 1.5.6.5026 database to a SQL-2008 R2 server??
> >>  
> >> Regards, 
> >> Peter
> >>  
> >> Met vriendelijke groet,
> 
> >> Peter Stalpers
> 
> >> Stafmedewerker Informatisering Ziekenhuis Apotheek Midden-Brabant
> >> Systeem/Netwerkbeheerder TweeSteden ziekenhuis 
> >> Tel. + 31 (0) 13 46 55 692
> >> PSt...@ts... 
> 
> >> De informatie verzonden met dit e-mailbericht (en bijlagen) is
> >> uitsluitend bestemd voor de geadresseerde(n) en zij die van de
> >> geadresseerde(n) toestemming hebben dit bericht te lezen. Gebruik
> >> door anderen dan geadresseerde(n) is verboden. De informatie in dit
> >> e-mailbericht (en bijlagen) kan vertrouwelijk van aard zijn en kan
> >> binnen het bereik vallen van een geheimhoudingsplicht. Het
> >> TweeSteden ziekenhuis is niet aansprakelijk voor schade ten gevolge
> >> van het gebruik van elektronische middelen van communicatie,
> >> daaronder begrepen - maar niet beperkt tot - schade ten gevolge van
> >> niet aflevering of vertraging bij de aflevering van elektronische
> >> berichten, onderschepping of manipulatie van elektronische berichten
> >> door derden of door programmatuur/apparatuur gebruikt voor
> >> elektronische communicatie en overbrenging van virussen en andere
> > kwaadaardige programmatuur.
> 
> 
> > ------------------------------------------------------------------------------
> > Monitor your physical, virtual and cloud infrastructure from a single
> > web console. Get in-depth insight into apps, servers, databases,
> > vmware,
> > SAP, cloud infrastructure, etc. Download 30-day Free Trial.
> > Pricing starts from $795 for 25 servers or applications!
> > http://p.sf.net/sfu/zoho_dev2dev_nov 
> > _______________________________________________
> > Firebird-odbc-devel mailing list
> > Fir...@li... 
> > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
> 
> > ========================================================
> > De informatie verzonden met dit e-mailbericht (en bijlagen) is
> > uitsluitend bestemd voor de geadresseerde(n) en zij die van de
> > geadresseerde(n) toestemming hebben dit bericht te lezen. Gebruik
> > door anderen dan geadresseerde(n) is verboden. De informatie in dit
> > e-mailbericht (en bijlagen) kan vertrouwelijk van aard zijn en kan
> > binnen het bereik vallen van een geheimhoudingsplicht. Het
> > TweeSteden ziekenhuis is niet aansprakelijk voor schade ten gevolge
> > van het gebruik van elektronische middelen van communicatie,
> > daaronder begrepen - maar niet beperkt tot - schade ten gevolge van
> > niet aflevering of vertraging bij de aflevering van elektronische
> > berichten, onderschepping of manipulatie van elektronische berichten
> > door derden of door programmatuur/apparatuur gebruikt voor
> > elektronische communicatie en overbrenging van virussen en andere kwaadaardige programmatuur.
> 
> 
> 
> ------------------------------------------------------------------------------
> Monitor your physical, virtual and cloud infrastructure from a single
> web console. Get in-depth insight into apps, servers, databases, vmware,
> SAP, cloud infrastructure, etc. Download 30-day Free Trial.
> Pricing starts from $795 for 25 servers or applications!
> http://p.sf.net/sfu/zoho_dev2dev_nov
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

Re: [Firebird-odbc-devel] Betr.: Re: Which ODBC-driver should I use

[André K. <Kna...@be...>]

Firebird _is_ a SQL-dbase.

"Integration" in that common sense is not possible. MS SQL server will
not be able to "read" Firebird databases, like it won't read any other
database format.

You  're  probably  talking about the "management studio" or any other
GUI tool which will employ an ODBC driver. You can use the latest ODBC
driver from www.firebirdsql.org.

If  you are very much in to using MS SQL, you probably should consider
using .net provider over ODBC driver.



> I just want to integrate Firebird-data into a SQL-dbase. I can use
> SQL2005 or SQL2008. The department however has decided to buy and use
> the firebird-application in spite of my comment. I prefer MS-SQL but I
> have to work with Firebird.


>>>> Op Maandag 26 November 2012 om 17:17 is in bericht
> <879...@be...> door André Knappstein
> <Kna...@be...> geschreven:
> The easy answer would be: none.
> Why  would you want to "attach" a Firebird database to a Microsoft SQL
> Server? These are completely different systems!

> You  also can't put a DVD into an old style Floppy disk drive; or - if
> you  can - you will never be able to use the very same DVD again.

> Suppose that this complete question is not a joke, what is it that you
> are  trying  to do? Do you have a Firebird database and an application
> that is reading from a MS SQL server and you want to integrate it?



>> Hi,
>>  
>> Can anyone tell me which ODBC-driver I can use for connecting a
>> Firebird 1.5.6.5026 database to a SQL-2008 R2 server??
>>  
>> Regards, 
>> Peter
>>  
>> Met vriendelijke groet,

>> Peter Stalpers

>> Stafmedewerker Informatisering Ziekenhuis Apotheek Midden-Brabant
>> Systeem/Netwerkbeheerder TweeSteden ziekenhuis 
>> Tel. + 31 (0) 13 46 55 692
>> PSt...@ts... 

>> De informatie verzonden met dit e-mailbericht (en bijlagen) is
>> uitsluitend bestemd voor de geadresseerde(n) en zij die van de
>> geadresseerde(n) toestemming hebben dit bericht te lezen. Gebruik
>> door anderen dan geadresseerde(n) is verboden. De informatie in dit
>> e-mailbericht (en bijlagen) kan vertrouwelijk van aard zijn en kan
>> binnen het bereik vallen van een geheimhoudingsplicht. Het
>> TweeSteden ziekenhuis is niet aansprakelijk voor schade ten gevolge
>> van het gebruik van elektronische middelen van communicatie,
>> daaronder begrepen - maar niet beperkt tot - schade ten gevolge van
>> niet aflevering of vertraging bij de aflevering van elektronische
>> berichten, onderschepping of manipulatie van elektronische berichten
>> door derden of door programmatuur/apparatuur gebruikt voor
>> elektronische communicatie en overbrenging van virussen en andere
> kwaadaardige programmatuur.


> ------------------------------------------------------------------------------
> Monitor your physical, virtual and cloud infrastructure from a single
> web console. Get in-depth insight into apps, servers, databases,
> vmware,
> SAP, cloud infrastructure, etc. Download 30-day Free Trial.
> Pricing starts from $795 for 25 servers or applications!
> http://p.sf.net/sfu/zoho_dev2dev_nov 
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li... 
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

> ========================================================
> De informatie verzonden met dit e-mailbericht (en bijlagen) is
> uitsluitend bestemd voor de geadresseerde(n) en zij die van de
> geadresseerde(n) toestemming hebben dit bericht te lezen. Gebruik
> door anderen dan geadresseerde(n) is verboden. De informatie in dit
> e-mailbericht (en bijlagen) kan vertrouwelijk van aard zijn en kan
> binnen het bereik vallen van een geheimhoudingsplicht. Het
> TweeSteden ziekenhuis is niet aansprakelijk voor schade ten gevolge
> van het gebruik van elektronische middelen van communicatie,
> daaronder begrepen - maar niet beperkt tot - schade ten gevolge van
> niet aflevering of vertraging bij de aflevering van elektronische
> berichten, onderschepping of manipulatie van elektronische berichten
> door derden of door programmatuur/apparatuur gebruikt voor
> elektronische communicatie en overbrenging van virussen en andere kwaadaardige programmatuur.

[Firebird-odbc-devel] Betr.: Re: Which ODBC-driver should I use

[Peter S. <pst...@ts...>]

I just want to integrate Firebird-data into a SQL-dbase. I can use
SQL2005 or SQL2008. The department however has decided to buy and use
the firebird-application in spite of my comment. I prefer MS-SQL but I
have to work with Firebird.


>>> Op Maandag 26 November 2012 om 17:17 is in bericht
<879...@be...> door André Knappstein
<Kna...@be...> geschreven:
The easy answer would be: none.
Why  would you want to "attach" a Firebird database to a Microsoft SQL
Server? These are completely different systems!

You  also can't put a DVD into an old style Floppy disk drive; or - if
you  can - you will never be able to use the very same DVD again.

Suppose that this complete question is not a joke, what is it that you
are  trying  to do? Do you have a Firebird database and an application
that is reading from a MS SQL server and you want to integrate it?



> Hi,
>  
> Can anyone tell me which ODBC-driver I can use for connecting a
> Firebird 1.5.6.5026 database to a SQL-2008 R2 server??
>  
> Regards, 
> Peter
>  
> Met vriendelijke groet,

> Peter Stalpers

> Stafmedewerker Informatisering Ziekenhuis Apotheek Midden-Brabant
> Systeem/Netwerkbeheerder TweeSteden ziekenhuis 
> Tel. + 31 (0) 13 46 55 692
> PSt...@ts... 

> De informatie verzonden met dit e-mailbericht (en bijlagen) is
> uitsluitend bestemd voor de geadresseerde(n) en zij die van de
> geadresseerde(n) toestemming hebben dit bericht te lezen. Gebruik
> door anderen dan geadresseerde(n) is verboden. De informatie in dit
> e-mailbericht (en bijlagen) kan vertrouwelijk van aard zijn en kan
> binnen het bereik vallen van een geheimhoudingsplicht. Het
> TweeSteden ziekenhuis is niet aansprakelijk voor schade ten gevolge
> van het gebruik van elektronische middelen van communicatie,
> daaronder begrepen - maar niet beperkt tot - schade ten gevolge van
> niet aflevering of vertraging bij de aflevering van elektronische
> berichten, onderschepping of manipulatie van elektronische berichten
> door derden of door programmatuur/apparatuur gebruikt voor
> elektronische communicatie en overbrenging van virussen en andere
kwaadaardige programmatuur.


------------------------------------------------------------------------------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases,
vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov 
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li... 
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

========================================================
De informatie verzonden met dit e-mailbericht (en bijlagen) is uitsluitend bestemd voor de geadresseerde(n) en zij die van de geadresseerde(n) toestemming hebben dit bericht te lezen. Gebruik door anderen dan geadresseerde(n) is verboden. De informatie in dit e-mailbericht (en bijlagen) kan vertrouwelijk van aard zijn en kan binnen het bereik vallen van een geheimhoudingsplicht. Het TweeSteden ziekenhuis is niet aansprakelijk voor schade ten gevolge van het gebruik van elektronische middelen van communicatie, daaronder begrepen - maar niet beperkt tot - schade ten gevolge van niet aflevering of vertraging bij de aflevering van elektronische berichten, onderschepping of manipulatie van elektronische berichten door derden of door programmatuur/apparatuur gebruikt voor elektronische communicatie en overbrenging van virussen en andere kwaadaardige programmatuur.

Re: [Firebird-odbc-devel] Which ODBC-driver should I use

[André K. <Kna...@be...>]

The easy answer would be: none.
Why  would you want to "attach" a Firebird database to a Microsoft SQL
Server? These are completely different systems!

You  also can't put a DVD into an old style Floppy disk drive; or - if
you  can - you will never be able to use the very same DVD again.

Suppose that this complete question is not a joke, what is it that you
are  trying  to do? Do you have a Firebird database and an application
that is reading from a MS SQL server and you want to integrate it?



> Hi,
>  
> Can anyone tell me which ODBC-driver I can use for connecting a
> Firebird 1.5.6.5026 database to a SQL-2008 R2 server??
>  
> Regards, 
> Peter
>  
> Met vriendelijke groet,

> Peter Stalpers

> Stafmedewerker Informatisering Ziekenhuis Apotheek Midden-Brabant
> Systeem/Netwerkbeheerder TweeSteden ziekenhuis 
> Tel. + 31 (0) 13 46 55 692
> PSt...@ts...

> De informatie verzonden met dit e-mailbericht (en bijlagen) is
> uitsluitend bestemd voor de geadresseerde(n) en zij die van de
> geadresseerde(n) toestemming hebben dit bericht te lezen. Gebruik
> door anderen dan geadresseerde(n) is verboden. De informatie in dit
> e-mailbericht (en bijlagen) kan vertrouwelijk van aard zijn en kan
> binnen het bereik vallen van een geheimhoudingsplicht. Het
> TweeSteden ziekenhuis is niet aansprakelijk voor schade ten gevolge
> van het gebruik van elektronische middelen van communicatie,
> daaronder begrepen - maar niet beperkt tot - schade ten gevolge van
> niet aflevering of vertraging bij de aflevering van elektronische
> berichten, onderschepping of manipulatie van elektronische berichten
> door derden of door programmatuur/apparatuur gebruikt voor
> elektronische communicatie en overbrenging van virussen en andere kwaadaardige programmatuur.

[Firebird-odbc-devel] Which ODBC-driver should I use

[Peter S. <pst...@ts...>]

BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:Peter Stalpers
TEL;WORK:013 4655692
ORG:;Apotheek 
TEL;PREF;FAX:013 4672819
EMAIL;WORK;PREF;NGW:pst...@ts...
N:Stalpers;Peter
TITLE:Stafmedewerker
END:VCARD

[Firebird-odbc-devel] ODBC 64 crash

[Laurs L. <la...@ho...>]

I have been working some years with Firebird 1.5 with ODBC 1.2

I am now trying to convert databases to v 2.5 x64 with Firebird_ODBC_2.0.1.152_x64 and 
succeded to recreate at 2.5 database with gbak 
(and I can see all data in the database with DBexplorer (old Borland 5)). 

My software is 32 bit Visual Studio C++ 2008 and I am testing it under 
Windows 7 x64.

It was all working in win7x64 with Firebird 1.5 with ODBC 1.2 under win 7x64.
I deinstalled all Firebird and ODBC and installed the 64 bit versions. 
After that:
I can connect to the database with ODBC, I can open tables, but when I read 
from them, the program crashes somewhere in the code in free(); when I frees 
the data pointers after reading data. 
The data pointers used are for Bind / Fetch like:
SQLPOINTER pdata11 = NULL; 
pdata11 = (SQLPOINTER)malloc(__iintmaxdatalen+2); 
ret = SQLBindCol(odbchnd_->StmtHandle, 
                 ivar11, 
                 SQL_C_BINARY, 
                 (SQLPOINTER) pdata11, 
                 __iintmaxdatalen, 
                 & pcbValue11
);
Its different for different tables when it crashes, but I get errors from HeapFree.
The ODBC software I use is an old example from MS (maybee MS visual 6), but it 
compiles and loads all the jdbc/odbc drivers at start.
Any ideas/help are appreciated. 
Best Regards
Laurs Laursen
Denmark 		 	   		  

Re: [Firebird-odbc-devel] ODBC on Windows 8

[André K. <Kna...@be...>]

Wow! Works! Thanks so much.
I   hope  you will be in Luxemburg, so I can at least spend a round of
beer or wine in return.

> I have attached a snapshot of ODBC driver that can work with Win 8 here
> http://tracker.firebirdsql.org/browse/ODBC-151

> On 15.10.2012 15:03, André Knappstein wrote:
>> Thanks,  but I think that nevertheless I must give up for now and wait
>> until there is a version for mouse-jostlers like me.
>>
>> I finally found the directory of the code, but I did not see any entry
>> for 2.x in a standard browser.
>>
>> I tried different CVS clients to get it, but no luck so far.
>> A  tool called SmartCVS has options for Proxy, but I get I/O error, so
>> probably authentication does not work properly.
>> 2  other  tools called "TortoiseCVS" and "WinCVS" obviously don't even
>> have options for working behind a secure proxy.
>>
>> But  even  if  I  will solve  this  one as soon as I can manage to get
>> away  from  behind  the  security  server,   I   still expect problems
>> building the driver myself using VS2010 or VS2012.
>>
>> Please notify the list as soon as there is a new build available.
>>
>> Until  then I can either give the Win-8 boxes to people not relying on
>> older  Crystal  Reports  or  make  more speed in converting CRs to use
>> ADO.net instead of ODBC.

Re: [Firebird-odbc-devel] ODBC on Windows 8

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

I have attached a snapshot of ODBC driver that can work with Win 8 here 
http://tracker.firebirdsql.org/browse/ODBC-151

On 15.10.2012 15:03, André Knappstein wrote:
> Thanks,  but I think that nevertheless I must give up for now and wait
> until there is a version for mouse-jostlers like me.
>
> I finally found the directory of the code, but I did not see any entry
> for 2.x in a standard browser.
>
> I tried different CVS clients to get it, but no luck so far.
> A  tool called SmartCVS has options for Proxy, but I get I/O error, so
> probably authentication does not work properly.
> 2  other  tools called "TortoiseCVS" and "WinCVS" obviously don't even
> have options for working behind a secure proxy.
>
> But  even  if  I  will solve  this  one as soon as I can manage to get
> away  from  behind  the  security  server,   I   still expect problems
> building the driver myself using VS2010 or VS2012.
>
> Please notify the list as soon as there is a new build available.
>
> Until  then I can either give the Win-8 boxes to people not relying on
> older  Crystal  Reports  or  make  more speed in converting CRs to use
> ADO.net instead of ODBC.

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

Re: [Firebird-odbc-devel] ODBC on Windows 8

[André K. <Kna...@be...>]

Thanks,  but I think that nevertheless I must give up for now and wait
until there is a version for mouse-jostlers like me.

I finally found the directory of the code, but I did not see any entry
for 2.x in a standard browser.

I tried different CVS clients to get it, but no luck so far.
A  tool called SmartCVS has options for Proxy, but I get I/O error, so
probably authentication does not work properly.
2  other  tools called "TortoiseCVS" and "WinCVS" obviously don't even
have options for working behind a secure proxy.

But  even  if  I  will solve  this  one as soon as I can manage to get
away  from  behind  the  security  server,   I   still expect problems
building the driver myself using VS2010 or VS2012.

Please notify the list as soon as there is a new build available.

Until  then I can either give the Win-8 boxes to people not relying on
older  Crystal  Reports  or  make  more speed in converting CRs to use
ADO.net instead of ODBC.

> You can get the source code from CVS:

> http://www.firebirdsql.org/en/odbc-driver/ Section: Developers

> On 15.10.2012 10:33, André Knappstein wrote:
>> Thanks  for  the confirmation, I have been reading the list before but
>> did not find any hint on that.
>>
>> Please  excuse  the  ignorance.  I  tried my best but did not find any
>> place from where I can get the version 2.02 or the source code.
>> What can I do to find/get it, please?
>>
>> So  far,  I  have  only very limited experience with using open source
>> code and compiling it myself.